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