Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Microsoft VBScript compilation error '800a0408'

Explorer ,
Feb 20, 2008 Feb 20, 2008
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

TOPICS
Server side applications
1.7K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 20, 2008 Feb 20, 2008
> if(Request.QueryString(?day7?)

What are those question marks for?

-Darrel


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 20, 2008 Feb 20, 2008
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....
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 20, 2008 Feb 20, 2008
> 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


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 21, 2008 Feb 21, 2008
LATEST
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 - -
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines