What do you get when you cfdump the query? Or output #myQuery.columnList#? ======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire
Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 03, 2002 9:23 AM > To: CF-Talk > Subject: Shall I start Pulling my Hair > > > Whats wrong with this simple code > > <CFQuery Name="myQuery" Datasource="Test"> > Select J_Sname.AccountNumber AS DetailField1 > From J_Sname > Where ID = '12' > </CFQuery> > > <CFOutput> > #myQuery.DetailField1# > </CFOutput> > > It gives error > > 'Element DETAILFIELD1 is undefined in myQuery. ' > > But if I use DETAILFIE1 (or anyother letter not more than 10 > characters) > instead of DETAILFIELD1 it works. As I pop in 11th character for my > alias it gives error. Is there any limit of characters in AS inside > query in CFMX????? > > Application Server: Coldfusion MX > DB: SQLServer 2000 > > > > Shahzad Butt (Development Engineer) > > JJ FastFood Distribution Ltd. > Office: +44 (0) 1992 701 722 > Mobile: +44 (0) 7803 584 873 > Fax: +44 (0) 1992 701 604 > > 7 Solar Way, Innova Park, Enfield, London, EN3 7XY > > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. > www.mimesweeper.com ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
