Lasso Soft Inc. > Home

-ReturnColumn

-ReturnColumn specifies the name of a field which should be returned with the results of a database action. Synonym is -ReturnField.

If one or more -ReturnColumn tags are specified then only the named fields will be returned. If no -ReturnColumn tags are specified then all fields in the specified table will be returned.

Only one field can be named in each -ReturnColumn tag. To return multiple fields, use multiple -ReturnColumn tags.

  • Syntax
  • Parameters
[Inline: -ReturnColumn='Field_Name', ...]

<a href="default.lasso?-ReturnColumn=Field_Name&...">Link</a>

<form action="default.lasso" method="POST">
  <input type="hidden" name="-ReturnColumn" value="Field_Name">
  ...
</form>
Required Parameters
Field_Name Specifies the name of a field which should be returned.
Examples

To specify what fields to return from a database action:

Use the -ReturnColumn command tag. The following example specifies a -Search action in [Inline] ... [/Inline] tags. Only the First_Name field is returned in the results since a -ReturnColumn='First_Name' tag is included.

[Inline: -Search,
    -Database='Contacts',
    -Table='People',
    -ReturnColumn='First_Name',
    'First_Name'='John']
  [Records]
    <br>[Field: 'First_Name']
  [/Records]
[/Inline]
Result:
<br>John
<br>John
Tag Link -ReturnColumn Category Database
Type Command Data Source MySQL
Support Synonym Version 3.0
Output Type None 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 2015 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft