If the end of your stack trace looks like this: java.lang.NullPointerException at com.mysql.jdbc.Connection.initializeResultsMetadataFromCache(Connection.java:5917)
Then you'll need to edit the MySQL datasource settings and set cacheResultSetMetadata to false. 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 !! -~----------~----~----~----~------~----~------~--~---
