******* HOW IS 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_Location_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_footprints#")
/>
<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_footprints#")
/>
<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_footprints#")
/>
<cfset
R_Consumer_Data_Element_Answer_Record.SETCREATE_DTM("#arguments.CREATE_DTM#")
/>
<cfset
R_Consumer_Data_Element_Answer_Record.SETANSWER_TEXT("#trim(arguments.LAST_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 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_footprints#")
/>
<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/
