[thelist] Help Finding & Fixing VBScript Error

Barry Sweeney thelist at sweeneys.net
Thu Mar 10 03:10:17 CST 2005


Administrative HQ wrote:
> Hello.
> 
> ********************
> 
> The section of code the error message is reffering to
> is:
> 
> ********************
> 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


Looks like line 73 should be:

73 & Monthly & "'"


Barry



More information about the thelist mailing list