Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 956 Categories, Downloaded 49.483.839 Times

DBIx::HTML::ClientDB 1.05

  Date Added: April 15, 2010  |  Visits: 823

DBIx::HTML::ClientDB

Report Broken Link
Printer Friendly Version


Product Homepage
Download (87 downloads)



DBIx::HTML::ClientDB is a Perl module to convert sql into a client-side db with keyed access. Synopsis use DBIx::HTML::ClientDB; my($object) = DBIx::HTML::ClientDB -> new ( dbh => $dbh, row_headings => Unit code,Unit code,Campus name,Unit name, sql => select unit_code, unit_code, campus_name, unit_name . from unit, campus where unit_campus_id = campus_id . order by unit_code, ); print $object -> javascript_for_client_db(); print $object -> table(); print $object -> javascript_for_client_init(); This module takes a db handle, an SQL statement and a specially-formatted row_headings parameter, and builds an array of rows as returned by the SQL. Then you ask for that array in HTML, ie as a table. After a call to the table() method, you can call the size() method if you need to check how many rows were returned by the SQL you used. Neither the module CGI.pm, nor any of that kidney, are used by this module. We simply output pure HTML. However, for simplicity, this document pretends you are using CGI.pm rather than an alternative. The sentences would become too convoluted otherwise. The output table is formatted as N rows of 2 columns: First column The first column contains the row headings you supply in the row_headings parameter. row_headings is a comma-separated list of strings you want to appear in the first column of the table. There must be one string in row_headings for each column mentioned in the SQL. Second column The second column contains the current record in the database. Now for the rows: First row The first row contains the first prompt string in the first column. The first row contains a HTML popup menu in the second column. This menu is what you use to choose the current record in the database. Since two (2) SQL columns are used to build this menu, two (2) strings from the row_headings parameter are consumed building the first row. The first of these 2 strings appears in the first column, as explained above. The second of these 2 strings is, much to your amazement, discarded! This way of doing things makes it easy for you to count row_heading strings and their corresponding SQL columns, and makes it easy for me to cross-check your ability to count to 2. Other rows Each other row contains a field in the current record. The value in the first column comes from the row_headings parameter, and the value in the second column comes from the database. The sum result is menu-driven access to the data returned by the SQL. All this is downloaded from your CGI script to the web client. Since changing the current menu item updates the other fields in this table using JavaScript, no message is sent to the web server, and hence you have maximum speed of access. The whole point of the exercise is to give you simple code for simple access to simple data. See examples/test-clientdb.cgi for an example which will make all this clear..

Requirements: No special requirements
Platforms: Linux
Keyword: Clientdb Column Convert Sql Dbix Dbixhtmlclientdb First Headings Html Libraries Module Perl Module Programming Row Unit
Users rating: 0/10

License: Freeware Size: 11.26 KB
USER REVIEWS
More Reviews or Write Review


DBIX::HTML::CLIENTDB RELATED
Database Tools  -  Convert SQL to Excel 10
This tool converts SQL table or query results (multiple resultset) to MS Excel file (.xls file). With the help of Convert SQL to Excel you'll be able to easily turn SQL queries as well as tables into XLS files. This tool also allows you to...
 
