Hi david, you need commas to separate the values in the value list, and individual quotation marks around character fields. You have a single string as a value, hence the SQL server thinks that you are only submitting a single value, yet your insert statement is saying that you are sending 14 values.
HTH andy > -----Original Message----- > From: David Brown [mailto:[EMAIL PROTECTED]] > Sent: Monday, 11 February 2002 8:49 AM > To: CF-Talk > Subject: Help with insert statment into sql 2000 > > > Help. > I get this error every time I try to insert into my table. > OLEDB Error Code = 109 > There are more columns in the INSERT statement than values > specified in the > VALUES clause. The number of values in the VALUES clause must match the > number of columns specified in the INSERT statement. > > Here the output of my sql statment. > > Insert into dbo.cdm > (FAC, DPT, REV, FIM, F5, SIM, SimDescription, UP, HCPCS, PRICE, OpPrice, > PRO, SUPP, Supp2) > values > ('B BRB 6005 600510023 * 10023 7 AV_WEST LAT_PSYCH OBSERVATION > 0762 75000 NO > 2 04/29/2001') > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
