Hello everyone,
I'm having problems with this code. I'm connecting to an access database where the primary key data type is text and my the field name is "Fname" (First Name). I keep getting this error:

No value given for one or more required parameters

I don't get the same error if I change my primary key to AutoNumber. Please let me know if I have to use a numbered primary key or can I use text and how can I fix the code to work with it. Here's the code I'm using:


Dim oConn, rs

Set oConn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
oConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
              "Data Source=database.mdb;" & _
              "Persist Security Info=False"


If Request("Fname") <> "" THEN
IDReq = Request("Fname")
rs.open "SELECT * FROM table WHERE Fname=" & IDReq,oConn,1,1

If Not rs.EOF Then
rs.MoveFirst

Thank you in advance.

If FName is a text type then you need to enclose it in quotes:

rs.open "SELECT * FROM table WHERE Fname='" & IDReq & "'", oConn, 1, 1


HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Sleeping With Ghosts by Placebo (Track 4 from the album: Sleeping with Ghosts) What's This?