Just a quick question in relation to the CFQueryParam - where are you advising
that I use this command.
Thanks in advance for your reply.
> I have a piece of code in a program which I think would be much better
> if placed into a CFC.
>
>
> Just wondering what is the best approach to take.
>
> Want to be able to handle success and fail transactions.
>
> The code that I am looking at is shown below.
>
> Regards
>
> T
>
>
>
>
>
>
> <cfparam name="selemailopt" default="">
> <cfif isDefined("form.MailList") AND form.MailList NEQ "">
> <cfset selemailopt = 'I'>
> <cfelse>
> <cfset selemailopt = 'O'>
> </cfif>
>
> <!--- Assumptions
>
> Mobile - is empty as this data is not collected
> Title - is empty as this data is not collected
> Active - is set to False until such time as the user
> has been
> approved
> 2696812 - is set to NSW by default although it could be
> set to
> #trim(form.state)#
>
> --->
>
>
> <cfset CustParams = "FIRSTNAME|" &
> "#trim(form.FirstName)#" &
> CHR(31)
> & "LASTNAME|" & "#trim(form.LastName)#" & CHR(31)
> & "EMAIL|" & "#trim(form.Email)#" & CHR(31)
> & "MOBILE|" & "" & CHR(31)
> & "TITLE|" & "" & CHR(31)
> & "EMAILOPT|" & "#selemailopt#" & CHR(31)
> & "ACTIVE|" & "F" & CHR(31)
> & "PASSWORD|" & "#trim(form.password)#" & CHR(31)
> & "2969822|" & "#trim(form.country)#" &
> CHR(31)
> & "2969812|" & "#trim(form.state)#" & CHR(31)
> & "2969824|" & "#trim(form.gender)#" &
> CHR(31)
> & "2969828|" & "#trim(form.UserAge)#" &
> CHR(31)
> & "2969811|" & "#trim(form.fldPostLookup)#" &
> CHR(31)
> & "2969823|" & "#trim(form.postCode)#" &
> CHR(31)
> & "2969830|" & "#trim(form.fldPostLookup2)#"
> & CHR(31)
> & "2969831|" & "#trim(form.postCode2)#" &
> CHR(31)>
>
> <!--- <cfdump var="#form#">
> <cfdump var="#CustParams#">
> <cfabort> --->
>
> <!--- Additional code to add new community member details to traction
> --->
>
> <cfhttp method="post" url="http://au.api.tractionplatform.
> com/ext/AddCustomer" result="myTest">
> <cfhttpparam name="USERID" type="formfield" value="street1231">
> <cfhttpparam name="PASSWORD" type="formfield" value="asdh4523">
> <cfhttpparam name="ENDPOINTID" type="formfield" value="6906">
> <cfhttpparam name="MATCHKEY" type="formfield" value="E">
> <cfhttpparam name="MATCHVALUE" type="formfield" value="#form.Email#">
> <cfhttpparam name="CUSTOMER" type="formfield" value="#CustParams#">
>
> </cfhttp>
>
> <!--- Get the return ResultCode (Trac-Result) --->
>
> <cfparam name="return_trac_result" default="">
> <cfset return_trac_result = #myTest.Responseheader['TRAC-Result']#>
>
> <CFQUERY DATASOURCE="#request.AppDS#">
> INSERT INTO SC_Trac_Results
> (TR_ResultCode,
> TR_CustParams,
> TR_Date)
> VALUES
> (#return_trac_result#,
> '#CustParams#',
> '#trim(form.CreateDate)#')
> </CFQUERY>
>
>
> <CFQUERY DATASOURCE="#request.AppDS#">
> INSERT INTO SC_Metro_Users
> (FirstName,
> LastName,
> suburbID,
> Email,
> <!---PhoneNumber, --->
> city,
> ZipCode,
> country,
> gender,
> UserAge,
> Login,
> Password,
> signature,
> backnews,
> mailList,
> ThirdEmail,
> TOS,
> BizLogin,
> BizNews,
> Staff,
> CreateDate,
> FirstLogin,
> HasPosted)
> VALUES
> ('#trim(form.FirstName)#',
> '#trim(form.LastName)#',
> '#trim(request.suburbID)#',
> '#trim(form.Email)#',
> <!---'#trim(form.PhoneNumber1)#-#trim(form.PhoneNumber2)#-#trim(form.
> PhoneNumber3)#', --->
> '#trim(form.fldPostLookup)#',
> '#trim(form.postCode)#',
> '#trim(form.country)#',
> '#trim(form.gender)#',
> '#trim(form.UserAge)#',
> '#trim(form.Login)#',
> '#trim(form.Password)#',
> '#trim(form.signature)#',
> '0',<!---<cfif isDefined("form.backnews") AND form.backnews NEQ
> "">'#trim(form.backnews)#',<cfelse>'0',</cfif> --->
> <cfif isDefined("form.MailList") AND form.MailList NEQ "">'#trim(form.
> mailList)#',<cfelse>'0',</cfif>
> <cfif isDefined("form.ThirdEmail") AND form.ThirdEmail NEQ
> "">'#trim(form.ThirdEmail)#',<cfelse>'0',</cfif>
> <cfif isDefined("form.TOS") AND form.TOS NEQ "">'#trim(form.TOS)#',
> <cfelse>'0',</cfif>
> '0',
> '0',
> '0',
> '#trim(form.CreateDate)#',
> '#trim(form.FirstLogin)#',
> '0')
> </CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314832
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
