That's great advice, thanks! On Mon, Apr 25, 2011 at 6:32 PM, Matthew Woodward <[email protected]>wrote:
> On Mon, Apr 25, 2011 at 3:27 PM, Colin MacAllister < > [email protected]> wrote: > >> I have a query that runs fine in SQL Server Studio, returning the >> single username as it is meant to. However, when I place this query in >> a cfquery tag I get zero results returned. Both are hitting the same >> datasource using the same account. I'm wondering whether the "with" >> clause or the table variable is unsupported. Or maybe it is the >> recursive nature of the "with" clause that isn't working in openbd? >> > > Since this is a common point of confusion, I'd like to point out that once > you're inside the cfquery block all it's doing is passing whatever is in > there to the database over JDBC. So if you're seeing issues as you're > describing it's an issue with the driver and/or what is and isn't supported > over JDBC. OpenBD doesn't care about the TABLE variable, or the WITH clause, > or anything like that. At that point it's entirely JDBC and OpenBD doesn't > know or care what's going on with your SQL. > > Hitting the database in SQL Server Studio and hitting it over JDBC are two > vastly different things. To troubleshoot you might try using a tool like > Aqua Data Studio that also communicates over JDBC. > > -- > Matthew Woodward > [email protected] > http://blog.mattwoodward.com > identi.ca / Twitter: @mpwoodward > > Please do not send me proprietary file formats such as Word, PowerPoint, > etc. as attachments. > http://www.gnu.org/philosophy/no-word-attachments.html > > -- > official tag/function reference: http://openbd.org/manual/ > mailing list - http://groups.google.com/group/openbd?hl=en > -- Colin -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
