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 !! -~----------~----~----~----~------~----~------~--~---
