Lasso Soft Inc. > Home

[Column_Name]

[Column_Name] returns the name of a field in the current database and table. A number parameter returns the name of the field in that position within the current table. Other parameters are described below. Synonym is [Field_Name].

  • Syntax
  • Parameters
[Column_Name: -Count]

[Column_Name: Field Index]
Optional Parameters
Field Index Specifies which field name should be returned. Ranges from 1 to the value of [Field_Name: -Count]. Cannot be used in concert with the -Count keyword.
Result Type Returns the number of fields in the current result set. Cannot be used in concert with a field index.
Encoding Keyword Specifies the encoding for the tag's return value. Tags are encoded using -EncodeHTML by default if their value is output on a format file. No encoding is applied to nested tags unless an explicity encoding keyword is specified. One of -EncodeBreak, -EncodeHTML, -EncodeNone, -EncodeRaw, -EncodeSmart, -EncodeStrictURL, -EncodeURL, -EncodeXML.
Examples

To return a list of all fields in a table:

Use the [Column_Name] tag. The following example uses a -Show action in an inline to return information about the People table of the Contacts database. The [Column_Name] tag is used in [Loop] ... [/Loop] tags to return the names of the fields.

[Inline: -Database='Contacts', -Table='People', -Show]
  [Loop: (Column_Name: -Count)]
    <br>[Column_Name: Loop_Count]
  [/Loop]
[/Inline]
Result:
<br>FIrst_Name
<br>Last_Name
<br>Phone_Number
<br>Title
<br>Sex
Tag Link [Column_Name] Category Database
Type Substitution Data Source Any
Support Synonym Version 3.0
Output Type String Security None
Implementation LCAPI Sets Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0, Lasso 5.0,LDML3x

Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.

LassoSoft Inc. > Home

 

 

©LassoSoft Inc 2014 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft