There is only query in the custom tag's template. Thank you,
* JB * Chris Blackwell wrote: > 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] <mailto:[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]> > [mailto:[email protected] <mailto:[email protected]>] > On Behalf Of > J.B. Mentzer > Sent: Sunday, February 22, 2009 9:34 PM > To: [email protected] <mailto:[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 !! -~----------~----~----~----~------~----~------~--~---
