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')
is now my output and here is my error code 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. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (38:2) to (38:60). Here my code. <cffile action="READ" file="\\prmhtstr\dsweb\aaaweb2.txt" variable="aaaweb"> <!--- Get Column Names, Data Types from Form Field TableName and DSN(should be an hidden form fields ---> <cfquery name="GetTableInfo"datasource="DSSWeb"> sp_columns CDM </cfquery> <cfquery name="Delete" datasource="DSSWeb"> DELETE FROM dbo.cdm </cfquery> <cfset ColumnHeader = ""> <cfset Counter = 0> <cfset ColumnData = ""> <cfset ColNumb =0> <cfloop query="GETTableInfo"> <cfset ColumnHeader = ColumnHeader &"," & column_name> </cfloop> <cfset ColumnHeader = Replace(ColumnHeader,Left(ColumnHeader,1),"")> <p> <cfoutput> <cfloop index="RowInfo" list="#aaaweb#" delimiters="#chr(10)#"> <cfset RowInfo = Replace(RowInfo,chr(9),"|","ALL")> <!--- #RowInfo#<br> ---> <cfloop index="Column" list="#RowInfo#" delimiters="|"> <cfset ColumnData = Replace(RowInfo,"|","', '","ALL")> </cfloop> <!--- <cfset ColumnData = Replace(columnData,Left(ColumnData,1),"")> ---> Insert into dbo.cdm<br> (#ColumnHeader#)<br> values<br> ('#RTrim(ColumnData)#')<br> <cfquery name="Insert" datasource="DSSWeb2" dbtype="OLEDB"> Insert Into dbo.CDM (#ColumnHeader#) Values ('#RTrim(ColumnData)#')</cfquery> <cfset ColumnData = ""> <cfset Counter = 0> <cfset ColNumb = 0> <br> </cfloop> </cfoutput> </p> ----- Original Message ----- From: "Andy Parry" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 10, 2002 7:56 PM Subject: RE: Help with insert statment into sql 2000 > 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') > > > > > ______________________________________________________________________ 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=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists