I am having trouble using a query in order to view a single record on a webpage

<%
    If Len(Request.Form("id")) Then
    Dim form_id, data_source, sql_delete, con, rs, sqlrecord, no, count, callback_id, rs1
     form_id = CInt(Request.Form("id"))
     data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
                 Server.MapPath("form.mdb")
     form_id=id
     sqlrecord= "Select * FROM users WHERE id="&form_id

       Set rs1 = Server.CreateObject("ADODB.Recordset")
       rs1.Open sqlrecord


The variable id is coming from the previous page's form, and is a primary key auto number in the database, so the number will only correspond to a single record.

My error is:
ADODB.Recordset error '800a0e7d'

The connection cannot be used to perform this operation. It is either closed or invalid in this context.

/showone.asp, line 24

Line 24 is rs1.Open sqlrecord

Anyone see what I'm doing wrong?

Thanks!

Your problem:

the Record Set (rs1) has been opened, but you didn't define a connection string...

rs1.Open sqlrecord, conn

- A.Kahtava

Links of interest:

ADO Recordset: http://www.w3schools.com/ado/ado_recordset.asp

- A.Kahtava

Excellent. That fixed part of the problem. Now it doesn't like my select statement. I get error:
Syntax error (missing operator) in query expression 'id='.
I have tried putting my variable in many different ways and nothing seems to work. If I manually put in an ID on the select statement, then it loads the correct record and everything works fine.

is there a value in the variable form_id - looking at the error I would say this is your problem. (is id an integer field?) Its a good habbit to finish sql statement with trailing semi colons - this helps prevent SQL Injections (lets not go into that, google covers it well) I would write it like:

sqlrecord= "Select * FROM users WHERE id=" & form_id & ";"

Wind is your friend
Matt

What data type is id? Is it an int or a string?

If it's a string you need single quotes.

Example:
"SELECT * FROM users WHERE id = '" & form_id & "';"

- A.Kahtava

LOL... Too much.. :)
I was 3 minutes too late..

- A.Kahtava

Thanks much. Looks like I'm all set for now :D

LOL indeed - another example of how useful this forum and its members are. sswingle - you joined the good one.

Wind is your friend
Matt