replace the ""A00004"" with 'A00004'
That fixes it...
Usually to output <font color="red"> by using response.write you'd do
response.write("<font color=""red"">")
The "" sequence escapes the last " and outputs " to the screen. In SQL Code,
there is no outputting to screen, the "" is being passed to the SQL engine
which throws an error since it is reading it as
WHERE (field="" A00004 ""))
Which can be read as <WHERE field =""> - up to now it is correct but the
rest <A00004 ""))> is being read as another steatement of the WHERE
condition, which is wrong.
Got the point? I hope I was clear enough 'cos I'm getting a bit dizzy myself
when reading out this mail myself ... lol
HTH
Paul
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 05, 2003 7:33 AM
> To: [EMAIL PROTECTED]
> Subject: [wdvltalk] VBScript error '80040e10'
>
>
> Hello,
>
> I am receiving the following error when loading a page:
>
> :
> : Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
> :
> : [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected
> 1.
> :
> : /blah/engine.asp, line 23
> :
>
> I have read info on this error, and I realise that it is due to the SQL
> statement looking for a field that doesn't exist, usually due to
> a spelling
> error in the statement.
>
> I have tried correcting this for 3 hours with no luck, obviously there's
> something simple I'm looking over. I've even resorted to going direct to
> MSAccess and copied the SQL directly from a query - and I still receive
> this error.
>
> If you can please help me, I've included the database and ASP
> file in a zip
> file you can download by clicking
> http://www.cashflow-manager.com/blah/web/zip
>
> Thanks for you time
>
> Tim Burgan
> [EMAIL PROTECTED]
>
> --------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://mail2web.com/ .
>
>
>
> ____ � The WDVL Discussion List from WDVL.COM � ____
> To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
> Send Your Posts To: [EMAIL PROTECTED]
> To change subscription settings to the wdvltalk digest version:
> http://wdvl.internet.com/WDVL/Forum/#sub
>
> ________________ http://www.wdvl.com _______________________
>
> You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to %%email.unsub%%
>
>
>
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
