CodeCharge Studio

CCToSQL Function (ASP)

Description

This function converts values to the specified data type in order to make them SQL compatible. No active connection needed.

Syntax

CCToSQL(Value, DataType)

Return value

string

Parameters

Name Type Description Required
Value any A value to be converted to SQL compatible format. Yes
DataType The data type the value will be converted to. You can use any of the predefined constants: ccsDate, ccsBoolean, ccsInteger, ccsFloat, ccsText, ccsMemo Desired data type. Yes

Example

  SQL = "SELECT user_name" _
      & "FROM users " _
      & "WHERE user_id=" & CCToSQL(Session.Contents("UserID"),ccsInteger)
  Set RecordSet = DBInternetDB.Execute(SQL)

See also

ToSQL Method

On-line, printable versions and updates