[thelist] Help Finding & Fixing VBScript Error

Administrative HQ english_offline at yahoo.com
Thu Mar 10 01:40:35 CST 2005


I'm hoping someone can help me get a page working.

I'm getting the following error message:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/pay_paypal.asp, line 74


The section of code the error message is reffering to

66 set cm = Server.CreateObject("ADODB.Command")
67 cm.ActiveConnection = Connection
68 cm.CommandText = "INSERT INTO users(CardType,
CardNumber, CardExpiry, Amount, Monthly) values('"_
69 & CardType &"','"_
70 & CardNumber &"','"_
71 & CardExpiry &"','"_
72 & Amount &"','"_
73 & Monthly &"','"_
74 cm.execute

'Response.Write "
user added sucsessfully


'send email to user to confirm his login details

'Dim objCDO
'Set objCDO = Server.CreateObject("CDONTS.NewMail")

This may not be all that's needed to ge the page up,
but previous error messages seem to have been taken
care of. I can't see what's causing this one.

Any help would be greatly appreciated.


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

More information about the thelist mailing list