I am getting the following error, I can not find out what is causing
it. I can narrow down
the code. But the thing is that the SQL that is causing it is only
throwing the error
in this instance. I can dump out the sql fine, and i can run it
against another recordset.
Which is leaving me to think that it is a bug of some kind with QoQ's.
I know QoQ's have severe limitations, but I have learned to work
around most of them.
but this one has me stumped.
after some googling i found that this is a known bug with
org.apache.oro.text.regex.Perl5Matcher.matches but from what was in
the thread it was
not fixed because they couldn't produce a test case? Can anyone confirm this?
any ideas?
thanks,
ricardo.
The system has attempted to use an undefined value, which usually
indicates a programming error, either in your code or some system
code.
Null Pointers are another name for undefined values.
The error occurred in
C:\CFusionMX\wwwroot\sheadoffice\crm\crmPluginSelect.cfm: line 113
Called from C:\CFusionMX\wwwroot\sheadoffice\crm\crmPluginSelect.cfm: line 1
Called from C:\CFusionMX\wwwroot\sheadoffice\index.cfm: line 150
Called from C:\CFusionMX\wwwroot\sheadoffice\index.cfm: line 1
111 : <cfelse>
112 : ORDER BY #url.column# #url.dir#
113 : </cfif>
114 : </cfquery>
115 :
Please try the following:
* Check the ColdFusion documentation to verify that you are using
the correct syntax.
* Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3)
Gecko/20040921 Firefox/0.10.1
Remote Address 127.0.0.1
Referrer
http://localhost:8500/sheadoffice/index.cfm?cmd=crm&xs=crmPluginSelect&start=1&dir=ASC&fieldList=field0,field2,field3,field16&column=field3&returnTo=to&valueList=field16
Date/Time 27-Oct-04 02:21 PM
Stack Trace
at
cfcrmPluginSelect2ecfm744667458._factor1(C:\CFusionMX\wwwroot\sheadoffice\crm\crmPluginSelect.cfm:113)
at
cfcrmPluginSelect2ecfm744667458.runPage(C:\CFusionMX\wwwroot\sheadoffice\crm\crmPluginSelect.cfm:1)
at cfindex2ecfm1423500030._factor14(C:\CFusionMX\wwwroot\sheadoffice\index.cfm:150)
at cfindex2ecfm1423500030.runPage(C:\CFusionMX\wwwroot\sheadoffice\index.cfm:1)
java.lang.NullPointerException
at org.apache.oro.text.regex.Perl5Matcher.matches(Unknown Source)
at coldfusion.sql.imq.rttExprCondLike.evaluate(rttExprCond.java:540)
at coldfusion.sql.imq.rttExprCondTest.evaluate(rttExprCond.java:273)
at coldfusion.sql.imq.rttExprCondOr.evaluate(rttExprCond.java:194)
at coldfusion.sql.imq.rttExprCondOr.evaluate(rttExprCond.java:194)
at coldfusion.sql.imq.rttExprCondOr.evaluate(rttExprCond.java:194)
at
coldfusion.sql.imq.rttSelectExprSpec.evaluateWhere(rttSelectExprSpec.java:245)
at coldfusion.sql.imq.rttSelectExprSpec.evaluate(rttSelectExprSpec.java:189)
at coldfusion.sql.imq.rttSelectStmt.evaluate(rttSelectStmt.java:61)
at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:539)
at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:131)
at
coldfusion.sql.imq.jdbcPreparedStatement.execute(jdbcPreparedStatement.java:94)
at coldfusion.sql.Executive.executeQuery(Executive.java:979)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:233)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at
cfcrmPluginSelect2ecfm744667458._factor1(C:\CFusionMX\wwwroot\sheadoffice\crm\crmPluginSelect.cfm:113)
at
cfcrmPluginSelect2ecfm744667458.runPage(C:\CFusionMX\wwwroot\sheadoffice\crm\crmPluginSelect.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at
cfindex2ecfm1423500030._factor14(C:\CFusionMX\wwwroot\sheadoffice\index.cfm:150)
at cfindex2ecfm1423500030.runPage(C:\CFusionMX\wwwroot\sheadoffice\index.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:24)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:168)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182679
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
