DB<connectionname>.<member>...
This global variable is declared at the beginning of the page to represent
each database connection used within the page. The Connection
object encapsulates the implementation details used to establish a database connection (i.e. database name, location, user login/password, etc).
The database connection variable can be used to perform custom database operations
(e.g. it is used as the fourth argument of the CCDLookUp
function). The name of the database connection object is created by prepending
the connection name (configured in the CCS environment) with the prefix "DB".
(e.g. for a connection called Internet within CodeCharge Studio, the
corresponding variable name for the connection object will be DBInternet).
Dim SQL SQL = "INSERT INTO login_log(user_id, login_date) VALUES (" & DBConnection1.ToSQL(CCGetUserID(), ccsInteger) & "," & DBConnection1.ToSQL(Now(), ccsDate) & ")" DBConnection1.Execute (SQL)