sqlGetInt

Returns the integer resulting from an SQL query.


            sqlGetInt (query [, value1,
      ... ])
         

Parameters

query

The SQL query.

value1, ...

Variables of the SQL query.

Return value

The integer value that matches the query.

Remarks

Variables replace the parameters in the command. The variable type must coincide with the parameter declared in the command. These variables are available in a 'select' or 'update' type declaration. We have the following types:
  • $(sz) string
  • $(m) memo
  • $(l) long
  • $(s) short
  • $(b) byte
  • $(d) double
  • $(f) float
  • $(ts) timestamp
  • $(dt) date
  • $(tm) time
  • $(dur) timespan in milliseconds (ms)
The following substitution parameters (only valid for an "update") are automatically replaced with a value and don't need a linked variable.
  • $(id) Generates an identifier
  • $(id:NmsTrackingLogId) Generates an identifier using a specific sequence
  • $(curdate) Current date and time
Using variables does not alter Adobe Campaign performances. The SQL query must select a single line and a single text type field. The operator must have the 'sql' right to use this function, otherwise an exception is raised. Example:

      var age = sqlGetInt('select sAge from nmsRecipient where sEmail =$(sz) order by tsCreated DESC LIMIT 1', email)
var iRecipientId = sqlGetInt("select irecipientId FROM NmsRecipient WHERE sLastName=$(sz) and tsCreated>$(ts)", strName);

Features

Available in:

  • Content management
  • Delivery properties
  • Typology rule
  • JSSP
  • SOAP Method
  • WebApp
  • Workflow