Performs a SQL statement on an ODBC data source.[SQL Statement]Found Items[/SQL]
[SQL dsn=Pubs&statement=SELECT * from Authors]
Found [numfound] items
[au_lname], [au_fname], [title]
you can substitute any [xxx] tags in the SQL parameters, as in [SQL dsn=Pubs&statement=SELECT * from Authors where au_lname > '[form.name]'].
UNIX users can get infomation on how to setup WebDNA with ODBC
|dsn||Name of the database you wish to search.|
|username||Username required to access this ODBC database (Optional for Window platform, if none specified, "sa" is used).|
|password||Password required to access this ODBC database (Optional for Window platform, if none is specified, a blank password is used).|
|statement||Any legal SQL statement.|
|max||A number indicating how many records should be displayed at once before showing a list of "Show Items xx-yy" hyperlinks.|
|[NumFound]||A number indicating how many records matched the search request. Some ODBC drivers do not support this feature, so WebDNA compensates by visiting every record in the database in order to count them. For large datasets, this can be very slow, and you should consider writing a SQL statement that performs a count instead. Do not put [NumFound] inside a SQL context that INSERTS new records, because the statement will be executed twice in order to perform the count. This will cause invalid a second record to be added to your database.|
|[founditems]...[/founditems]||Normally you put a [founditems] loop inside a [SQL] context that has performed a SELECT statement, so you can display all the matching records. You can put any database field names inside the [founditems] loop to display them in HTML.|
DOWNLOAD WEBDNA NOW!
A list of the currently available modules...WebDNA Libraries
A list of available libraries for WebDNA...AWS Raw WebDNA LAMP-Plus WebServer
Amazon Web Services (AWS) README for Machine Image ID...Technical Change History
This Technical Change History provides a reverse chronological list of WebDNA changes...WebDNA reference
A list of all WebDNA instructions...Tips and Tricks
A list of user-submitted tips ...
Breaks a string of text into separate words...[grep]
Replaces text based on a regular expression...[movefile]
This instructions move a file from one location to another...Web Hosting Control Panels and WebDNA
Web Hosting Control Panels are becoming prevelant in the industry...[sendmail]
There is hardly a website that doesn't at some point need to send an email...[fileinfo]
Displays information about a particular file or folder...