For more information... RTFM!
NAVIGATION
PAGES THAT LINK HERE
ACCOUNT LOGIN

You are not logged in

Powered by Interchange version 5.7.0

PREFIX-pos

Summary

  • [PREFIX-pos N]

Description

Returns the value of the array element associated with the looping tag's current row.  Each looping list returns an array of columns, set in searches with mv_return_fields.  The default is only to return the code of the search result, but by setting those parameters you can return whichever columns you wish.

[PREFIX-pos N] outputs the data from the Nth column (numbered with zero), as returned.  [PREFIX-param] lets you access the data by column name, instead of by number.

In a [query] tag, you can select multiple return columns with something like this:

[query prefix=prefix sql=|
    SELECT  foo, bar
    FROM    baz
    WHERE   foo = 'baz'
|]
    [prefix-code], [prefix-param foo], [prefix-param bar]<br>
[/query]

In this case, [prefix-code] and [prefix-param foo] are synonyms, as foo is the first returned column and becomes the code for this row.  Another synonym is [prefix-pos 0][prefix-pos 1] is the same as [prefix-param bar], in this example.  The following code will produce exactly the same output as the above:

[query prefix=prefix sql=|
    SELECT  foo, bar
    FROM    baz
    WHERE   foo = 'baz'
|]
    [prefix-pos 0], [prefix-pos 0], [prefix-pos 1]<br>
[/query]

Note that if you use the [PREFIX-pos] tag, you may have to review your column numbers whenever you modify the columns you select.  For this reason, queries that make use of the [PREFIX-param] tag may be easier to maintain and will be less prone to future surprises.

See also

Category:  Looping tags and sub-tags
Last modified by: Kevin Walsh
Modification date: Wednesday 19 September 2007 at 5:51 PM (EDT)
Home  |  Legal nonsense  |  Privacy policy  |  Donations  |  Contact us