Error in SQL

error 80040e10

[Andrew Thomas]

Can anyone see any error on this line?

rs_case.Source = "Select distinct pc_case_model FROM pc_cases WHERE pc_base_model = '" & Request.Form("pc_base_model") & "'"

the error message is :

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

thanks

[WebJoe]

Have you tried a

Response.Write "Select distinct pc_case_model FROM pc_cases WHERE pc_base_model = '" & Request.Form("pc_base_model") & "'"

to see if it returns the forms value properly?

I suspect that your error lies there.

[Andrew Thomas]

yes, it returned the form value back.

Im a bit confused, where is my problem then?

thanks for your help

[wackal]

what is the value for Request.Form("pc_base_model")?

Usually that error shows up when there is a data type mismatch. The field value for pc_base_model seems to be text from the SQL query you posted.

[Andrew Thomas]

it shows

'Celeron 1.8Ghz/400 MHz FSB, 0Mb RAM (2Gb Max), FDD, 10/100 LAN, 6xUSB'

which is correct.

But when i use the SELECT statement i get the error.

help

[defanjos]

Try:
" & Request.Form("pc_base_model") & "

instead of:
'" & Request.Form("pc_base_model") & "'

[Andrew Thomas]

Ive tried your suggestions, but it still doesnt work.

[Zaphod Beeblebrox]

There's a typo in your WHERE-clause: pc_case_model and pc_base_model

[Andrew Thomas]

thanks for all your help, there was an error uploading my database, i reloaded it and it worked?

Since then ive changed the code around and its coming along well, but will probably need help later :)

but thanks for the help

Andrew