I had just converted from Access to H2 (pre-admin console.) I'll find an old copy of my app and post the entry in the bluedragon.xml on what it looks like. And as Matt pointed out... you don't have the .mdb in the cfquery. You point directly to the file at the datasource side and then point to the datasource name in cfquery.
-Josh On Jan 17, 8:21 am, Matthew Woodward <[email protected]> wrote: > btousson wrote: > > Here is my query: > > [ > > <cfquery name=Get_ProdMenu_Data datasource=EHB_Web_Database.mdb> > > Select * > > >From Blend_Info > > Where Retired_Blend = No > > </cfquery> > > ] > > I don't suppose you could send me an Access 2000 database to try, could > you? I don't have Access but with a database I could mess with it on a > Windows XP VM. If you can send me something, send it to matt at > mattwoodward dot com and I'll mess with it. > > Did you actually name your datasource with the .mdb at the end? If not, > you don't need that. Also, and this probably isn't causing the issue, > but you should have quotes around your attribute values: > <cfquery name="Get_ProdMenu_Data" datasource="EHB_Web_Database"> > > -- > Matt Woodward > [email protected]http://www.mattwoodward.com/blog > > Please do not send me proprietary file formats such as Word, PowerPoint, etc. > as attachments.http://www.gnu.org/philosophy/no-word-attachments.html > > smime.p7s > 4KViewDownload --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
