Dear me, aaaaaaaaaaaa is not reserve word. Looks like I've to install MX again to resolve this issue.
-----Original Message----- From: Sam Farmer [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 20:26 To: CF-Talk Subject: Re: Shall I start Pulling my Hair I've used aliases longer than 11 characters in the same set up as you have so thats not it. My guess is some sort of reserved word issue? Cheers, Sam ----- Original Message ----- From: "Shahzad.Butt" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 03, 2002 10:23 AM 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
