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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
<!--plsfield:text-->
<HTML><HEAD>
<TITLE>C API Reference -- Ns_Db1Row</TITLE>
<LINK rel=Previous href="c-ch131.htm">
<LINK rel=ToC href="toc.htm">
<LINK rel=Index href="master.htm">
<LINK rel=Next href="c-ch133.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="c-ch131.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="c-ch133.htm"> <IMG BORDER="0" src=navbnext.gif alt="[ Next ]"></A>
<A name="7983"> </A>
</TD>
</TR>
</TABLE>
<a name="108168">
</a><h3>Ns_Db1Row</h3>
<a name="108169">
</a><h4>Overview</h4>
Execute an SQL statement that must return one row
<a name="77753">
</a><a name="132641">
</a><h4>Syntax</h4>
<pre> <a name="77755"></a>Ns_Set *Ns_Db1Row(
<a name="77756"></a>Ns_DbHandle *handle,
<a name="77757"></a>char *sql
<a name="77758"></a>);
</pre><p><a name="133988">
</a><h4>Description</h4>
<p><a name="77760">
</a>The Ns_Db1Row function calls the Ns_Db0or1Row function with the given SQL statement. If Ns_Db0or1Row returns 1 row, Ns_Db1Row returns the newly allocated Ns_Set for the row. You must eventually free this row using Ns_SetFree. If NsDb0or1Row returns zero rows, Ns_Db1Row returns NULL.</p>
<p><a name="77761">
</a>If the SQL statement returns zero rows or a database error has occurred, Ns_Db1Row returns NULL. Detailed error messages may have accumulated in an internal buffer in the Ns_DbHandle.</p>
<a name="221967">
</a><h4>Examples</h4>
<pre> <a name="221968"></a>Ns_Set *row;
<a name="221970"></a>Ns_DbHandle *handle;
<a name="230551"></a>
<a name="221971"></a>if ((handle = Ns_DbPoolGetHandle("aPoolName")) != NULL) {
<a name="221972"></a> row = Ns_Db1Row(handle, "select aName from aTable");
<a name="221973"></a> if (row != NULL) {
<a name="221975"></a> char *value;
<a name="221976"></a> value = Ns_SetGet(row, "aName");
<a name="221977"></a> /* use `value' here */
<a name="221978"></a> Ns_SetFree(row);
<a name="221979"></a> }
<a name="221980"></a>}
<a name="221981"></a>
</pre><p><p><a name="221965">
</a></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="c-ch131.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="c-ch133.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><!--plsfield:end-->
|
