1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
<HTML><HEAD>
<TITLE>Tcl API Reference -- ns_dbquotevalue</TITLE>
<LINK rel=Previous href="tapi-c49.htm">
<LINK rel=ToC href="toc.htm">
<LINK rel=Index href="master.htm">
<LINK rel=Next href="tapi-c51.htm">
</HEAD><BODY BGCOLOR="#ffffff"><A NAME="topofpage"></A>
<TABLE WIDTH=100%>
<TR>
<TD ALIGN=LEFT>
<A NAME="topofpage"></A> <IMG SRC="as-c-sm.gif">
</TD>
<TD ALIGN=RIGHT>
<A href="tapi-c49.htm"><IMG BORDER="0" src=navbprev.gif alt="[ Previous ]"></A>
<A href=toc.htm> <IMG BORDER="0" src=navbhome.gif alt="[ Contents ]"></A>
<A href=master.htm> <IMG BORDER="0" src=navbhelp.gif alt="[ Index ]"></A>
<A href="tapi-c51.htm"> <IMG BORDER="0" src=navbnext.gif alt="[ Next ]"></A>
<A name="7983"> </A>
</TD>
</TR>
</TABLE>
<a name="77226">
</a><h3>ns_dbquotevalue</h3>
<a name="77227">
</a><h4>Overview</h4>
<p><a name="77228">
</a>Prepare a value string for inclusion in an SQL statement</p>
<a name="77229">
</a><h4>Syntax</h4>
<p><a name="77230">
</a><b>ns_dbquotevalue</b> <i>value </i>{type text}</p>
<a name="77231">
</a><h4>Description</h4>
<p><a name="77232">
</a><b>ns_dbquotevalue</b> prepares a value string for inclusion in an SQL statement. The value is of type text by default. Values of a numeric type in the value string are left alone. A value string of "" is translated into NULL. All other values are surrounded by single quotes, and any single quotes included in the value are escaped (translated into two single quotes).</p>
<a name="77234">
</a><h4>Example</h4>
<pre> <a name="77235"></a>set value "Charlie's Cheese Factory"
<a name="77236"></a>ns_db dml $db \
<a name="77237"></a>"insert into companies(name) values ([ns_dbquotevalue $value])"
</pre><p>
<TABLE BORDER="2" CELLPADDING="1" width="100%">
<TR><TD COLSPAN=3><P ALIGN=Center>
<IMG SRC="bluebult.gif">
<A HREF="#topofpage">
<FONT SIZE=-1>Top of Page</FONT></A>
<IMG SRC="bluebult.gif">
</TD></TR>
<TR><TD COLSPAN=3><P ALIGN=Center>
<A href="tapi-c49.htm">
<IMG BORDER="0" src=navbprev.gif alt="[ Previous ]"></A>
<A href=toc.htm>
<IMG BORDER="0" src=navbhome.gif alt="[ Contents ]"></A>
<A href=master.htm>
<IMG BORDER="0" src=navbhelp.gif alt="[ Index ]"></A>
<A href="tapi-c51.htm">
<IMG BORDER="0" src=navbnext.gif alt="[ Next ]"></A>
<BR align=center>
<FONT size=-1>Copyright © 1998-99 America Online,
Inc.</FONT>
</TD></TR></TABLE></BODY></HTML>
|
