Perhaps I responded to quick the correct syntax is: ORDER BY #ATTRIBUTES.order_by#
No ' ' or ; Paul. -----Original Message----- From: J.B. Mentzer [mailto:[email protected]] Sent: Sunday, February 22, 2009 9:28 PM To: cf-newbie Subject: Re: Can't resolve MySQL error 1064/Snytax Error ... Paul Kukiel wrote: > Hi JB, > > This line : > ORDER BY = '#ATTRIBUTES.order_by#'; > > should be: > ORDER BY '#ATTRIBUTES.order_by#'; > > There is no = needed. > When I try to run the template without the equals sign in the Order By clause, Open BlueDragon declares an "Open Internal Server Error". * JB * ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4390 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
