Anyone know whats wrong wit hthis insert into

[Newsgroup_User]

commInsert.Execute("INSERT INTO customers(firstname,lastname) VALUES('" +
Replace(Command1__varOne, "'", "''") + "', '" + Replace(Command1__varTwo,
"'", "''") + "', " + Replace(Command1__varThree, "'", "''") + ") " ' Execute
the insert command

Getting this error

Microsoft VBScript compilation (0x800A03EE)
Expected ')'
commInsert.Execute("INSERT INTO customers(firstname,lastname) VALUES('" +
Replace(Command1__varOne, "'", "''") + "', '" + Replace(Command1__varTwo,
"'", "''") + "', " + Replace(Command1__varThree, "'", "''") + ") " ' Execute
the insert command
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------------------------------------------------------------^
Ta

Andy

[delaneypub]

Can't tell exactly, since your lines are wrapping here in the forum. Howeve, the error message says it is expecting a close-paren, and you have an uneven number of parens in your code, so that would be my guess.

The carat should be pointing to the position at which the vbscript compiler was expecting the close-paren.