Hi JB, I have had that type of error before, are you sure your SQL is correct,and that all the headers are in your DB? I have had that happened to me in the past, that I was selecting a DB header that was not there and I got your error. I am not sure about blue dragon as I never used it, but I think that your error is SQL and not the server.
The only part that I am unsure is the datasource="#SESSION.dsn#" I never used that it looks fine to me. John On Feb 22, 2009, at 3:57 PM, J.B. Mentzer wrote: > > 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:4387 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
