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/
