The following test code always generates a
"PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag" error when x is
greater than 25. The weird thing is it works fine if I move the
<cftransaction> tags *outside* of the loop or if I don't use <cftransaction>
at all. Any ideas why? We're using the Oracle native driver.
===========================
<cfloop from=1 to=200 index=x>
<cftransaction>
<cfquery datasource="surg_dev">
update surg.item
set item_stock_qty = #x#,
item_low_level_qty = #x#,
item_reorder_qty = #x#
where item_id = 99999
</cfquery>
[other similar & simple update queries deleted for viewability]
<cfset temp = #x#>
</cftransaction>
</cfloop>
<cfoutput>#temp#</cfoutput> iterations successful.
~~~~~~~~~~~~~~~~~~~~~~~~
Ricq Pattay <[EMAIL PROTECTED]>
Univ of Minnesota - Twin Cities
College of Veterinary Medicine
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
