[RESOLVED] classic asp help please

[Anjari]

Can someone tell me what I am doing wrong? I am trying to use a querystring to query my DB. If the record is there then continue else do nothing...

Here is my code:

<!-- #include file="connection/connection.inc"-->

<%
	  idstring = Request.QueryString("t")
	  
      <%
  Dim rs
  set rs=Server.CreateObject("adodb.recordset")
  
  rs.open = select * from table where field = '" & idstring &"'",strcon,3,3


  If rs.EOF Then
    'No Record in the DB
  Else
    'Record in the DB
  End If
%>

Thank you so much for your help!!

[gtilles]

So what is your error?

You have no debugging so how do you know which path the If statement did.

If rs.EOF Then
    'No Record in the DB
  Else
    'Record in the DB
  End If

on error resume next
If rs.eof and rs.bof then
  response.write "No records returned"
else
  response.write "Records found"
    while not rs.eof
       response.write rs(0) & "<br>"
       rs.movenext
    end while
end if


if err.number<>0 then
  response.write err.description
  response.end
end if

[Anjari]

Thanks for the help! I jumped over asp and went straight to asp.net - Its not as hard as I thought it would be just a bit of a learning curve... Im only learning it because a client has a site in asp and doesnt want to upgrade to asp.net.

Thanks!

Anjari