SQLUtils Class Reference [Public API] common SQL utilities More... #include <sqlutils.h> List of all members. Static Public Member Functions static std::string  createIN (const std::set< std::string > &pSet)   Create IN clause from set of string values. static std::string  createIN (const std::vector< id > &pSet)   Create part of SQL SELECT for use with in clause. static std::string  createIN (const std::set< int > &pSet)   Create IN clause from set of int values. static std::string  escapeSQLData (const std::string &pData)   Escape text string to conform SQL standard. static std::string  escapeSQLLike (const std::string &pData)   Escape string used for LIKE clause to conform SQL standard. static int  getMax (DbConnection &pConn, const char *pTable, const char *pIntCol)   Get maximum value from one of columns. static std::string  setSQLVal (const std::string &pVal)   surround string by single quotes Detailed Description common SQL utilities Member Function Documentation static std::string createIN (  const std::set< std::string > &  pSet  )  [static]   Create IN clause from set of string values. Parameters: pSet  list of values for in clause Returns: string with IN clause static std::string createIN (  const std::vector< id > &  pSet  )  [static]   Create part of SQL SELECT for use with in clause. Parameters: pSet  list of values for in clause Returns: string with IN clause static std::string createIN (  const std::set< int > &  pSet  )  [static]   Create IN clause from set of int values. Parameters: pSet  list of values for in clause Returns: string with IN clause static std::string escapeSQLData (  const std::string &  pData  )  [static]   Escape text string to conform SQL standard. Parameters: pData  string to modify Returns: escaped string static std::string escapeSQLLike (  const std::string &  pData  )  [static]   Escape string used for LIKE clause to conform SQL standard. Parameters: pData  string to modify Returns: escaped string static int getMax (  DbConnection &  pConn, const char *  pTable, const char *  pIntCol )  [static]   Get maximum value from one of columns. Parameters: pConn  pointer to open database connection pTable  name of table pIntCol  name of column Returns: fetched value static std::string setSQLVal (  const std::string &  pVal  )  [static]   surround string by single quotes Parameters: pVal  string to quote Returns: pVal with quotes The documentation for this class was generated from the following file: sqlutils.h		Documentation Quick start Examples Search API Documentation Class hierarchy Member index API Reference Store filters Store table macros
Back

---

Generated by doxygen at Sun Nov 9 02:08:27 2008