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

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

Serving Software Downloads in 976 Categories, Downloaded 29.876.814 Times

DBIx::HTML::ClientDB 1.05

  Date Added: April 15, 2010  |  Visits: 592


Report Broken Link
Printer Friendly Version

Product Homepage
Download (70 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, nor any of that kidney, are used by this module. We simply output pure HTML. However, for simplicity, this document pretends you are using 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
More Reviews or Write Review

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  -  Pod::Html 5.9.4
Pod::Html is a Perl module to convert pod files to HTML. SYNOPSIS use Pod::Html; pod2html([options]); Converts files from pod format (see perlpod) to HTML format. It can automatically generate indexes and cross-references, and it keeps a...
13.6 MB  
Libraries  -  DBIx::XMLMessage 0.05
DBIx::XMLMessage is a Perl module for XML Message exchange between DBI data sources. The package maintains simple XML templates that describe object structure. The package is capable of generating SQL statements based on these templates and...
25.6 KB  
Libraries  -  DBIx::Class::Manual::Cookbook 0.08001
DBIx::Class::Manual::Cookbook is a Perl module that contains miscellaneous recipes. Paged results When you expect a large number of results, you can ask DBIx::Class for a paged resultset, which will fetch only a small number of records at a...
286.72 KB  
Libraries  -  SQL::Schema 0.31
SQL::Schema is a Perl module to convert a data dictionary into SQL statements. SYNOPSIS use DBI; my $dbh = DBI->connect(...); use SQL::Schema; my $schema = SQL::Schema->new($dbh); my $sql = $schema->string; print $sql; print...
33.79 KB  
Libraries  -  Convert::EastAsianWidth 0.03
Convert::EastAsianWidth is a Perl module that can convert between full- and half-width characters. SYNOPSIS # Exports to_fullwidth() and to_halfwidth() by default use Convert::EastAsianWidth; my $u = to_fullwidth(ABC); # Full-width variant...
14.34 KB  
Libraries  -  Convert::Braille 0.05
Convert::Braille is a Perl module that can convert Between Braille Encodings. SYNOPSIS use Convert::Braille; print brailleAsciiToUnicode ( "HELLO" ), "n"; print brailleDotsToAscii ( "12515123123135" ), "n"; EXPORTS brailleDotsToUnicode...
8.19 KB  
Libraries  -  Convert::Braille::English 0.05
Convert::Braille::English is a Perl module that can convert Between Braille Encodings. SYNOPSIS use Convert::Braille; print brailleAsciiToEnglish ( "HELLO" ), "n"; print brailleDotsToEnglish ( "12515123123135" ), "n"; EXPORTS...
8.19 KB  
Libraries  -  Convert::Braille::Ethiopic 0.05
Convert::Braille::Ethiopic is a Perl module that can convert Between Braille Encodings. SYNOPSIS use Convert::Braille::Ethiopic; print brailleAsciiToEthiopic ( "S5LAM" ), "n"; print brailleDotsToEthiopic ( "234261231134" ), "n"; EXPORTS...
8.19 KB  
Libraries  -  SQL::Routine::Language 0.70.3
SQL::Routine::Language is a Perl module for what language or grammar SQL::Routine speaks. SQL::Routine contains SQL schemas and queries, represented as a tree of atomic tokens; it is structurally like an abstract syntax tree or an XML DOM, but...
174.08 KB  
Programming  -  FLEX-db Digital Asset Manager 3.0.9
FLEX-db - an enterprise Digital Asset Manager (DAM). It ingests and links metadata with files, creates thumbnails, and processes files using business rules. FLEX-db has a JSP client, Java app server for file input and output and an EJB metadata...
21.57 MB  
Programming  -  Libicom 0.9.0
The libicom library is a character based dynamicly linked library for Linux. It is used to remotely control the Icom IC-R8500 wide band receiver via an RS232 link. All call and return parameters to the control functions are character string based....
20.48 KB  
Programming  -  dotdesktop 0.3
Dotdesktop library provides ability to parse desktop entry file and access the information in a convenient way. Desktop entry file format is defined by, it is used to describe information about an application such as the name and...
327.68 KB  
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  -  libyasl 0.2
Libyasl is a C++ class library to easily realize TCP/UDP/Multicast clientsand servers in IPv4 and IPv6 environments under GNU/Linux systems.
143.36 KB  
Libraries  -  wolfSSL 3.11.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...
2.73 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