sqlite_qt
Add single quotes around text.
|
Syntax
$sqlite_qt ( text )
|
Parameters
text
The text to be single quoted.
Return Value
The single quoted text.
Remarks
This is an auxiliary identifier that can be used to quote data prior to using them in queries.You should this instead of the mIRC's $qt identifier, the reason is explained in FAQ, under the question "Should I use single or double quotes for string literals?"
|
Example
; Escape data, and then add quotes around it
%data = $sqlite_qt($sqlite_escape_string(%data)) ; Execute a query sqlite_exec %db INSERT INTO table (data) VALUES ( %data ) |