I get the exact same Error. I can output qTest.field1 but qText.kundenname (or if I change the column name into field2 I get the error again
qTest.kundenname doesn't exist. or qTest.field2 doesn't exist. On Tue, Feb 14, 2012 at 10:02 AM, Alex Skinner <[email protected]> wrote: > 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 > -- *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
