In line with Hugo's response, taking everything down to a simple level and increasing from there is an excellent way to troubleshoot issues like this.
For example, I normally have a test_cf.cfm page which I use just for troubleshooting and researching code. In this instance, I would strip all the variables out of your cfquery (the session.dsn and caller.gm_classes) and use the data source name from the OpenBD Adminitrator that you said is verifying correctly. If the query works that way, then add your session.dsn back in and so on and so forth until you've isolated the cause. The trick is testing one value at a time. Once you get more familiar with debugging CFML, it will get easier to figure things out without having to drop down to a basic level and move up one step at a time, but sometimes it's just the easiest way to break down an aggrivating issue. That said, we will help you as much as we can (if I may so boldly speak for others on the list). On Thu, Feb 26, 2009 at 6:13 AM, Hugo Ahlenius <[email protected]> wrote: > > Hi JB, > > I think it would help if you could maybe try to isolate the problem - you > mention it as if a custom tag can't do X - try to put this in a > simple/plain > template to if it is related to it being custom tag (I suspect not). > > If it still fails, try some simple queries, and see if they work. > > My feeling is that there is something in the setup of the data source, or > the driver, that causes your problems. > > /H. > > -- > Hugo Ahlenius > fraxinus (at-sign) oxel.net > http://www.oxel.net > > > > > > -- Anthony Hixon, Jr. Certified Advanced ColdFusion MX 7 Developer Mobile: (706) 639-3617 [email protected] --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
