|
-
Jun 6th, 2000, 11:55 PM
#1
Thread Starter
Member
I am trying to pass a variable over via the request.querystring command...
Here is a sample of my code:
<%Do Until rsDESKTOP.EOF%>
<tr>
<td width="351" align="left" bgcolor="#FFFFFF"><span style="text-transform: uppercase"><font face="Arial" size="1"><%response.write rsDESKTOP("Blurb")%></font></span></td>
<td width="212" align="right" bgcolor="#FFFFFF"><font face="Arial" size="1"><span style="text-transform: uppercase"><a href="system.asp?SystemId=<%response.write rsDESKTOP("BELONG")%>"><%response.write rsDESKTOP("Description")%></a></span> </font></td>
</tr>
<%rsDESKTOP.MoveNext
loop
%>
What this sniplet does is reference a database and populates a page with the items from my database and also assigns a value to the href.
that value is being populated from the same database that the next page is calling... but I am getting the error message
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/tvi/system.asp, line 9
before i was getting a "Expected 1" i don't quite understand why it now shows 2.
And below is the code for the second page that recieves the variable via the url.
<%
set rsSYSTEM = conn.Execute("Select * from TVISYSTEMS where SysID = " _
& Request.QueryString("SystemId"))
%>
If I change the value of the system being passed back and forth through the two pages from a single letter to a single number without changing any code... it works... why??
Kind Regards,
Hakan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|