Hi all,
Loading the page that calls this query generates this error:
rror 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
I've tried a few things, goodled several websites, but I can't see what
the error is.
<cfquery datasource="#SESSION.dsn#" name="CALLER.gm_parts"> <!-- Line 17 -->
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>
Here's the Error Syntax from BlueDragon:
Type Database
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
Datasource TMW
Native Error Code 1064
SQL State 42000
SQL SELECT parts_ID, reference_pn, category, img_med, img_lg,
part_name, part_desc, price_each, price_100 FROM parts WHERE
product_line = 'op' ORDER BY = 'reference_pn'
Tag Context CFINCLUDE: Line=20; Column=1
|
+-- cf_tag_gm_current_parts: Line=106; Column=23
|
+-- CFQUERY: Line=18; Column=1
Source
15: -->
16:
17: <cfquery datasource="#SESSION.dsn#" name="CALLER.gm_parts">
18: SELECT
19: parts_ID,
^ Snippet from underlying CFML source
Thank you,
* JB *
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4385
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
