I see you are on CF9. Do you have a copy of CF10? If so, try copying over the CFCs. This may be something that was fixed.
On Tue, Oct 15, 2013 at 10:13 AM, Raymond Camden <raymondcam...@gmail.com>wrote: > Weird. Not that it matters, but try this mod: > > local.qryObj = new com.adobe.coldfusion.query(); > local.qryObj.setDatasource("PNGOasis"); > > then continue.... > > > > On Tue, Oct 15, 2013 at 10:02 AM, Kumar Shah <shahku...@gmail.com> wrote: > >> >> You get same error without the setName aspect: >> <cfscript> >> local.qryObj = new Query(datasource="PNGOasis"); >> local.qryObj.setSQL(" >> INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test value') >> "); >> local.qryObj.execute(); >> </cfscript> >> >> Error: >> 11:01:30.030 - Expression Exception - in >> C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460 >> >> Cannot find qryname19596 key in structure. >> >> >> >> >> On Mon, Oct 14, 2013 at 7:49 AM, Nando <d.na...@gmail.com> wrote: >> >> > >> > I don't use setName() in my script based queries and it works. If I >> need a >> > result back from the query, then I use a different variable name >> > (v.perviousPayPeriod) from the one I use to construct and execute the >> query >> > (v.payPerQ). Here's an example of some working code: >> > >> > v.payPerQ = new Query(); >> > v.payPerQ.setSql(" >> > select paymentPeriodId >> > from PaymentPeriod >> > where startDateTime = :startDateTime >> > and endDateTime = :endDateTime >> > and isClosed = 1 >> > "); >> > v.payPerQ.addParam( name='startDateTime', >> > value='#v.previousStartDateTime#', cfsqltype='cf_sql_timestamp' ); >> > v.payPerQ.addParam( name='endDateTime', >> value='#v.previousEndDateTime#', >> > cfsqltype='cf_sql_timestamp' ); >> > v.previousPayPeriod= v.payPerQ.execute().getResult(); >> > if (v.previousPayPeriod.RecordCount) { >> > ... do something >> > } else { >> > ... do something else >> > } >> > >> > >> > >> > >> > >> > On Mon, Oct 14, 2013 at 12:44 PM, Raymond Camden < >> raymondcam...@gmail.com >> > >wrote: >> > >> > > >> > > Two things. >> > > >> > > 1) Don't forget that the code behind the script based CFCs is not >> > > encrypted. You can look at base.cfc. >> > > >> > > 2) The issue seems to be this line: >> > > >> > > <cfset >> tagResult.setResult(StructFind(variables,tagAttributes['name']))> >> > > >> > > But - it is wrapped in a try/catch, so you shouldn't be seeing it. If >> you >> > > get rid of the setname aspect, which I don't think you need, does it >> work >> > > ok? >> > > >> > > >> > > >> > > >> > > On Sun, Oct 13, 2013 at 9:59 PM, Kumar Shah <shahku...@gmail.com> >> wrote: >> > > >> > > > >> > > > This is the first time I am creating components wholly in cfscript. >> > > > >> > > > When running update or insert statements via the cfscript query >> > functions >> > > > an error gets recorded like: >> > > > 22:52:17.017 - Expression Exception - in >> > > > C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460 >> > > > >> > > > Cannot find updSaveXML key in structure. >> > > > >> > > > >> > > > The system still processes fine. The query runs, data gets saved, >> > > > updated. I don't know why the error above gets reoorded. >> > > > >> > > > I ran a simple test with code: >> > > > >> > > > local.qryObj = new Query(datasource="PNGOasis"); >> > > > local.qryObj.setName("test"); >> > > > local.qryObj.setSQL(" >> > > > INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test >> > value') >> > > > "); >> > > > local.qryObj.execute(); >> > > > >> > > > Same Error: >> > > > >> > > > 22:58:48.048 - Expression Exception - in >> > > > C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460 >> > > > >> > > > Cannot find test key in structure. >> > > > >> > > > >> > > > Thanks >> > > > >> > > > >> > > > >> > > >> > > >> > >> > >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm