Forums

ASP

This topic is locked

Compare QueryString Results to DB Field

Posted 05 Sep 2010 17:12:22
1
has voted
05 Sep 2010 17:12:22 Natalie Patterson posted:
I have a form with multiple selection list form for vehicles for a report. I am trying to get the queryString count results to compare to the vin in the DB field to out put to a table. This is what I have:

<%
for i=1 to Request.QueryString("vehInfo".Count
If Request.QueryString("vehInfo" = Trim(rsAuto.Fields.Item("vin".Value) Then
Response.Write("<tr>"
Response.Write("<td width='126' height='27' align='center' valign='middle'>" & Request.QueryString("year" & "</td>"
Response.Write("<td width='117' align='center' valign='middle'>" & Request.QueryString("makesx" & "</td>"
Response.Write("<td width='180' align='center' valign='middle'>" & Request.QueryString("vin" (i) & "</td>"
Response.Write("<td width='126' align='center' valign='middle'>" & Request.QueryString("title" & "</td>"
Response.Write("<td width='153' align='center' valign='middle'>" & Request.QueryString("ticket" & "</td>"
Response.Write("<td width='72' align='center' valign='middle'>" & Request.QueryString("color" & "</td>"
Response.Write("</tr>"
End If
next
%>

My repeat regions/rows in not implemented yet. I just need help comparing the queryString results to the DB field. Any suggestions would be appreciated.

Kind Regards

NPatterson

Replies

Replied 05 Sep 2010 20:40:56
05 Sep 2010 20:40:56 Natalie Patterson replied:
Never mind.... I got it running.

Reply to this topic