John Barrett wrote: > 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? > What is a DB header? Are they used with MySQL 5 installations on Mac OS X 10.4.11?
It's a new installation of MySQL that may not be configured correctly ... I've been unable to find anyone in the Boston Metrowest area who will instruct me while they configure my computer. > 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. > Ok. > I am not sure about blue dragon as I never used it, but I think that > your error is SQL and not the server. > Agreed. That's why I posted it here ... and not on the Blue Dragon list ... greater MySQL knowledge here. > The only part that I am unsure is the datasource="#SESSION.dsn#" I > never used that it looks fine to me. > That puts the datasource name into a session variable, so that if it's changed, the developer doesn't need to edit every template it's used on. Thanks, * JB * > >> 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:4388 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
