i have made it to page 429 but now i am confused about this issue. the
set preferences home asp page has this code below and everythig is working
fine, except when i put in the adClipstring and the -1.
<%
SET ors=SERVER.CREATEOBJECT("adodb.recordset")
ors.Open sqltxt, "DSN=Clothier"
Response.Write ors.GetString(adClipString,-
1,"</td><td>","</td></tr><tr><td>"," ")
%>
(the response write is all on one line in the source code)
i was under the assumption that these values were defaults and you could
leave them out or put them in. when i take them out, everything works
fine, but when i add those values in i get the error below.
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/Project1_Local/Chapter_11/ch11_EXERCISE1_SET_PREFERENCE_HOME.asp, line 35
if someone could add some comment so that i cna further understand what is
going on, i will appreciate that,
thanks,
craig
entire page listed below:
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<H1>Our Items ---Arranged as per your preference in your cookie. </H1>
<%
Dim ors, sqltxt, varGroup
vargroup = Request.Cookies("Group")
sqltxt = "SELECT * FROM Items "
Select CASE varGroup
Case "type"
sqltxt = sqltxt & " ORDER BY ItemType;"
Case "dept"
sqltxt = sqltxt & " ORDER BY ItemDepartment;"
End SELECT
'RESPONSE.WRITE "<br>" & sqltxt & "<BR>"
%>
<table border=1>
<TH>ID Number</th>
<TH>Name</th>
<TH>Department</th>
<TH>Type</th>
<TH>Price to Buy</th>
<TH>Vendor Code</th>
<TH>Qty per box</th>
<TH>Date of release</th>
<tr>
<td>
<%
SET ors=SERVER.CREATEOBJECT("adodb.recordset")
ors.Open sqltxt, "DSN=Clothier"
Response.Write ors.GetString(adClipString,-
1,"</td><td>","</td></tr><tr><td>"," ")
%>
</td>
</tr>
</table><P>
</BODY>
</HTML>
View Cart
