I've been searching all over the net and forums trying to find an answer to this problem. But I can't seem to figure out what the problem is. I keep recieving this error.


Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

vdateUsr.asp, line 47


Here is the code:


' execute sql and open as recordset
sqlStr = "Select * From tUsers where username = '" _
            & Request.Form("username") & "' and password = '" & Request.Form("password") & "'"

' Opens the returned values from the SQL as a recordset, ready for iteration by ASP
set rcSet = cnStr.Execute(sqlStr) // And this is line 47

I have tried checking the delimiters, spacing, everything that I could find a possible problem with, but have still had no luck. However I'm still very new to this and could be on the wrong track totally.

Thanks,


<<<<
Byron Thurman
[email protected]

Hi,

  Verify the field names. May be password is reserved word

Hi,

Check out this Web Site for troubleshooting
http://www.adopenstatic.com/faq/80040e10.asp

pls send me strsql this error tell there is no value to
test i mean username and passowrd are empty

try
response.write(ur query variable)
response.end
then post it then i will try 2 resolve it

Hi Byron Thurman,

Code that contructs sqlstr seems to be fine.

Doesn't look like your query has spelling mistakes too. May be you can check that once if your Table/Column names are spelt correctly in the Query as defined in your database.

Lastly it looks like your USERNAME/PASSWORD values from the FORM is/are not coming through. Check if both contains something in it, before contructing your SQL query.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

did you ever figure it out.