I just found a solution to this problem. See this URL:
http://www.adobeauthorizations.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=6&threadid=1289922&enterthread=y In short ... the answer is to append "AlwaysReportTriggerResults=true" to the url string in your neo-datasource.xml file. Hope this helps :) On Nov 16, 12:38 pm, Plat <[EMAIL PROTECTED]> wrote: > For what it's worth, I'm running into the sameproblemporting my CF5 > applications to CF8. When the query begins with "INSERT" (rather than > "SELECT"), the query object doesn't seem to get created. > > I've temporarily worked around this by using "SET NOCOUNT ON" prior to > the INSERT call, but am still looking for a real fix. > > Also, cumulative hot fix 2 was released yesterday. Not sure if it'll > help though: > > http://kb.adobe.com/selfservice/viewContent.do?externalId=kb402792&sl... > > On Nov 12, 9:35 pm, "Scott Thornton" > > <[EMAIL PROTECTED]> wrote: > > heya, > > > thats right, the code worked in 6, then fell over on 8 running locally. > > > I didn't try another alias. > > > yes, there was a transaction wrapping a few queries.... I had placed a > > CFABORT past the point of failure (but before the closing cftransaction > > tag). > > > the query was falling over for no apparent reason in relation to the new_id > > not being in existence, the code when run back on version 6 ran as I would > > expect, the ID existed all the way up until the cfabort that caused the > > transaction to fail. > > > my line of thinking is thatdatabasequeries and debugging is handled > > somewhat differently to 6 in 8. the cfabort causing the debug to get out of > > synch with the transaction or something. > > > hopefully I will have some time soon to get back to testing this theory... > > > >>> "Barry Beattie" <[EMAIL PROTECTED]> 13/11/2007 12:33 pm >>> > > > Still no joy, Scott? > > > the code works on CF6.1 but falls over on CF8, right? > > > and "new_id" is def not a new reserved word entering the volcabulary > > (ie: you've tried another alias)? > > > is there a cftransaction wrapping that query (or further upstream in the > > call)? > > > On 11/13/07, Scott Thornton <[EMAIL PROTECTED]> wrote: > > > > quote: If you dump out the insert query, you will see that the newly > > > created ID is there waiting for you, if you want to change your code > > > around ;) > > > > I remember hearing that now. thats just on cf 8 right? > > > > the code must be backward compatible with cfmx 6.1 still though. > > > > the example I had works elsewhere, just not on the page when I was > > > debugging something else... > > > > >>> "Mark Mandel" <[EMAIL PROTECTED]> 12/11/2007 4:50 pm >>> > > > > Barry - > > > > It's done through the JDBC driver, so it's probably right down into the > > > DB core. > > > > Mark > > > > On Nov 12, 2007 4:35 PM, Barry Beattie <[EMAIL PROTECTED]> wrote: > > > > > @Mark: is that SCOPE_IDENTITY or @@IDENTITY that the id is gotten from? > > > > > @Scott: what happens if you change "new_id" to some other alias? (or > > > > additionally put new_id in square brackets) > > > > > select scope_identity() as [new_id] > > > > > On Nov 12, 2007 3:31 PM, Mark Mandel <[EMAIL PROTECTED]> wrote: > > > > > > If you dump out the insert query, you will see that the newly created > > > > > ID is there waiting for you, if you want to change your code around ;) > > > > > > Mark > > > > > > On Nov 12, 2007 2:41 PM, Scott Thornton > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > Hi, > > > > > > > Running version 8,0,0,176276 on local against a MS SQL 2005database. > > > > > > > I ran into aproblemlate last week where a query returning the id > > > > > > after an insert eg: > > > > > > > <cfquery ......> > > > > > > insert ........ > > > > > > select scope_identity() as new_id > > > > > > </cfquery> > > > > > > > the compiler would return the error queryname.new_id is undefined. > > > > > > > The exact same code worked when executed against a cfmx6.1 against > > > > > > the samedatabasewith nothing changed. > > > > > > > The application has this usage throughout it and those other bits > > > > > > of code are fine. > > > > > > > Soo, > > > > > > > I was wondering has anyone ran into this intermittentproblembefore? > > > > > > > I notice there is a Hot Fix > > > > > > availablehttp://kb.adobe.com/selfservice/viewContent.do?externalId=kb402466&sl...CF > > > > > > 8...... but the issues list does not seem to reference > > > > > > anydatabaseissues... > > > > > > > Is there a JDBC driver update available for it as well that I > > > > > > cannot find? > > > > > > > Also, how do I find out what version of jdbc I have? > > > > > > > Cheers, > > > > > > -- > > > > > E: [EMAIL PROTECTED] > > > > > W:www.compoundtheory.com > > > > -- > > > E: [EMAIL PROTECTED] > > > W:www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" 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/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
