Guys,

I'm getting this error and I'm not able to find the source of this problem. The weird thing about this error is that it doesn't happen constanly. It works fine and after a few clicks then it start giving me the following:

Description: No value given for one or more required parameters.
Number: -2147217904
Source: Microsoft JET Database Engine

Now this is what I have on the SQL after putting a response.write:
SELECT * FROM books WHERE isbn LIKE '020533167x'

And the code look like this:

strSQL = "SELECT * FROM books WHERE isbn LIKE '" & Request.QueryString("bookId") & "'"
moRs.Open strSQL,cn,3,,1

Guys, your help will be highly appreciated. This error is been keeping awake all night long.
Thank you.

Hello,

  You try including adovb.inc at the top and then


rs.Open strSQL,cn,adOpenStatic,adLockReadOnly




-------
Rajani

Hey,

You can't have ,, must put in a value.

Brian

Hello Brian!

thank you for your comments. The reason I left that parameter empty is because is an optional parameter, but I'll try. I think that it'll fail all the time in that case, but is just occasionally that happens.

Brian,

I tried without the empty space and still didn't work. See bellow:


moRs.Open strSQL,cn,3

Any other suggestions?

Rajani, I appreciate your comments also, but instead of including the whole adovb.inc, I will just declare a couple of variables that I need. I don't like overloading all those variables into my page.

thank you,

Vlado

Try 3,3

Didn't work Brian

Same error as before? That's strange...

Hey,

Have you confirmed that Request.Querystring("bookid") is returning a valid value?

Brian

I know it's strange one. I'm very good catching error, but this one it's surprising me. I think that it has to do with the engine in the server.
The value is like I stated before: SELECT * FROM books WHERE isbn LIKE '020533167x'

Now I have changed all my connection by this one and then I will tested thorougly. Like I said it only happens occasionally. Here's my new code to eliminate the SQL.

moRs.Open "books", cn1, adOpenKeyset, adLockReadOnly
moRs.Find "isbn = '" & Request.QueryString("bookId") & "'"

thank you,

Vlado