Uh, guys? An interesting note...I hate to be the bearer of bad news, but I just thought I'd clean up the query and remove the .mdb from the cfquery - and gues what....???? It can't even see the database when I do that. At least when I put in the .mdb, it reads the db:
with .mdb at end of database in query: [ 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 * ] without .mdb at end of database in query [ Type Database Detail The datasource EHB_Web_Database could not be found or was invalid Extended Info javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial 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> 66: Select * ^ Snippet from underlying CFML source ] Now I'm really curious as to what else is different??? (smile) -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 !! -~----------~----~----~----~------~----~------~--~---
