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.479.599 Times

AxKit::XSP::ESQL 1.4

  Date Added: July 25, 2010  |  Visits: 822

AxKit::XSP::ESQL

Report Broken Link
Printer Friendly Version


Product Homepage
Download (88 downloads)



AxKit::XSP::ESQL is an Extended SQL taglib for AxKit eXtensible Server Pages. SYNOPSIS Add the esql: namespace to your XSP < xsp:page > tag: < xsp:page language="Perl" xmlns:xsp="http://apache.org/xsp/core/v1" xmlns:esql="http://apache.org/xsp/SQL/v2" > And add this taglib to AxKit (via httpd.conf or .htaccess): AxAddXSPTaglib AxKit::XSP::ESQL This tag library provides extensive support for executing SQL statements from within XSP. This tag library is the same as the Cocoon ESQL taglib. TAG REFERENCE Note that below we use the esql: prefix as a convention, however you can use whatever prefix you like provided it is mapped to the appropriate namespace. < esql:connection> parent: none This is the required wrapper element that declares your connection. < esql:driver> parent: < esql:connection> The contents of this element define the DBI driver to be used. For example, Pg, Sybase, Oracle. You can also add an optional attribute: transactions=no to the driver element, to indicate that this driver does not support transactions (or just that you dont want to use transactions). < esql:dburl> parent: < esql:connection> The name of this tag is a hang-over from the Cocoon (Java) version. In the AxKit version this is simply anything that goes after the driver in the connection string. So for PostgreSQL you might have in here dbname=axkit, to connect to the "axkit" database. The full connect string is constructed as follows: "dbi:$driver" . ($dburl ? ":$dburl" : "") See your DBD driver documentation for more details on what is valid for the connection string. < esql:username> parent: < esql:connection> The username to connect to the database with. < esql:password> parent: < esql:connection> The password to use to connect to the database. < esql:execute-query> parent: < esql:connection> This tag is a wrapper tag around queries. You may have as many queries as you like within a single < esql:connection> tag. < esql:skip-rows> parent: < esql:execute-query> The contents of this tag (which may be an < xsp:expr>) define a number of rows to skip forward in the result set. < esql:max-rows> parent: < esql:execute-query> The maximum number of rows to return. < esql:query> parent: < esql:execute-query> The contents of this tag define the query to be executed. < esql:parameter> parent: < esql:query> This tag can be put in your SQL query everywhere you might put a ? in your SQL in DBI. ESQL is intelligent enough to create a cached statement when you do this, and only execute your code when necessary. You put an expression (or another taglib) within the parameter tag (see the example below). < esql:results> parent: < esql:execute-query> The contents of this tag are "executed" whenever the query returns some results. < esql:row-results> parent: < esql:results> The contents of this tag are "executed" for each row of the results < esql:get-columns> parent: < esql:row-results> This tag gets all of the columns in the current row, and outputs them as < column_name>value< /column_name>. If you specify an attribute tag-case="upper", all columns are upper case. Alternatively, "lower" gives you all tags in lower case. An ancestor attribute is also allowed, see "Nested Results" below for more details. get-* parent: < esql:row-results> These are: get-column get-string get-boolean get-double get-float get-int get-long get-short (and more below) Each of these takes either an attribute column="name", or a child tag, < esql:column> which gives the column name. Alternatively either the attribute or child element can be an integer (starting at 1) specifying the column number. Also allowed is an ancestor attribute, which is an integer (default 0), which indicates how far up the nested results you go. See Nested Results below. < esql:get-date>, < esql:get-time>, < esql:get-timestamp> parent: < esql:row-results> These tags are the same as get-* above, except they also take a format="..." attribute, which contains a strftime formatting string. < esql:get-xml> parent: < esql:row-results> Again the same as get-* above. This tag assumes the contents of the column are valid XML, and appends that XML into the result tree. < esql:get-row-position> parent: < esql:row-results> Gets the current row number. Optional ancestor attribute. < esql:get-column-name> parent: < esql:row-results> Gets the column name indicated by the numbered column in the column="..." attribute, or the child < esql:column> element. The attribute/child can actually be a string (name), but then what is the point of that? < esql:get-column-label> parent: < esql:row-results> Gets the label of the column. This is a hang-over from the Cocoon java implementation where sadly nobody seems to know what label is compared with name. In this case, get-column-name is always lower case, whereas get-column-label is returned in the case that the DBD driver returns it as. < esql:get-column-type-name> parent: < esql:row-results> Returns the TYPE_NAME of the column indicated as other get-* elements. See the DBI docs for more details. < esql:no-results> parent: < esql:execute-query> The contents of this element are executed when the SQL returned no rows. < esql:update-results> parent: < esql:execute-query> The contents of this element are executed when the SQL was an update statement. The number of rows updated are in the $rv variable..

