HI JB, A DB header is the name of the column name, such as record_id, username, password. I am not sure if this is the right term, but it is what I use. I am a newbie, so I might be wrong. I use My SQL 5 on Tiger, so feel free to ask questions. I also use navicat which is a great tool if you are new to MySQL
Oh, cool I did not know that about the session, that is good to know. I would make sure that mySQL is properly install and working great, since you say you are un sure. John On Feb 22, 2009, at 4:24 PM, J.B. Mentzer wrote: > > 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:4391 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
