Mura CMS 6.1

mura
Class queryTool

railo-context.Component
        extended by mura.queryTool

public class queryTool
extends railo-context.Component

Transforms a query into other data types.


Constructor Summary
init(query inQuery)
 
Method Summary
 void QueryAppend(query QueryOne, query QueryTwo, string Filter='page')
          This takes two queries and appends the second one to the first one
 array toArray()
          Transforms a query into an array of structures
 string toDelimited([string delimiter='[runtime expression]'], [string linefeed='[runtime expression]'])
          Transforms a query into a delimited string using the given delimiter and linefeed characters
 struct toStruct(string primaryKey)
          Transforms a query into a structure, using a designated column as the key
 any toXml()
          Transforms a query into an XML recordset
 
Methods inherited from class railo-context.Component
 

Constructor Detail

init

public init(query inQuery)

Parameters:
inQuery - The query to transform.
Method Detail

QueryAppend

public void QueryAppend(query QueryOne, query QueryTwo, string Filter='page')
This takes two queries and appends the second one to the first one. This actually updates the first query and does not return anything.

Parameters:
QueryOne
QueryTwo
Filter

toArray

public array toArray()
Transforms a query into an array of structures.


toDelimited

public string toDelimited([string delimiter='[runtime expression]'], [string linefeed='[runtime expression]'])
Transforms a query into a delimited string using the given delimiter and linefeed characters.

Parameters:
delimiter - Default column delimiter (default is TAB).
linefeed - Default linefeed (default is chr(10)).

toStruct

public struct toStruct(string primaryKey)
Transforms a query into a structure, using a designated column as the key.

Parameters:
primaryKey - The name of the column to be used as the key for the structure. Should be a unique identifier or rows will be lost!

toXml

public any toXml()
Transforms a query into an XML recordset.


Mura CMS 6.1