k - sent a test db to you with 2 usable tables in it - two that I use quite often.
well, i know better than to put the .mdb in the cfquery tag and that I need quotes around variable data (some singles and some doubles depending on what's going on, etc...), but was 'trying everything' but a drill...so to speak.(laugh). I wasn't sure how blue dragon parsed the code and what the error messages meant so was trying everything to get a handle on what to expect with bd. Now, are you saying that in the administrator console, the .mdb is unnecessary? it read it in automatically that I overwrote in order to get it to see the db in the first place...should I remove the info from the bd.xml file and let bd freshly capture the data again to see what it does a second time? To yours and JLeone's point, normally I don't put actual dbnames in the queries. I set up an include that has all my variables defined that are constant in the application - like database, urls, images, etc... all in one locator page. I wasn't sure what bd required in the way of syntax -- was just trying everything to get it to read the db...once it's working, it'll just be variable data read in from a locator include. this way i only have to make changes to the site in one location if my includes directory should change or I add a new db or something. makes life easier... like a global vars page (is a global vars page...)...;-) -belinda On Jan 17, 10: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 !! -~----------~----~----~----~------~----~------~--~---