Libraries  -  DBIx::Class::Schema::Loader::RelBuilder 0.03007
DBIx::Class::Schema::Loader::RelBuilder is a Perl module that builds relationships for DBIx::Class::Schema::Loader. This class builds relationships for DBIx::Class::Schema::Loader. This is module is not (yet) for external use. METHODS new...
32.77 KB  
Libraries  -  DBIx::Class::FormTools 0.000004
DBIx::Class::FormTools is a utility module for building forms with multiple related DBIx::Class objects. SYNOPSIS In the examples I use 3 objects, a Film, an Actor and a Role. Role is a many to many relation between Film and Actor. package...
9.22 KB  
Libraries  -  Pod::HTML_Elements 0.05
Pod::HTML_Elements is a Perl module to convert POD to tree of LWPs HTML::Element and hence HTML or PostScript. SYNOPSIS use Pod::HTML_Elements; my $parser = new Pod::HTML_Elements; $parser->parse_from_file($pod,foo.html); my $parser = new...
9.22 KB  
Libraries  -  Pod::Simple::HTMLBatch 3.04
Pod::Simple::HTMLBatch is a Perl module to convert several Pod files to several HTML files. SYNOPSIS perl -MPod::Simple::HTMLBatch -e Pod::Simple::HTMLBatch::go in out This module is used for running batch-conversions of a lot of HTML...
256 KB  
Automotive Information Databases  -  Online Database Converter 1.00
Online database converter allows you to convert dbf files to csv, sql, xml, xls, mdb, pdb, html, excel, access formats and vise versa. It displays command line parameetrs in WYSIWYG mode, allows you to select source files and a target file or...
502 KB  
Automotive Information Databases  -  DBF Converters Shell 1.5
Handy shell for DBF converters allows you to convert dbf files to csv, sql, xml, xls, mdb, pdb, html, excel, access formats and vise versa. It displays command line parameetrs in WYSIWYG mode, allows you to select source files and a target file or...
693 KB  
Libraries  -  FUNDAMENTALS SQL PARSER 4.00.01
FUNDAMENTALS SQL PARSER was specially developed as an accessible and handy Delphi / FreePascal unit that can help you parse SQL files. Now you can make use of this handy library to improve your development process.
 
Utilities  -  office Convert Pdf to Website Free 6.1
office Convert Pdf to Website for Htm Html Free can easily make your PDF documents visible and fully searchable on the Internet to significantly increase your site audience while preserving text, pictures, graphics, table, links etc, using the...
3.21 MB  
Modules  -  First Atlantic Commerce Payment Module 1.6
OsCommerce Payment Module for First Atlantic Commerce. Version 1.1 supports CVV but not 3D Secure or AVS. Works with the orderid modification to checkout_process.php to allow the oscommerce orderid and the First Atlantic Commerce orderid to match.
 
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  Math::GMPf 0.29
Math::GMPf - perl interface to the GMP library's floating point (mpf) functions.
30.72 KB  
Programming  -  Net::Wire10 1.08
Net::Wire10 is a Pure Perl connector that talks to Sphinx, MySQL and Drizzle servers. Net::Wire10 implements the low-level network protocol, alias the MySQL wire protocol version 10, necessary for talking to one of the aforementioned...
30.72 KB  
Programming  -  logilab-common 0.56.2
a bunch of modules providing low level functionnalities shared among some python projects devel Please note that some of the modules have some extra dependencies. For instance, logilab.common.db will require a db-api 2.0 compliant...
174.08 KB  
Programming  -  OpenSSL for linux 1.0.0a
The OpenSSL Project is a collaborative effort to develop a robust, commercial-grade, full-featured, and Open Source toolkit implementing the Secure Sockets Layer (SSL v2/v3) and Transport Layer Security (TLS v1) protocols as well as a...
3.83 MB  
Libraries  -  wolfSSL 4.0.0
The wolfSSL embedded SSL/TLS library is a lightweight SSL library written in ANSI standard C and targeted for embedded and RTOS environments - primarily because of its small size, speed, and feature set. It is commonly used in standard operating...
3.88 MB  
Libraries  -  EuGTK 4.8.9
Makes it easy to develop good- looking, fast, cross-platform programs that run on Linux, OS X, and Windows. Euphoria is a very fast interpreted/compiled language with straight-forward syntax. EuGTK allows programming in a clean, object-oriented...
10.68 MB  
Libraries  -  Linux User Group Library Manager 1.0
The LUG Library Manager is a project to help Linux User Groups start their own library. A LUG library is helpful to the community at large because it increases access to information, and gives everyone the opportunity to become more knowledgeable.
5.35 KB  
Libraries  -  Module::MakefilePL::Parse 0.12
Module::MakefilePL::Parse is a Perl module to parse required modules from Makefile.PL. SYNOPSIS use Module::MakefilePL::Parse; open $fh, Makefile.PL; $parser = Module::MakefilePL::Parse->new( join("", ) ); $info = $parser->required;...
8.19 KB  
Libraries  -  sqlpp 0.06
sqlpp Perl package is a SQL preprocessor. sqlpp is a conventional cpp-alike preprocessor taught to understand SQL ( PgSQL, in particular) syntax specificities. In addition to the standard #define/#ifdef/#else/#endif cohort, provides also...
10.24 KB