Well, that was my messup copy paste of the Browser output to an editer and back into this thread :) The "K" in "kundenname" went uppercase.
The real wierd is that I can output the qExcel.field1 without any error qExcel.kundenname generates the error. Also if I simply change that column name to field2 and try to output qExcel.field2 I get the error again. I will try to find one more column that is empty and see if that goes through without error. On Tue, Feb 14, 2012 at 9:53 AM, Alex Skinner <[email protected]> wrote: > Is it possible the column name is case sensitive ? > > Alex > > > ... >> > > Create an ArgumentCollection setting my column names... 37 columns in all >> (field 1 is an empty column... >> <cfset args = { >> spreadsheet : "#xlsObj#", >> sheet : 0, >> columnnames : "field1, kundenname, ref_whr, ..." >> } /> >> >> >> <cfoutput query="qExcel"> >> #qExcel.kundenname#<br /> >> </cfoutput> >> >> Returns trhe following error >> >> cfcatch struct >> column 3 >> detail Error at line 1, column 1 >> errorcode [empty string] >> extendedinfo [empty string] >> line 54 >> message qExcel.kundenname doesn't exist. >> scriptline 1 >> Not sure what's going on here... The SpreadsheetQueryread would have >> been such a sweet function to solve my Excel Import... >> Now I guest I have to go back to the looping through Columns and Rows and >> read each cell again... >> >> /Mats/ >> >> -- >> online documentation: http://openbd.org/manual/ >> google+ hints/tips: https://plus.google.com/115990347459711259462 >> http://groups.google.com/group/openbd?hl=en >> >> Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012 >> > > > > -- > Alex Skinner > Managing Director > Pixl8 Interactive > > Tel: +448452600726 > Email: [email protected] > Web: pixl8.co.uk > > -- > online documentation: http://openbd.org/manual/ > google+ hints/tips: https://plus.google.com/115990347459711259462 > http://groups.google.com/group/openbd?hl=en > > Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012 > -- *Mats Strömberg* *NETWORK 23* *Oracle Tablespace Report (Open Source)* Project Homepage: project-otr.jelastic.com Source Code: Google Code<http://code.google.com/p/oracle-tablespace-report/source/checkout> Still paying to use CFML? Keep your money and switch to OpenBD<http://www.openbluedragon.org> -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012
