Ns dbquotevalue - Revision history

Gustafn at 20:02, 7 February 2009

2009-02-07T20:02:56Z

Juanjose at 14:01, 14 December 2006

2006-12-14T14:01:25Z

Caveman: fixed double bracket (double single quote not fixed)

2005-12-13T14:14:50Z

fixed double bracket (double single quote not fixed)

WikiSysop: imported from WiKit id 547

2004-06-22T05:01:07Z

imported from WiKit id 547

New page

Man page: http://aolserver.com/docs/tcl/ns_dbquotevalue.html

----

'''NAME'''

: ns_dbquotevalue - Prepare a value string for inclusion in an SQL statement.

'''SYNOPSIS'''

: '''ns_dbquotevalue''' ''value ?type?''

'''DESCRIPTION'''

: This command prepares the string ''value'' for inclusion in an SQL statement. If ''value'' is "", ns_dbquotevalue will return the string "NULL". If ''value'' is not "", the returned value depends on ''type''. If ''type'' is one of: bigint, bit, decimal, double, float, int, integer, numeric, real, smallint, or tinyint, then ''value'' will be returned without modification. When ''type'' is any other string, or if ''type'' is omitted, ''value'' will be surrounded by single quotes, and any single quotes that it contains will be escaped by translation into two single quotes.

'''EXAMPLES'''

% ns_dbquotevalue ""
NULL

% ns_dbquotevalue 45.3 float
45.3

% ns_dbquotevalue "John's Car"
'John''s Car'

% set company "John's Cheese Factory"
% ns_db dml $db "INSERT INTO companies (name) VALUES ([[ns_dbquotevalue $company]])"

'''SEE ALSO'''

: [[ns_dbquotename]]

----

[[Category Documentation]] - [[Category Core Tcl API]]

← Older revision		Revision as of 20:02, 7 February 2009
Line 33:		Line 33:
	: [[ns_dbquotename]]		: [[ns_dbquotename]]

−	~~----~~	+	[[Category:Documentation]] [[Category:Core Tcl API]]
−
−	[[Category Documentation]] - [[Category Core Tcl API]]

@@ Line 24: / Line 24: @@
      % ns_dbquotevalue "John's Car"
-     'John''s Car'
+     <nowiki>'John''s Car'</nowiki>
      % set company "John's Cheese Factory"

@@ Line 27: / Line 27: @@
      % set company "John's Cheese Factory"
-     % ns_db dml $db "INSERT INTO companies (name) VALUES ([[ns_dbquotevalue $company]])"
+     % ns_db dml $db "INSERT INTO companies (name) VALUES ([ns_dbquotevalue $company])"
 '''SEE ALSO'''