cfboom.util

Class QueryUtils

lucee.Component
    extended by cfboom.util.QueryUtils

Query utility methods.

Class Attributes:
  • singleton : true
  •  
  • output : false
  •  
  • displayname : Class QueryUtils
  •  
  • synchronized : false
  •  
  • accessors : false
  •  
  • auther : Joel Tobey
  •  
  • persistent : false
  •  
    Constructor Summary
    init()
    Method Summary
    query getBy(query q, string name, any value, [string sqlType='cf_sql_varchar'])
         Helper to get a record set by the specified field/value.
    query getById(query q, any id, [string sqlType='cf_sql_integer'])
         Helper to get a record by the ID.
    query getLike(query q, string name, any value, [string sqlType='cf_sql_varchar'])
         Helper to get a record set that's like the specified field/value.
     
    Methods inherited from class lucee.Component
    None

    Constructor Detail

    init

    public init()


    Method Detail

    getBy

    public query getBy(query q, string name, any value, [string sqlType='cf_sql_varchar'])

    Helper to get a record set by the specified field/value.

    Parameters:
    q
    name
    value
    sqlType

    getById

    public query getById(query q, any id, [string sqlType='cf_sql_integer'])

    Helper to get a record by the ID.

    Parameters:
    q
    id
    sqlType

    getLike

    public query getLike(query q, string name, any value, [string sqlType='cf_sql_varchar'])

    Helper to get a record set that's like the specified field/value.

    Parameters:
    q
    name
    value
    sqlType