Lasso Soft Inc. > Home

[Column]

[Column] returns the value for a field from the current database search. This tag can be used within [Inline] ... [/Inline] tags that return a database found set or on the response page for a Classic Lasso database action that returns a found set.

The name of the field specified in the [Column] tag must be defined in the current found set. If it is not then a syntax error will be reported.

Normally, the [Column] tag is used within [Records] ... [/Records] tags to return the field value from each record in the found set in turn. It can also be used outside of [Records] ... [/Records] tags to return the field value from the first record in the found set (useful if there is only one record in the found set).

The -RecordIndex tag can be used to return a field from a particular record in the current found set without using [Records] ... [/Records] tags to loop through all records.

For FileMaker Pro databases, related field values can be returned by specifying the name of the relation followed by two colons and the name of the field, e.g. relation::fieldname. The related field value must be included in the current layout.

By using the [Portal] ... [/Portal] tags each row in a portal on the current layout can be returned in turn. The -PortalIndex can be used to return a field from a particular row in a portal on the current layout without using the [Portal] ... [/Portal] tags to loop through all rows of a portal.

  • Syntax
  • Parameters
[Column: 'Field_Name']

[Records]
  [Column: 'Field_Name']
[/Records]

[Records: -InlineName='Inline_Name']
  [Column: 'Field_Name']
[/Records]

[Column: 'Field_Name', -RecordIndex=Record_Index]

[Column: 'Relation_Name::Field_Name']

[Portal: 'Relation Name']
  [Column: 'Relation_Name::Field_Name']
[/Portal]

[Column: 'Relation_Name::Field_Name', -PortalIndex=Portal_Index]
Required Parameters
Field_Name The name of the field whose value should be returned.
Optional Parameters
-RecordIndex If specified, the value for the field from the specified record from the current found set is returned.
-PortalIndex Can be used for fields which are included in a portal in the current layout in a FileMaker Pro database. The value for the specified field from this row of the portal is returned.
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 field values from a search:

Use a [Column] tag for each field within [Records] ... [/Records] tag. The following example finds all records in the People table of the Contacts database and returns the First_Name and Last_Name fields for each record in the found set.

[Inline: -Database='Contacts',
    -Table='People',
    -FindAll]
  [Records]
    <br>[Column: 'First_Name'] [Column: 'Last_Name']
  [/Records]
[/Inline]
Result:
<br>John Doe
<br>Jane Doe
<br>John Surname
<br>Betty Lastname
Tag Link [Column] Category Database
Type Substitution Data Source Any
Support Synonym Version 3.0
Output Type String, Decimal, or Integer Security None
Implementation Internal Sets 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