Irvin, thanks. I realized that I was using the attributes incorrectly, because that's how another tag, CFX_Text2Query from the same author works. I need to get rid of the user supplied header row and provide my own and there doesn't seem to be an elegant way of doing that with this tag.
Irvin Gomez wrote: >Try: > ><cfx_excel2query > file="#excelfile#" > firstRowIsHeader = 1 > nodates > columnList="columns" > r_qResults="orderlist"> > >That will return a query object called "orderlist" and a variable named >"columns" that is a list of the column names in your excel file. > > > > > >>I am using it with this syntax: >> >><cfx_excel2query >> file="#excelfile#" >> r_qResults="orderlist" >> firstRowIsHeader="false" >> columnlist = "name,address,city,state,zip" >> >> >>The excel file has its own header, which I am trying to overwrite by >>the one provided with the 'columnlist' attribute. However, when I >>supply that attributed the return recordset isn't created - I can't >>cfdump it because the object doesn't exist. >> >>Any tips would very appreciated! >> >>Stas >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187615 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
