the semi-colon at the end of the statement will make no difference, by default only the first query will be processed. It is possible to enable multiple queries in MySQL by adding allowMultiQueries=true to the connection string, although i'd recommend against doing it.
2009/2/23 Paul Kukiel <[email protected]> > > I believe this is the issue: > > ORDER BY '#ATTRIBUTES.order_by#'; > > It should be: > > ORDER BY #ATTRIBUTES.order_by# > > The ; at the end is telling mySQL that there is a 2nd query when there > isn't. I don't think this is supported with Coldfusion either under mySQL. > ( I use MSSQL so mySQL is not my specialty ). > > Paul > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of > J.B. Mentzer > Sent: Sunday, February 22, 2009 9:34 PM > To: [email protected] > Subject: [OpenBD] Query bombing Blue Dragon ... how to resolve? > > > Hi all, > > Trying to get one of my websites to work on my Mac running BlueDragon > ... and have run into an error I can't resolve. Here's the query in > question: > > <cfquery datasource="#SESSION.dsn#" name="CALLER.gm_parts"> > SELECT > parts_ID, > reference_pn, > category, > img_med, > img_lg, > part_name, > part_desc, > price_each, > price_100 > > FROM > parts > > WHERE > product_line = '#SESSION.product_line#' > > ORDER BY '#ATTRIBUTES.order_by#'; > </cfquery> > > > As written, the page generates an "Open BD Internal Server Error" > complete with Stack Trace and a verbose dump of variables. > > When I include an equals sign in the Order By Clause, this error is > generated: > > Query Error You have an error in your SQL syntax; check the manual > that corresponds to your MySQL server version for the right syntax to > use near '= 'reference_pn'' at line 18. > > What do I need to do to resolve this? > > Thank you, > > * JB * > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
