Alisa, >From what I see here: http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0661.mspx
It looks like if you're going to use set chained on (which in your case is built in to cftransaction), you also have to have begin transaction and commit transaction code in your Sprocs... I think. It also looks like you may need to tinker with your isolation settings in your cftransaction tag. I'll check into more if you need... let me know. Laterz, J On Mon, 28 Feb 2005 13:06:59 -0400, Alisa Thomson <[EMAIL PROTECTED]> wrote: > I know there aren't alot of people on the list using Sybase, but I am going > to give it a try! We are converting our CF5 development box to CFMX 6.1 > Updater. I ran across one stored procedure call that is giving me a problem. > It is inside a CFTRANSACTION (read_committed). No errors are thrown back to > the user, but the proc is not working and this error is in the > application.log: > > SET CHAINED command not allowed within multi-statement > transaction. > > I used Ribo to sniff the packets being sent to the database and I see that a > set chained on is being sent. I am not doing this explicitly. When I > comment out the CFTRANSACTION around the proc call, then the set chained on > command is not sent. I have not seen this behavior with my other proc calls. > Any ideas? > > Thanks, > Ci-Ci > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197123 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
