On 4/19/06, Doug Hughes
<[EMAIL PROTECTED]> wrote:
You essentially can't. Sorry.
Doug
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf
Of Daryl
Sent: Wednesday, April 19, 2006 7:35 PM
To: [email protected]
Subject: Re: [Reactor For CF] Fwd: MYSQL4L cftransactions around multiple
reactor inserts/updates/queries?
Hey Doug, I removed the CFTRANSACTION tags from the dao.project.xsl
file that generates the dao objects in the projects/dao folder. (i
also removed the cftransaction tags from any already created DAO
cfcs.) I then wrapped the reactor calls i need to be part
of a transaction in CFTRANSACTION tags. Will this cause a performance
hit/system crash? it seems to be...
the basic problem i'm trying to solve is how to wrap multiple reactor
calls in CFTRANSACTION tags--esp when one of the reactor calls is an
insert that returns an ID
CFMX 6.1, so nested transaction tags aren't available,
-Daryl
On 4/19/06, Doug Hughes <[EMAIL PROTECTED]> wrote:
> Daryl -
>
> No need to yell. :)
>
> No need to send this two of sean's emails, especially seeing as he's on
this
> list.
>
> Doug
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf
> Of Daryl
> Sent: Wednesday, April 19, 2006 7:11 PM
> To: [email protected]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: [Reactor For CF] Fwd: MYSQL4L cftransactions around multiple
> reactor inserts/updates/queries?
>
> ******* HOW IS (or can it be?) THIS DONE IN REACTOR? i.e, nested
> cftransaction tags?
> >>>>><cftransaction>
>
> <!--- create the reactorFactory --->
> <cfset Reactor = CreateObject("Component",
> "reactor.reactorFactory").init("/var/www/html/reactor/reactor.xml") />
>
> <!--- create a Record --->
> <cfset Consumers_Record =
> Reactor.createRecord("Consumers") />
>
> <!--- populate the new record --->
> <cfset
> Consumers_Record.SETCREATE_DTM("#arguments.CREATE_DTM#") />
>
> <!--- save the record --->
> <cfset Consumers_Record.save() />
>
> <!--- create local var --->
> <Cfset inserted_id_consumer =
> Consumers_Record.GETCONSUMER_ID()>
>
>
> <!--- create a Gateway --->
> <cfset Data_Elements_Gateway =
> reactor.createGateway("R_Event_Location_Activity_Type") />
>
> <!--- set where vars --->
> <cfset qData_Elements =
>
Data_Elements_Gateway.getByFields(Event_Location_ID=#Get_EL_ID.Event_Locatio
> n_ID#,ACTIVITY_TYPE_ID=17)/>
>
> <!--- create local var --->
> <cfset EMAIL_SEND_R_ELAT_ID =
> #qData_Elements.R_ELAT_ID#>
>
>
>
> <!--- create a record --->
> <cfset Footprints_Record =
> Reactor.createRecord("Footprints") />
>
> <!--- populate the new record --->
> <cfset
> Footprints_Record.SETEVENT_TOKEN_ID("#arguments.BARCODE_ID#")>
> <cfset
> Footprints_Record.SETR_ELAT_ID("#EMAIL_SEND_R_ELAT_ID#") />
> <cfset
> Footprints_Record.SETEVENT_DAY_ID("#arguments.SUB_EVENT_DATE_ID#") />
> <cfset
> Footprints_Record.SETCLIENT_LICENSE_ID("#efn_client_licenseID#") />
> <cfset
> Footprints_Record.SETSYSTEM_ID("#arguments.CAMERA_ID#")>
> <cfset
> Footprints_Record.SETCREATE_DTM("#arguments.CREATE_DTM#") />
> <cfset Footprints_Record.SETSAMPLE_FLAG("0")>
> <cfset Footprints_Record.SETIP_ADDRESS("")>
>
> <!--- save the record --->
> <cfset Footprints_Record.save() />
>
>
> <!--- create a record --->
> <cfset R_Consumer_Event_Token_Record =
> Reactor.createRecord("R_Consumer_Event_Token") />
>
> <!--- populate the new record --->
> <cfset
> R_Consumer_Event_Token_Record.SETCREATE_DTM("#arguments.CREATE_DTM#")
> />
> <cfset
> R_Consumer_Event_Token_Record.SETCONSUMER_ID("#inserted_id_consumer#")
> />
> <cfset
> R_Consumer_Event_Token_Record.SETEVENT_TOKEN_ID("#arguments.BARCODE_ID#")>
>
> <!--- save the record --->
> <cfset R_Consumer_Event_Token_Record.save() />
>
> <!--- create local var --->
> <Cfset inserted_id_rcetr =
> R_Consumer_Event_Token_Record.GETEVENT_TOKEN_ID()>
>
> <!--- create a Gateway --->
> <cfset Data_Elements_Gateway =
> reactor.createGateway("R_Event_Location_Activity_Type") />
>
> <!--- set where vars --->
> <cfset qData_Elements =
>
Data_Elements_Gateway.getByFields(Event_Location_ID=#efn_event_location_id#,
> ACTIVITY_TYPE_ID=2)
> />
>
> <!--- create local var --->
> <cfset LDC_R_ELAT_ID = #qData_Elements.R_ELAT_ID#>
>
>
> <!--- create a record --->
> <cfset Footprints_Record =
> Reactor.createRecord("Footprints") />
>
> <!--- populate the new record --->
> <cfset
> Footprints_Record.SETEVENT_TOKEN_ID("#arguments.BARCODE_ID#")>
> <cfset
> Footprints_Record.SETR_ELAT_ID("#LDC_R_ELAT_ID#") />
> <cfset
> Footprints_Record.SETEVENT_DAY_ID("#arguments.SUB_EVENT_DATE_ID#") />
> <cfset
> Footprints_Record.SETCLIENT_LICENSE_ID("#efn_client_licenseID#") />
> <cfset
> Footprints_Record.SETSYSTEM_ID("#arguments.CAMERA_ID#")>
> <cfset
> Footprints_Record.SETCREATE_DTM("#arguments.CREATE_DTM#") />
> <cfset Footprints_Record.SETSAMPLE_FLAG("0")>
> <cfset Footprints_Record.SETIP_ADDRESS("")>
>
> <!--- save the record --->
> <cfset Footprints_Record.save() />
>
> <!--- create local var --->
> <Cfset inserted_id_footprints =
> Footprints_Record.GETFOOTPRINT_ID()>
>
>
> <Cfif email_write eq 1>
> <!--- EMAIL --->
> <!--- create a record --->
> <cfset
R_Consumer_Data_Element_Answer_Record
> =
> Reactor.createRecord("R_Consumer_Data_Element_Answer") />
>
> <!--- populate the new record --->
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETCONSUMER_ID("#inserted_id_consumer#
> ")>
> <cfset
> R_Consumer_Data_Element_Answer_Record.SETDATA_ELEMENT_ID("4") />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETFOOTPRINT_ID("#inserted_id_footprin
> ts#")
> />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETCREATE_DTM("#arguments.CREATE_DTM#"
> )
> />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETANSWER_TEXT("#trim( arguments.EMAIL)
> #")>
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETANSWER_DATE("#arguments.CREATE_DTM#
> ")>
>
> <!--- save the record --->
> <cfset
> R_Consumer_Data_Element_Answer_Record.save() />
> </Cfif>
>
> <Cfif first_name_write eq 1>
>
> <!--- FIRST_NAME --->
> <!--- create a record --->
> <cfset
R_Consumer_Data_Element_Answer_Record
> =
> Reactor.createRecord("R_Consumer_Data_Element_Answer") />
>
> <!--- populate the new record --->
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETCONSUMER_ID("#inserted_id_consumer#
> ")>
> <cfset
> R_Consumer_Data_Element_Answer_Record.SETDATA_ELEMENT_ID("6") />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETFOOTPRINT_ID("#inserted_id_footprin
> ts#")
> />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETCREATE_DTM("#arguments.CREATE_DTM#"
> )
> />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETANSWER_TEXT("#trim( arguments.FIRST_
> NAME)#")>
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETANSWER_DATE("#arguments.CREATE_DTM#
> ")>
>
> <!--- save the record --->
> <cfset
> R_Consumer_Data_Element_Answer_Record.save() />
> </Cfif>
> <Cfif last_name_write eq 1>
>
> <!--- LAST_NAME --->
> <!--- create a record --->
> <cfset
R_Consumer_Data_Element_Answer_Record
> =
> Reactor.createRecord("R_Consumer_Data_Element_Answer") />
>
> <!--- populate the new record --->
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETCONSUMER_ID("#inserted_id_consumer#
> ")>
> <cfset
> R_Consumer_Data_Element_Answer_Record.SETDATA_ELEMENT_ID("7") />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETFOOTPRINT_ID("#inserted_id_footprin
> ts#")
> />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETCREATE_DTM("#arguments.CREATE_DTM#"
> )
> />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETANSWER_TEXT("#trim( arguments.LAST_N
> AME)#")>
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETANSWER_DATE("#arguments.CREATE_DTM#
> ")>
>
> <!--- save the record --->
> <cfset
> R_Consumer_Data_Element_Answer_Record.save() />
> </Cfif>
> <Cfif optin_write eq 1>
>
> <cfif arguments.optin is 1>
> <Cfset this_optin = 194>
> <cfelse>
> <Cfset this_optin = 195>
> </cfif>
>
> <!--- OPTIN --->
> <!--- create a record --->
> <cfset
R_Consumer_Data_Element_Answer_Record
> =
> Reactor.createRecord("R_Consumer_Data_Element_Answer") />
>
> <!--- populate the new record --->
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETCONSUMER_ID("#inserted_id_consumer#
> ")>
> <cfset
> R_Consumer_Data_Element_Answer_Record.SETDATA_ELEMENT_ID("35") />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETFOOTPRINT_ID("#inserted_id_footprin
> ts#")
> />
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETCREATE_DTM("#arguments.CREATE_DTM#"
> )
> />
> <cfset
> R_Consumer_Data_Element_Answer_Record.SETANSWER_ID("#this_OPTIN#")>
> <cfset
>
R_Consumer_Data_Element_Answer_Record.SETANSWER_DATE("#arguments.CREATE_DTM#
> ")>
>
> <!--- save the record --->
> <cfset
> R_Consumer_Data_Element_Answer_Record.save() />
> </cfif>
> ******* HOW IS THIS DONE IN REACOTOR? i.e, nested cftransaction tags?
> >>>>> </cftransaction>
>
>
>
> -- Reactor for ColdFusion Mailing List -- [email protected]
> -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
>
>
>
>
>
> -- Reactor for ColdFusion Mailing List -- [email protected]
> -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
>
>
>
-- Reactor for ColdFusion Mailing List -- [email protected]
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
-- Reactor for ColdFusion Mailing List -- [email protected]
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
