CFMX7 and query of queries

[the_last]

Migrating from CFMX61 to CFMX7 I'm not able to execute query of queries. For
exemple the following code: <cfquery name='q1' datasource='foo'
username='fooUser' password='1234'> select detail from users limit 10
</cfquery> <cfquery name='q2' dbtype='query'> select detail from q1 limit 3
</cfquery> gives an 'error executing database query' in line 4. I'm using xp
home, cfmx7 with builtin web server and postgresql 8.0.1 (jdbc driver:
postgresql-8.0.309.jdbc3.jar)

[the_last]

Migrating from CFMX61 to CFMX7 I'm not able to execute query of queries. For
exemple the following code: <cfquery name='q1' datasource='foo'
username='fooUser' password='1234'> select detail from users limit 10
</cfquery> <cfquery name='q2' dbtype='query'> select detail from q1 limit 3
</cfquery> gives an 'error executing database query' in line 4. I'm using xp
home, cfmx7 with builtin web server and postgresql 8.0.1 (jdbc driver:
postgresql-8.0.309.jdbc3.jar)

[Damon Cooper]

We'll check it out now. Thanks!


"the_last" <webforumsuser@macromedia.com> wrote in message
news:d1cg1s$91q$1@forums.macromedia.com...

> Migrating from CFMX61 to CFMX7 I'm not able to execute query of queries.
> For
> exemple the following code: <cfquery name='q1' datasource='foo'
> username='fooUser' password='1234'> select detail from users limit 10
> </cfquery> <cfquery name='q2' dbtype='query'> select detail from q1 limit
> 3
> </cfquery> gives an 'error executing database query' in line 4. I'm using
> xp
> home, cfmx7 with builtin web server and postgresql 8.0.1 (jdbc driver:
> postgresql-8.0.309.jdbc3.jar)
>

[Warpuser]

Any solution to the above problem? I'm having the exact same problem (I'm also using same version Posgres, JDBC, Windows)....Thanks.

[sdupre]

This is bug 60082. Problems with PostGreSQL 8.x with the latest
postgresql-8.0-311.jdbc3.jar driver. Last driver that worked was:
pg74.215.jdbc3 Here's the stack I get: java.sql.SQLException at
coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.jav a:76) at
coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.jav a:59) at
coldfusion.sql.SqlImpl.execute(SqlImpl.java:214) at
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:498) at
cftestdata2ecfm1449602384.runPage(C:\CFusionMX7\ww wroot\Patin\testdata.cfm:11)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :152) at
coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:343) at
coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:65) at
coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:210) at
coldfusion.filter.PathFilter.invoke(PathFilter.jav a:86) at
coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:50) at
coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
er.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:38) at
coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22) at
coldfusion.CfmServlet.service(CfmServlet.java:105) at
coldfusion.bootstrap.BootstrapServlet.service(Boot strapServlet.java:78) at
jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:91) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:257) at
jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:527) at
jrun.servlet.http.WebService.invokeRunnable(WebSer vice.java:172) at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:349)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:457)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:295)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66) Stephen Dupre
Macromedia QA