Toggle navigation
Smartsite Releases
Smartsite Manager
User Manual
Features & Modules
Install & Config
Advanced
SXML
Smartsite Documentatie
>
SXML
>
Vipers
>
Global Viper Methods
>
Sql Viper Class
Collapse All
Expand All
Sql Viper Module
Viper Methods
Global Viper Method
Description
Sql.Execute Viper Method
Executes the given resultset query/statement and returns a DataTable.
Sql.ExecuteNonQuery Viper Method
Executes the given non-resultset query/statement and returns the number of affected records.
Sql.GetDatabase Viper Method
Gets the current database id ('Default' if not set).
Sql.Scalar Viper Method
Executes the given query/statement and returns the result.
Sql.Servertype Viper Method
Returns the type of the database server.
Sql.SetDatabase Viper Method
Sets the current database to use in Sql Viper methods to the default (Cms) database.
See Also
Sql.Execute Viper Method
Executes the given resultset query/statement and returns a DataTable.
Sql.ExecuteNonQuery Viper Method
Executes the given non-resultset query/statement and returns the number of affected records.
Sql.GetDatabase Viper Method
Gets the current database id ('Default' if not set).
Sql.Scalar Viper Method
Executes the given query/statement and returns the result.
Sql.Servertype Viper Method
Returns the type of the database server.
Sql.SetDatabase Viper Method
Sets the current database to use in Sql Viper methods to the default (Cms) database.
SXML
Macro
Macro Parameters
Macro Parameter Properties
Vipers
Global Viper Methods
AIM Viper Class
Audit Viper Class
Buffer Viper Class
Cache Viper Class
CacheFile Viper Class
Calendar Viper Class
Channel Viper Class
Char Viper Class
Cms Viper Class
ContentType Viper Class
Convert Viper Class
Database Viper Class
DataTable Viper Class
DateTime Viper Class
Debug Viper Class
DigiD Viper Class
Env Viper Class
FileSystem Viper Class
FlexLayout Viper Class
Html Viper Class
Html.Color Viper Class
Html.Css Viper Class
Image Viper Class
ImageProperties Viper Class
ItemComments Viper Class
ItemData Viper Class
License Viper Class
Locale Viper Class
Logging Viper Class
Login Viper Class
Math Viper Class
Payment Viper Class
Personalization Viper Class
PlaceHolder Viper Class
Poll Viper Class
Publication Viper Class
RenderTemplate Viper Class
Request Viper Class
Response Viper Class
Scf Viper Class
Security Viper Class
Session Viper Class
Site Viper Class
Smartlet Viper Class
SmartletEditor Viper Class
SmartletPreset Viper Class
Smi Viper Class
SmiData Viper Class
Spice Viper Class
Sql Viper Class
Sql.Execute Viper Method
Sql.ExecuteNonQuery Viper Method
Sql.GetDatabase Viper Method
Sql.Scalar Viper Method
Sql.Servertype Viper Method
Sql.SetDatabase Viper Method
StandardsCompliance Viper Class
Storage Viper Class
String Viper Class
SXML Viper Class
Sys Viper Class
Tags Viper Class
Translation Viper Class
Url Viper Class
User Viper Class
UserItemFeedback Viper Class
Xml Viper Class
Local Viper Methods
SXML Data Types
Examples
Tips & Tricks