Converting datatype in SQL

[rorlini]

Why do I get a "error converting datatype varchar to numeric" when I do an insert in SQL using Cold Fusion?

I do an identical insert as a previous field. The field is etup as numeric ion the SQL table.

Robert O.

[txbakers]

could you be sending the data with single quotes?

That comes up sometimes.

I'm not familiar with the cold fusion syntax, but write out your query to the screen before sending it so you can see any syntax errors.