You do know your query names don't match up..
Your reading the spreadsheet into a query object called DealsDSN and
looping over an object called "MahDSN"
On Fri, Aug 10, 2012 at 2:27 PM, Bruce Sorge <sor...@gmail.com> wrote:
>
> Hello list,
> Long time (years) no post.
>
> I am trying to read from a spreadsheet that is loaded up onto the server
> and then insert the information into the database. I have three column
> headers called Code, Barcode and ResortID. Code and Barcode have values and
> ResortID is empty. The reason that I did this is because I want to insert
> the ResortID from a formfield called ResortID. The problem is that I am
> getting the error message:
> Columc count doesn't match value count at row 1. Here is my code:
>
> <!--- Read the spreadsheet data into a query object --->
> <cfspreadsheet action="read" query="DealsDSN" headerrow="1"
> src="#ExpandPath("Spreadsheets/#ClientFile#")#" />
>
> <!--- Loop thorugh the query starting with the first row containing data
> (row 2) --->
> <cfloop query="MahDSN" startrow="2">
>
> <!--- Insert the code and bar code into the database for future use --->
> <cfquery datasource="DealsDSN" result="foobar">
> INSERT INTO BarCodes
> (Code, BarCode, ResortID)
> VALUES
> (
> <cfqueryparam cfsqltype="cf_sql_varchar" value="#Code#">
> <cfqueryparam cfsqltype="cf_sql_varchar" value="#BarCode#">
> <cfqueryparam cfsqltype="cf_sql_int" value="#Form.ResortID">
> )
> </cfquery>
> </cfloop>
>
> The error is on <cfqueryparam cfsqltype="cf_sql_int"
> value="#Form.ResortID">
>
> Any assistance is greatly appreciated.
>
>
> Bruce
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352092
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
