Hi Matt: It sees the db (supposedly??) Am I entering the sql query incorrectly for it to interact with openbd?
Here is my query: [ <cfquery name=Get_ProdMenu_Data datasource=EHB_Web_Database.mdb> Select * >From Blend_Info Where Retired_Blend = No </cfquery> ] -------- Here is the error on the .cfm page. it can't find data in the table. the table is full of data... [ General SQL Error Request /Site2008/Products/Blends/Blends.cfm File Trace C:/jetty-openbd/webroot_cfmlapps/cfmlWebContext_1/Site2008/ Products/Blends/Blends.cfm Type Database Query Error No data found Datasource EHB_WEB_DATABASE.MDB Native Error Code 0 SQL State SQL Select * From Blend_Info Where Retired_Blend = No Tag Context CFQUERY: Line=65; Column=1 Source 62: <br><br><i>Select the Health Category of interest below or scroll down our product menu on the right. The product information will appear Below Menu Section. </i></font></td></tr></table></td></ tr><tr> 63: <!--- These two local variables set up the read ability of the Blends page to read from the Blended Information Table 5-5-06 ---> 64: 65: <cfquery name=Get_ProdMenu_Data datasource=EHB_Web_Database.mdb> 66: Select * ^ Snippet from underlying CFML source ] In the meantime, I've downloaded the migration tool for mysql per adam's note..but hope for now this can be made to work for now???? - belinda --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
