Snitz Forums 2000 - access database sql string

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

access database sql string

New Topic

Topic Locked

Printer Friendly

Author

Topic

redbrad0
Advanced Member

USA
3725 Posts

Posted - 06 November 2001 : 00:36:25

i get the following error message when trying to get records from a access 2000 database. this is the same querystring that i used when i got i had it on a sql server.

Error:


Microsoft JET Database Engine error '80040e10' 
No value given for one or more required parameters. 
/search.asp, line 122

and the sql string it is trying to connect to is:
SELECT GOC, CON, COL, DOS FROM Court Where DPS_NUMBER='2967494' OR DPS_NUMBER='02967494'

What could the problem be? Im testing on PWS on my win98 computer.

Brad

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 06 November 2001 : 01:24:21

the SQL String looks ok, what does the rest of the code in the search.asp look like?

redbrad0
Advanced Member

USA
3725 Posts

Posted - 06 November 2001 : 09:32:52

its basically using all the same querys. a query runs right before that one that is the exact same, but getting data from a different table name. I can post the entire .asp file in a text file if you would like to look at it, i just didnt think that the problem would be somewhere else in the file. I think the fields it searchs in are number fields in the access database, do i need the quotes in access around this number?

Brad

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.24 seconds.