This would be totally and utterly awesome!!! (happy me - hopefully) I know that I shouldn't have used the .mdb in the query, but was just trying everything - wasn't sure what bd required...
Am a new mom and am tired and delirious most of the time these days. It's tough to keep track of the changes I made 10 minutes ago so have been making a working text file of the changes so that I avoid making the same mistakes twice thinking they are 'new ideas' (laugh). Tonight she actually went to bed early so I ran in here as fast as I could to work on the issue...I never know just how much time I'll have these days (sigh). My greatest appreciation! -belinda On Jan 17, 10:54 am, JLeone <[email protected]> wrote: > 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- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
