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
