Hi JB, Can you show us the stacktrace that comes with the Internal Server Error?
Thanks Andy J.B. Mentzer wrote: > 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 !! -~----------~----~----~----~------~----~------~--~---
