Hmm try doing <cfquery dbtype="query" name="qTest"> SELECT * FROM qExcel </cfquery>
then try using the qTest query ? lets see where its messing up A On 14 February 2012 16:59, Mats Stromberg <[email protected]> wrote: > 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 > -- 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
