Hi, Experts, I've got problem Inserting data on sqlserver 2008 using ASP or vbscript language. My problem here is when the amountA is has a comma then it would not save the Data. A message says; "There are fewer columns in the insert..." This maybe because of the comma in the amountA. What is the solution to handle the comma within the amountA? Any help please!
ename = "John"
amountA = "10,000.00"
con.execute("Insert into zPhone(eName,AmountA) values('" & ename & "'," & amountA & ")")