Technical References - [listfields]

Lists all the fields in the specified database, SQLResult record set, or SQL table

[listfields Params]Database Tags[/listfields]

To display a list of all the fields in a particular database, put a [listfields] context into a template. You may put a [listfields] context inside the [listdatabases] context to automatically list all the fields in all the databases.

Example :

Fields in database [name]:

[listfields db=[name]]
Fieldname: [fieldname]


To display a list of all fields in an SQL table (after a [SQLconnect] context), specify the SQL connection and database table.

Example :

The "inventory" table has the following fields:
[listfields conn_ref=conn1&table=inventory]
<li>ordinal: [ordinal]</li>
<li>datatype: [datatype]</li>
<li>allownull: [allownull]</li>
<li>width: [width]</li>

To display a list of all fields in a [SQLresult] record set, just include the [listfields] inside of a [SQLresult] context.


[SQLresult result_ref=rs1]
The result set from query "select * from employees;" has [numfields] fields:

<li>ordinal: [ordinal]</li>
<li>datatype: [datatype]</li>
<li>allownull: [allownull]</li>
<li>width: [width]</li>


The following tags are available inside a [listfields] context:

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.


Top Articles:

Tips and Tricks

A list of user-submitted tips ...

Download WebDNA Applications

WebDNA applications...

AWS Raw WebDNA LAMP-Plus WebServer

Amazon Web Services (AWS) README for Machine Image ID...

WebDNA Modules

A list of the currently available modules...

WebDNA Libraries

A list of available libraries for WebDNA...


A compilation of some user's questions...

Related Readings:


Prevents WebDNA to return hidden parts of your code to apache (from version 8...


The server waits until the file appears on disk...


This context displays HTML or executes WebDNA conditionally only if the expression is true...


Hides text...


Explicitly identify what text is returned from a function call...


[showif Comparison]Show This HTML[/showif]...