Microsoft VBScript compilation error '800a0408'

[GTN1707]

Help, I'm trying to run a stored procedure, but i'm getting the following error -

"Microsoft VBScript compilation error '800a0408'

Invalid character

/admin/afterreviewupdatepricing.asp, line 39

if(Request.QueryString(“day7“) <> "") then updatepricingCommand__7dayrate = Request.QueryString(“day7“)"

Where row 39 is -

if(Request.QueryString(“day7“) <> "") then updatepricingCommand__7dayrate = Request.QueryString(“day7“)

I've attached the code --


Any ideas as to what I'm doing wrong????

Thanks

[Newsgroup_User]

> if(Request.QueryString(?day7?)

What are those question marks for?

-Darrel

[GTN1707]

Where do you see ? question marks? they should be " (shift and 2 (on a UK keyboard)) quotation marks,.. how odd all i see is "" quotation marks? Thanks....

[Newsgroup_User]

> Where do you see ? question marks? they should be " (shift and 2 (on a UK
> keyboard)) quotation marks,.. how odd all i see is "" quotation marks?
> Thanks....

that's likely the problem. You might not be using the actual quote
characters for those. Are they maybe double single quotes? Curly quotes?

-Darrel

[GTN1707]

Spot on Darrel, thanks, i guess that is the problem with cutting and pasting from MS Word!!!. The bad news is that having overcome that problem, I now get a precision invalid error, (below) I can see that this is because I'm updating data in a DECIMAL column, but not sure how or what to do to fix it??

Any ideas??

"Microsoft OLE DB Provider for SQL Server error '80004005'

The precision is invalid.

/admin/afterreviewupdatepricing.asp, line 80 "

CODE ATTACHED - -