I can't see anything from with your SQL syntax. You sure that is the right TQL query that is failing?
Mark On Fri, Oct 1, 2010 at 6:33 AM, David Long <[email protected]> wrote: > I am sure. I run another transfer call just before this one and that > one works just fine. Nothing is wrong in my TQL syntax? > > On Sep 30, 4:32 pm, Mark Mandel <[email protected]> wrote: > > That looks like it should work. > > > > You sure you're not pointing it at the wrong config file, or anything > silly > > like that? > > > > Mark > > > > On Fri, Oct 1, 2010 at 6:25 AM, David Long <[email protected]> > wrote: > > > The exact error message from ACF > > > > > Exception - struct > > > Detail Could not find 'category' in '/home/david/opt/coldfusion/8/ > > > wwwroot/config/transfer.xml'. > > > ErrorCode [empty string] > > > ExtendedInfo [empty string] > > > Message The requested object could not be found in the config > file > > > StackTrace coldfusion.runtime.CustomException: The requested > object > > > could not be found in the config file at > > > coldfusion.tagext.lang.ThrowTag.doStartTag(ThrowTag.java:124) at > > > coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at > > > cfObjectDAO2ecfc95842874$funcTHROW.runFunction(/home/david/opt/ > > > coldfusion/8/wwwroot/transfer/com/object/ObjectDAO.cfc:637) at > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2471) at > > > cfObjectDAO2ecfc95842874$funcGETOBJECT.runFunction(/home/david/opt/ > > > coldfusion/8/wwwroot/transfer/com/object/ObjectDAO.cfc:72) at > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > 360) at coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > cfObjectManager2ecfc211571543$funcGETOBJECT.runFunction(/home/david/ > > > opt/coldfusion/8/wwwroot/transfer/com/object/ObjectManager.cfc:63) at > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > 360) at coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > cfProperty2ecfc2086165857$funcEVALUATEPROPERTYIDENTIFIER.runFunction(/ > > > home/david/opt/coldfusion/8/wwwroot/transfer/com/tql/walkers/ > > > Property.cfc:56) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java: > > > 418) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > 360) at coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > cfSelectColumn2ecfc650005570$funcEVALUATESELECTAST.runFunction(/home/ > > > david/opt/coldfusion/8/wwwroot/transfer/com/tql/walkers/ > > > SelectColumn.cfc:43) at > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > 360) at coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2471) at > > > cfSelectColumn2ecfc650005570$funcEVALUATESELECTAST.runFunction(/home/ > > > david/opt/coldfusion/8/wwwroot/transfer/com/tql/walkers/ > > > SelectColumn.cfc:105) at > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > 360) at coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > > cfSelectStatement2ecfc1551394529$funcEVALUATESELECTSTATEMENT.runFunction(/ > > > home/david/opt/coldfusion/8/wwwroot/transfer/com/tql/ > > > SelectStatement.cfc:154) at > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > 360) at coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2471) at > > > cfSelectStatement2ecfc1551394529$funcSELECTSTATEMENT.runFunction(/home/ > > > david/opt/coldfusion/8/wwwroot/transfer/com/tql/SelectStatement.cfc: > > > 102) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > 360) at coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) at > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222) at > > > cfTQLManager2ecfc624316183$funcEVALUATEQUERY.runFunction(/home/david/ > > > opt/coldfusion/8/wwwroot/transfer/com/tql/TQLManager.cfc:28) at > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > 360) at coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > cfTransfer2ecfc1685525181$funcLISTBYQUERY.runFunction(/home/david/opt/ > > > coldfusion/8/wwwroot/transfer/com/Transfer.cfc:562) at > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > 360) at coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > cfvariations2ecfc1380500055$funcEDITCUSTOM.runFunction(/home/david/opt/ > > > coldfusion/8/wwwroot/admin/controllers/variations.cfc:173) at > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) at > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) at > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222) at > > > coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:362) at > > > cfframework2ecfc1462850834$funcDOCONTROLLER.runFunction(/home/david/ > > > opt/coldfusion/8/wwwroot/org/corfield/framework.cfc:1207) at > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > coldfusion.runtime.UDFMethod > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > > ... > > > > read more ยป > > -- > Before posting questions to the group please read: > > http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer > > Try out the new Transfer ORM Custom Google Search: > http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 > > You received this message because you are subscribed to the Google Groups > "transfer-dev" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<transfer-dev%[email protected]> > For more options, visit this group at > http://groups.google.com/group/transfer-dev?hl=en > -- E: [email protected] T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) - Nov 18, 19 - Melbourne Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search: http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 You received this message because you are subscribed to the Google Groups "transfer-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/transfer-dev?hl=en
