Regarding the Query of Query Run Time Error I highlighted earlier. here's how i created the problem.
I'm using FC 4-0-3 (1673) CFMX7, XP, MySQL5, Apache 2.2.4 and IE6. I was following Jeff C's video, where he creates a new HTML page under the tree root folder after first deleting the existing sample project pages. All i do is title the new html page, go to Body and into the Image Library under resources - drag across an image, exit and save. I don't add content or an image- even if I do add content it still errors. I appreciate the help and yes, I too, wish IE would go somewhere and die, preferably quietly! Cheers Robin Here is the dump: Query Of Queries runtime error. Comparison Exception: While executing "=" Unsupported Type Comparison Exception: Comparator operator "=" does not support comparison between following types: Left hand side expression type = "STRING". Right hand side expression type = "DOUBLE". The error occurred in C:\farcry\core\packages\formtools\array.cfc: line 331 Called from C:\farcry\core\tags\wizard\processwizardObjects.cfm: line 379 Called from C:\farcry\core\tags\wizard\processwizardObjects.cfm: line 373 Called from C:\farcry\core\tags\wizard\processwizardObjects.cfm: line 306 Called from C:\farcry\core\tags\wizard\processwizardObjects.cfm: line 300 Called from C:\farcry\core\tags\wizard\processwizardObjects.cfm: line 119 Called from C:\farcry\core\tags\wizard\processwizardObjects.cfm: line 1 Called from C:\farcry\core\packages\types\types.cfc: line 974 Called from C:\farcry\core\admin\conjuror\invocation.cfm: line 180 329 : <cfif listLast(i,":") NEQ listFirst(i,":")><!--- SEQ PASSED IN ---> 330 : AND seq = #listLast(i,":")# 331 : </cfif> 332 : </cfquery> 333 : -------------------------------------------------------------------------------- Resources: 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/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727) Remote Address 127.0.0.1 Referrer http://onlylsa/farcry/conjuror/invocation.cfm?objectId=24B7F8E9-FEA5-9F44-6F1FB5E539CB715B&TYPENAME=dmHTML&UPDATEAPP=false&METHOD=edit Date/Time 01-Aug-07 08:59 PM Stack Trace (click to expand) at cfarray2ecfc1367862081$funcVALIDATE.runFunction(C:\farcry\core \packages\formtools\array.cfc:331) at cfprocesswizardObjects2ecfm500852051$funcSETUPPROCESSOBJECT._factor6(C: \farcry\core\tags\wizard\processwizardObjects.cfm:379) at cfprocesswizardObjects2ecfm500852051$funcSETUPPROCESSOBJECT._factor8(C: \farcry\core\tags\wizard\processwizardObjects.cfm:373) at cfprocesswizardObjects2ecfm500852051$funcSETUPPROCESSOBJECT._factor9(C: \farcry\core\tags\wizard\processwizardObjects.cfm:306) at cfprocesswizardObjects2ecfm500852051$funcSETUPPROCESSOBJECT.runFunction(C: \farcry\core\tags\wizard\processwizardObjects.cfm:300) at cfprocesswizardObjects2ecfm500852051._factor10(C:\farcry\core\tags \wizard\processwizardObjects.cfm:119) at cfprocesswizardObjects2ecfm500852051.runPage(C:\farcry\core\tags\wizard \processwizardObjects.cfm:1) at cftypes2ecfc1635406396$funcEDIT.runFunction(C:\farcry\core\packages \types\types.cfc:974) at cfinvocation2ecfm1790072587.runPage(C:\farcry \core\admin\conjuror\invocation.cfm:180) coldfusion.sql.imq.rttExprComparator$ImqComparisonException: Query Of Queries runtime error. at coldfusion.sql.imq.rttExprComparator.compare(rttExprComparator.java: 457) at coldfusion.sql.imq.rttExprCondComp.evaluate(rttExprCondComp.java: 120) at coldfusion.sql.imq.rttExprCondTest.evaluate(rttExprCond.java:273) at coldfusion.sql.imq.rttExprCondAnd.evaluate(rttExprCond.java:145) at coldfusion.sql.imq.rttSelectExprSpec.evaluateWhere(rttSelectExprSpec.java: 245) at coldfusion.sql.imq.rttSelectExprSpec.evaluate(rttSelectExprSpec.java: 184) 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.Executive.executeQuery(Executive.java:753) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:240) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500) at cfarray2ecfc1367862081$funcVALIDATE.runFunction(C:\farcry\core \packages\formtools\array.cfc:331) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod $ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod $ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: 56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:345) at cfprocesswizardObjects2ecfm500852051$funcSETUPPROCESSOBJECT._factor6(C: \farcry\core\tags\wizard\processwizardObjects.cfm:379) at cfprocesswizardObjects2ecfm500852051$funcSETUPPROCESSOBJECT._factor8(C: \farcry\core\tags\wizard\processwizardObjects.cfm:373) at cfprocesswizardObjects2ecfm500852051$funcSETUPPROCESSOBJECT._factor9(C: \farcry\core\tags\wizard\processwizardObjects.cfm:306) at cfprocesswizardObjects2ecfm500852051$funcSETUPPROCESSOBJECT.runFunction(C: \farcry\core\tags\wizard\processwizardObjects.cfm:300) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod $ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod $ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: 56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1772) at cfprocesswizardObjects2ecfm500852051._factor10(C:\farcry\core\tags \wizard\processwizardObjects.cfm:119) at cfprocesswizardObjects2ecfm500852051.runPage(C:\farcry\core\tags \wizard\processwizardObjects.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java: 63) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255) at cftypes2ecfc1635406396$funcEDIT.runFunction(C:\farcry\core\packages \types\types.cfc:974) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod $ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod $ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: 56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341) at cfinvocation2ecfm1790072587.runPage(C:\farcry\core\admin\conjuror \invocation.cfm:180) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java: 225) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 51) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java: 52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java: 28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java: 22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java: 115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java: 78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java: 257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java: 541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: 204) at jrunx.scheduler.ThreadPool $DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool $ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool $UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
