Lists all the fields in the specified database, SQLResult record set, or SQL table
[listfields Params]Database Tags[/listfields][listdatabases]
Fields in database [name]:
[listfields db=[name]]
Fieldname: [fieldname]
[/listfields]
<hr>
[/listdatabases]
[listfields conn_ref=conn1&table=inventory]
[fieldname]<br>
<li>ordinal: [ordinal]</li>
<li>datatype: [datatype]</li>
<li>allownull: [allownull]</li>
<li>width: [width]</li>
<br>
[/listfields]
[SQLresult result_ref=rs1]
The result set from query "select * from employees;" has [numfields] fields:
[listfields]
[fieldname]<br>
<li>ordinal: [ordinal]</li>
<li>datatype: [datatype]</li>
<li>allownull: [allownull]</li>
<li>width: [width]</li>
<br>
[/listfields]
[/SQLresult]
Tag | Description |
---|---|
[FieldName] | the name of the field. |
[index] | A number from 1 to the total number of fields, indicating this field's index placement in the list. |
The following tags are available when using [listfields] to list SQL fields | |
[ordinal] | Will retrieve the literal position of the current iterated field. |
[datatype] | Will retrieve the named SQL datatype of the current iterated field. |
[allownull] | Returns whether or not (T or F) the current iterated field will accept a null value as a possible entry/value. |
[width] | Will retrieve the maximum length of data the current iterated field will allow. |
DOWNLOAD WEBDNA NOW!
This Technical Change History provides a reverse chronological list of WebDNA changes...
F.A.QA compilation of some user's questions...
WebDNA ModulesA list of the currently available modules...
[biotype]BioType is a behavioral biometrics WebDNA function based on ADGS research and development (from version 8...
Tips and TricksA list of user-submitted tips ...
Download WebDNA ApplicationsWebDNA applications...
[shell] is a way to use the command line with your webserver...
[input][url]...
[wait][wait] just does what it says...
[clearlineitems]Remove all line items from the specified shopping cart...
[returnraw]Sends 'raw' MIME headers and data back to browser...
[exclusivelock]Prevents other threads from simultaneously accessing a group of databases...