Requirements: No special requirements
Platforms: Linux
Keyword: Attribute Axkit Axkitxspesql Column Contents Contents Of Dbi Driver Esql Extended Sql For More Details Name Tag Xsp
Users rating: 0/10

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


AXKIT::XSP::ESQL RELATED
Automation Tools  -  Mail Contents of Front Browser 1.0
Mail Contents of Front Browser is a free Automator action that will add the contents of the front Safari browser to a new outgoing message in Mail.
40.96 KB  
Backup Utilities  -  View Contents of Backup File 1.0
SysTools BKF Viewer is a freeware utility which is able to view contents of backup file and read BKF file without any cost. Windows BKF reader or Windows BKF file viewer supports all backup databases which were created using Windows 98, ME, 2000,...
932 KB  
Business  -  Resource Tuner 1.99 R3
Country Codes is a small database of country codes and additional information for more than 250 countries, it displays their location (continent), ISO 3166-1 Alpha 2-3 codes and ISO number. Also IDDD code and flag, NDD Code, Country Dialing Code,...
1.4 MB  
Libraries  -  Apache::TestUtil 1.29
Apache::TestUtil Perl module contains utility functions for writing tests. SYNOPSIS use Apache::Test; use Apache::TestUtil; ok t_cmp("foo", "foo", "sanity check"); t_write_file("filename", @content); my $fh = t_open_file($filename);...
153.6 KB  
Desktop Utilities  -  Decrypt and Extract Here Service Menu 1.1-4
Decrypt and Extract Here Service Menu installs a service menu for Konqueror that decrypts and extracts the contents of encrypted tarballs. Once install, a "Decrypt and Extract Here" entry is added to the Actions context menu in Konqueror. This...
13.31 KB  
Desktop Utilities  -  Garidio 1.0 Beta
Garidio is an application that allows users on a network to share the contents of their desktop clipboards with each other. It has been successfully tested on Mac OS X (Tiger), Windows XP (SP2), and Linux (Slackware, SuSE, and Ubuntu), but it...
30.72 KB  
Desktop Utilities  -  Zipper 1.2
Zipper is a tool for inspecting the contents of a compressed archive and for extracting. I know that theres a GNUstep port of the famous OpenUp application but I must admit that for a living I have to use Windoze at work. After a while I got...
460.8 KB  
Network & Internet  -  Syntax Desktop 2.3.1
Syntax Desktop is a publishing system used to manage the contents of a Web site. Syntax Desktop project has an attractive GUI with DHTML elements. You can use it to insert news, photos, documents, and tree data structures into your site. It...
4.6 MB  
3D Graphic Tools  -  Visprint 2.1
Visprint project makes fractal fingerprint png images based on the contents of any file. The image will be different for almost every file with even slightly different contents. Visprint uses the IFS fractal generation process, pioneered by...
14.34 KB  
Audio Tools  -  libgpod 0.5.2
libgpod is a shared library to access the contents of an iPod. libgpod library is based on code used in the gtkpod project. Starting with V0.96.CVS gtkpod depends on this library. This code was originally part of gtkpod itself. When the parsing...
808.96 KB  
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