queryWithTypes

            queryWithTypes
      (command, types [, value1,
      ... ])
         

Warning: contrary to what is stated in the Features section, the queryWithTypes function is not available in WebApp. The function is identical to query, with the added columns type. In most cases, column type isn't used as it can be inferred automatically. This is why the query should be preferred. However in some cases, specially with Oracle and date type columns, it can be necessary to explicit the type. Column types are character strings in the following list:

• string
• datetime
• date
• time
• timespan
• double
• float
• boolean
• byte
• short
• long
• int64
• memo
• blob
• link
• bin

Example:

var cnx = application.getConnection()

var stmt = cnx.query("SELECT iOperatorId, sName, tsLastModified " +
                     "FROM xtkOperator " +
                     "WHERE iOperatorId > $(l)",
                     ["long", "string", "datetime"],
                     1000)
for each(var row in stmt)
  logInfo(row[0] + " : " + row[1] + " " + row[2])

cnx.dispose()

The operator must have 'sql' rights to use this function, otherwise an exception is raised.