IPN and payment conflict- please help......

radiance · Feb 11, 2004

Hi.
Could someone please advise...IPN and Quantity. Thanks in advance.

I have continued to troubleshoot my registration form in which users's rate depends on the time that they register. I am now down to 3 forms: form, confirm and ipn.cfm!

http://bnaibrith.org/members/convention/test.cfm

How do I resolve payment and quantity with Paypal? For example, if a user signs up alone before the registration deadline, their fee is $100. And if they have guests who will be registered as registrants, then it is $100* guests + the original registrant. Now, if the user signs up only after the registration deadline, their fee is $200. And if they have guests who will be registered as registrants, then it is $200* guests + the original registrant

I am getting the following error:

Error Diagnostic Information

An error occurred while evaluating the expression:

#DOLLARFORMAT(total_payment)#

Error near line 228, column 25.
--------------------------------------------------------------------------------

Error resolving parameter TOTAL_PAYMENT

ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either:

You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag.

The error occurred while processing an element with a general identifier of (#DOLLARFORMAT(total_payment)#), occupying document position (228:24) to (228:52).

______________________________________________________________________

Here is my code for ipn and subsequently, confirm.cfm. I have a form page too, but I am not sure if that is necessary:

CONFIRM.cfm
<---Header--->
!---GET FORM ELEMENTS--->

<cfparam name="FORM.convention_date" type="string" default="">
<cfset #convention_date# = FORM.convention_date>

<cfparam name="FORM.registration_date" type="string" default="">
<cfset #registration_date# = FORM.registration_date>

<cfparam name="FORM.title" type="string" default="">
<cfset #title# = FORM.title>

<cfparam name="FORM.fname" type="string" default="">
<cfset #fname# = FORM.fname>

<cfparam name="FORM.mi" type="string" default="">
<cfset #mi# = FORM.mi>

<cfparam name="FORM.lname" type="string" default="">
<cfset #lname# = FORM.lname>

<cfparam name="FORM.nickname" type="string" default="">
<cfset #nickname# = FORM.nickname>

<cfparam name="FORM.suffix" type="string" default="">
<cfset #suffix# = FORM.suffix>

<cfparam name="FORM.email" type="string" default="">
<cfset #email# = FORM.email>

<cfparam name="FORM.stno" type="string" default="">
<cfset #stno# = FORM.stno>

<cfparam name="FORM.stno2" type="string" default="">
<cfset #stno2# = FORM.stno2>

<cfparam name="FORM.city" type="string" default="">
<cfset #city# = FORM.city>

<cfparam name="FORM.state" type="string" default="">
<cfset #state# = FORM.state>

<cfparam name="FORM.zip" type="string" default="">
<cfset #zip# = FORM.zip>

<cfparam name="FORM.country" type="string" default="">
<cfset #country# = FORM.country>

<cfparam name="FORM.hphone" type="string" default="">
<cfset #hphone# = FORM.hphone>

<cfparam name="FORM.wphone" type="string" default="">
<cfset #wphone# = FORM.wphone>

<cfparam name="FORM.fax" type="string" default="">
<cfset #fax# = FORM.fax>

<cfparam name="FORM.emercontact" type="string" default="">
<cfset #emercontact# = FORM.emercontact>

<cfparam name="FORM.ephone" type="string" default="">
<cfset #edphone# = FORM.edphone>

<cfparam name="FORM.eephone" type="string" default="">
<cfset #eephone# = FORM.eephone>

<cfparam name="FORM.region" type="string" default="">
<cfset #region# = FORM.region>

<cfparam name="FORM.district" type="string" default="">
<cfset #district# = FORM.district>

<cfparam name="FORM.lodgeno" type="string" default="">
<cfset #lodgeno# = FORM.lodgeno>

<cfparam name="FORM.lodgename" type="string" default="">
<cfset #lodgename# = FORM.lodgename>

<cfparam name="FORM.committee" type="string" default="">
<cfset #committee# = FORM.committee>

<cfparam name="FORM.lodge_pres" type="string" default="">
<cfset #lodge_pres# = FORM.lodge_pres>

<cfparam name="FORM.registration_type" type="string" default="">
<cfset #registration_type# = FORM.registration_type>

<cfparam name="FORM.gfullname" type="string" default="">
<cfset #gfullname# = FORM.gfullname>

<cfparam name="FORM.gcity" type="string" default="">
<cfset #gcity# = FORM.gcity>

<cfparam name="FORM.gstate" type="string" default="">
<cfset #gstate# = FORM.gstate>

<cfparam name="FORM.gcountry" type="string" default="">
<cfset #gcountry# = FORM.gcountry>

<cfparam name="FORM.guestsallmeals" type="string" default="">
<cfset #guestsallmeals# = FORM.guestsallmeals>

<cfparam name="FORM.guestsno" type="string" default="">
<cfset #guestsno# = FORM.guestsno>



<table cellpadding="2" cellspacing="2" border="0"><tr><td class="text">
<span class="boldtext">Please check the information below and confirm. You will then be taken to <b>PayPal</b> to make a donation.</span>
</td></tr>
<td>
<cfoutput>
<table>
<tr>
<TR>
<TD class="boldtext">
Convention: <span class="text">#convention_date#</span><br><br>

1Registration Status: <span class="text">#registantStatus#</span><br><br>

Prefix: <span class="text">#title#</span><br><br>

First Name: <span class="text">#fname#</span><br><br>

MI:<span class="text">#mi#</span><br><br>

Last Name: <span class="text">#lname#</span><br><br>

Suffix: <span class="text">#suffix#</span><br><br>

Nickname: <span class="text">#nickname#</span><br><br>

Email:<span class="text">#email#</span><br><br>

Address:<span class="text">#stno#</span><br><br>

Apt.<span class="text">#stno2#</span><br><br>

City:<span class="text">#city#</span><br><br>

State/Province:<span class="text">#state#</span><br><br>

Zip/Postal Code:<span class="text">#zip#</span><br><br>

Country:<span class="text">#country#</span>
<br><br>

<span class="boldtext">Daytime Phone</span> (incl. area code):<span class="text">#hphone#</span><br><br>

<span class="boldtext">Evening Phone</span> (incl. area code):<span class="text">#wphone#</span><br><br>

<span class="boldtext">Fax</span> (incl. area code):<span class="text">#fax#</span><br><br>

Emergency Contact:<span class="text">#emercontact#</span><br><br>

<span class="boldtext">Emergency Daytime Phone </span>(incl. area code):
<span class="text">#edphone#</span><br><br>

<span class="boldtext">Emergency Evening Phone</span>(incl. area code):<span class="text">#eephone#</span>
<br><br>



<span class="boldtext">Select a Region</span> (for all members in USA or British Columbia):<span class="text">#region#</span><br><br>

<span class="boldtext">District</span>(Overseas members only):<span class="text">#district#</span><br><br>

Unit/Lodge Number:<span class="text">#lodgeno#</span><br><br>

<span class="boldtext">Unit/Lodge Name</span>(Required for delgates and alternates representing Units & Lodges):<span class="text">#lodgename#</span><br><br>

<span class="boldtext">Are you interested in serving on a Convention Buisness Committee, and if so will you be available to attend a meeting on Sunday June 27th?</span><br><span class="text">#committee#</span><br><br>

<span class="boldtext">Will you be a Unit/Lodge President when the convention takes place?</span><br><span class="text">#lodge_pres#</span><br><br>

Registration Type:<span class="text">#registration_type#</span><br><br>

Will you have guests?<span class="text">#registantStatus#</span><br><br>

How many guests will you have?<span class="text">#guestsno#</span><br><br>

Do you want to register your guests for all sessions, events, and meals?<br>
<span class="text">#guestsallmeals#</span><br><br>

Guest 1 Full Name: <span class="text">#gfullname#</span><br><br>

Guests 1's city:<span class="text">#gcity#</span><br><br>

State:<span class="text">#gstate#</span><br><br>

Country:<span class="text">#gcountry#</span><br><br>
</td>
</tr></table>


<cfif #registantStatus# IS "Registrant Only" AND #registration_date# LT "05/28/04">
<cfset #registrationAmount#="295.00">
</cfif>
<tr><td class"text">
<span class="text">
<b>The following fees are required for your registration:</b><br><br>
Registration Fees: <b>#DOLLARFORMAT(registrationAmount)#</b>
</span></td></tr>

<cfif isDefined("URL.calculate&quot

>
<cfif #URL.calculate# is "yes">

<form action="conv04_reg_form.cfm" method="post">
<input type="hidden" name="mode" value="edit">
<input type="submit" value="Go Back & Edit">
</form>

<form action="

https://www.paypal.com/cgi-bin/webscr"

method="post">
<input type="hidden" name="item_name" value="Convention Registration">
<input type="hidden" name="cmd" value="_ext-enter">
<input type="hidden" name="redirect_cmd" value="_xclick">
<input type="hidden" name="business" value="website@bnaibrith.org">
<input type="hidden" name="item_number" value="#session.total_registrants#">
<input type="hidden" name="first_name" value="#SESSION.fname#">
<input type="hidden" name="amount" value="#SESSION.registrationAmount#">
<input type="hidden" name="last_name" value="#SESSION.lname#">
<input type="hidden" name="address1" value="#SESSION.stno#">
<input type="hidden" name="address2" value="#SESSION.stno2#">
<input type="hidden" name="city" value="#SESSION.city#">
<input type="hidden" name="state" value="#SESSION.state#">
<input type="hidden" name="zip" value="#SESSION.zip#">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="no_shipping" value="0">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="tax" value="0">
<input type="hidden" name="return" value="

http://216.119.115.20/members/convention/success.cfm">

<input type="hidden" name="notify_url" value="

http://216.119.115.20/members/convention/ipn.cfm">

<input type="submit" value="Confirm">
</form>
</cfif>
</cfif>
</cfoutput>




<cfif #registantStatus# IS "Registrant with Guests" AND #registration_date# GT "05/28/04">
<cfset #registrationAmount#= "325.00">
<cfif isDefined("Form.registrant&quot

>
<cfoutput>
<cfif #guests# IS 'Yes' AND #guestsallmeals# IS 'Yes'>
<cfset #total_registrants# = #guestsno# + 1>
<cfset #registrationAmount# =325 * #total_registrants#>
</cfif>
</cfoutput>
</cfif>
<cfoutput>
<tr><td class"text">
<span class="text">
<b>The following fees are required for your registration:</b>
Registered on: #DateFormat(registration_date, 'mm/dd/yyyy')#</<br><br>
Registration Fees: <b>#DOLLARFORMAT(total_payment)#</b>
</span></td></tr>

<form action="conv04_reg_form.cfm" method="post">
<input type="hidden" name="mode" value="edit">
<input type="submit" value="Go Back & Edit">
</form>
<cfif isDefined("URL.calculate&quot

>
<cfif #URL.calculate# is "yes">
<form action="

https://www.paypal.com/cgi-bin/webscr"

method="post">
<input type="hidden" name="item_name" value="Convention Registration">
<input type="hidden" name="cmd" value="_ext-enter">
<input type="hidden" name="redirect_cmd" value="_xclick">
<input type="hidden" name="business" value="website@bnaibrith.org">
<input type="hidden" name="item_number" value="#session.total_registrants#">
<input type="hidden" name="first_name" value="#SESSION.fname#">
<input type="hidden" name="amount" value="#SESSION.registrationAmount#">
<input type="hidden" name="last_name" value="#SESSION.lname#">
<input type="hidden" name="address1" value="#SESSION.stno#">
<input type="hidden" name="address2" value="#SESSION.stno2#">
<input type="hidden" name="city" value="#SESSION.city#">
<input type="hidden" name="state" value="#SESSION.state#">
<input type="hidden" name="zip" value="#SESSION.zip#">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="no_shipping" value="0">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="tax" value="0">
<input type="hidden" name="return" value="

http://216.119.115.20/members/convention/success.cfm">

<input type="hidden" name="notify_url" value="

http://216.119.115.20/members/convention/ipn.cfm">

<input type="submit" value="Confirm">
</form>
</cfif>
</cfif>
</cfoutput>
</cfif>
<---Footer--->

_________________________________________________________________
IPN.cfm


<CFSET str="cmd=_notify-validate">
<CFLOOP INDEX="TheField" list="#Form.FieldNames#">
<CFSET str = str & "#LCase(TheField)#=#URLEncodedFormat(Evaluate(TheField))#">
</CFLOOP>
<CFIF IsDefined("FORM.payment_date&quot

>
<CFSET str = str & "&payment_date=#URLEncodedFormat(Form.payment_date)#">
</CFIF>
<CFIF IsDefined("FORM.subscr_date&quot

>
<CFSET str = str & "&subscr_date=#URLEncodedFormat(Form.subscr_date)#">
</CFIF>


<CFHTTP URL="

https://www.paypal.com/cgi-bin/webscr?#str#"

METHOD="GET" RESOLVEURL="false">
</CFHTTP>


<cfoutput>
<cfset #receiver_email#=#FORM.receiver_email#>
<cfset #payment_status#=#FORM.payment_status#>
<cfset #payment_currency#=#FORM.mc_currency#>
<cfset #txn_id#=#FORM.txn_id#>
<cfset #convention_program# = #FORM.item_name#>
<cfset #total_registrants# = #FORM.item_number#>
<cfset #registration_amount# = #FORM.mc_gross#>
<cfset #fname# = #FORM.first_name#>
<cfset #lname# = #FORM.last_name#>
<cfset #stno1# = #FORM.address_street#>
<cfset #city# = #FORM.address_city#>
<cfset #state# = #FORM.address_state#>
<cfset #zip# = #FORM.address_zip#>
<cfset #email# = #FORM.email#>
</cfoutput>

<cfoutput>
Variables:
#total_registrants# , #registration_amount#, #convention_program#, #fname#<br/>
</cfoutput>


<CFIF #CFHTTP.FileContent# is "VERIFIED">

<cfif FORM.payment_status eq "Completed">

<cfif #FORM.RECEIVER_EMAIL# eq "mypaypalemail@mysite.com">

<cftry>

<cfquery name="registrant" datasource="bbitestdb">
SELECT * FROM bog_registrant
WHERE
Email = '#email#'
</cfquery>

<cfif registrant.RecordCount NEQ 0>
<cfset #registantStatus# = "registrant only">
<cfelse>
<cfset #registantStatus# = "registrant with guests">
</cfif>

<cfif #registantStatus# is "registrant only">
<cfquery name="FindCustomer" datasource="bbitestdb">
SELECT * FROM Customers
WHERE email = '#email#'
</cfquery>

<cfif FindCustomer.RecordCount NEQ 0>
<cfset registrantID = #FindCustomer.CustomerId#>
</cfif>

<cfif FindCustomer.RecordCount EQ 0>
<cfquery name="InsertCustomer" datasource="bbitestdb">
INSERT INTO Customers
(
fname, lname, stno, city, state, zip, email, IsBOGRegistrant, DateAdded
)
Values
(
'#fname#', '#lname#', '#stno1#', '#city#', '#state#', '#zip#', '#email#', 'y', GETDATE() )
</cfquery>

<cfquery name="FindCustomer" datasource="bbitestdb">
SELECT * FROM Customers
WHERE email = '#email#'
</cfquery>

<cfset registrantID = #FindCustomer.CustomerId#>

<cfelse>

<cfquery name="UpdateCustomer" datasource="bbitestdb">
UPDATE Customers
SET
IsBOGRegistrant = 'y'
WHERE CustomerId = '#registrantID#'
</cfquery>

</cfif>
</cfif>

<cfif #registantStatus# is "registrant with guests">
<cfoutput><br/>RegistrantID: #registrant.RegistrantID#<br/>
Last Name: #registrant.lname#<br/></cfoutput>

<cfquery name="UpdateRegistrant" datasource="bbitestdb">
UPDATE Customers
SET
IsBOGRegistrant = 'y'
WHERE
email = '#email#'
</cfquery>

<cfquery name="UpdateGuest" datasource="bbitestdb">
UPDATE bog_guests
SET
gfullname = <cfqueryparam value="#form.keyword#">,
gcity = <cfqueryparam value="#form.keyword#">,
gstate = <cfqueryparam value="#form.keyword#">,
gcountry = <cfqueryparam value="#form.keyword#">,
registrantID= <cfqueryparam value=#form.registrantID#>
WHERE
registrantID = #Form.registrantID#
</cfquery>

<cfoutput>
<cfset #registantStatus# = #registrant.RegistrantID#>
</cfoutput>

</cfif>

<cfoutput>
<cfquery name="InsertPayment" datasource="bbitestdb">
INSERT INTO customerPayments
(
CustomerId, txnId, lname, conventionType, registrationAmount, datePaid
)
Values
(
'#customerID#', '#txn_id#', '#lname#', '#registantStatus#', '#registration_amount#', GETDATE()
)
</cfquery>

<cfquery name="InsertRegistrantInfo" datasource="bbitestdb">
INSERT INTO bog_registrants
(
convention_date, conventionType, title, fname, mi, lname, suffix, nickname, email, stno, stno2, city, state, zip, country, hphone, wphone, fax, emercontact, edphone, eephone, region, district, lodgeno, lodgename, lodge_pres, committee, registration_type, total_registrants, registration_date, registantStatus,
)
Values
(
'#convention_date#', '#conventionType#', '#title#', '#fname#', '#mi#', '#lname#', '#suffix#', '#nickname#', '#email#', '#stno#', '#stno2#', '#city#', '#state#', '#zip#', '#country#', '#hphone#', '#wphone#', '#fax#', '#emercontact#', '#edphone#','#eephone#','#region#','#district#','#lodgeno#','#lodgename#', '#lodge_pres#', '#committee#', '#registration_type#', '#total_registrants#', GETDATE(),'#registantStatus#',
)
</cfquery>
</cfoutput>

<cfcatch>

<cffile action="append"
file="D:\WEB\bnaibrith\paypal\paypal_log.txt"
output="Error order info & after written to DB">
</cfcatch>
</cftry>

</cfif>
</cfif>

<CFELSEIF #CFHTTP.FileContent# is "INVALID">


Something that was purchased was invalid, either the order or the information provided. This is usually good to log in case someone is trying to purchase with stolen card numbers, etc. Here simply place a QUERY tag that insert the data above into a database.

<CFELSE>


This usually means that something went wrong along the way, you can use this area to log it and keep for your records.

</CFIF>

Laughter cures so much and it is easier than a frown... Go ahead try it...

ecobb · Feb 11, 2004

Ok, to start with, you DO NOT put pound signs around the name of a variable when you are assigning. You only use pounds for output.
So

Code:

<cfset #convention_date# = FORM.convention_date>[/color]

should be

Code:

<cfset convention_date = FORM.convention_date>[/color]

and you will need to make this change on EVERY ONE of your cfset statements.

Secondly, I can't find anywhere in your code that you are setting/defining the "total_payment" variable. That's why you're getting that error, because the variable doesn't exist. Most likely, you just left out a cfset statement like:

Code:

<cfset total_payment = FORM.total_payment>[/color]

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

radiance · Feb 11, 2004

Thank you Ecobb for your help!!!!

What about my computation to figure out the total price. Is this even the right way to approach this:




<cfif #registantStatus# IS "Registrant with Guests" AND #registration_date# GT "05/28/04">
<cfset #registrationAmount#= "325.00">
<cfif isDefined("Form.registrant&quot

>
<cfoutput>
<cfif #guests# IS 'Yes' AND #guestsallmeals# IS 'Yes'>
<cfset #total_registrants# = #guestsno# + 1>
<cfset #registrationAmount# =325 * #total_registrants#>
</cfif>
</cfoutput>
</cfif>
<cfoutput>
<tr><td class"text">
<span class="text">
<b>The following fees are required for your registration:</b>
Registered on: #DateFormat(registration_date, 'mm/dd/yyyy')#</<br><br>
Registration Fees: <b>#DOLLARFORMAT(total_payment)#</b>
</span></td></tr>

radiance · Feb 11, 2004

I am not sure where to post total_payment, because it is a result of when it has been established that the registrant is ontime and single;, or on-time with guests, or late single registrant; and late and with guests.

Am I defining it earlier??

ecobb · Feb 11, 2004

Looks good except for the punds around your variables names in the cfset and cfif statements. You only use pounds aroud a variable when you are referencing or displaying the value of that variable, not the name.

Code:

<cfif registantStatus IS &quot;Registrant with Guests&quot; AND registration_date GT &quot;05/28/04&quot;>
<cfset registrationAmount = &quot;325.00&quot;>
<cfif isDefined(&quot;Form.registrant&quot;)>
<cfoutput>
<cfif guests IS 'Yes' AND guestsallmeals IS 'Yes'>
<cfset total_registrants = (#guestsno# + 1)>
<cfset registrationAmount = (325 * #total_registrants#)>
</cfif>
</cfoutput>
</cfif>
<cfoutput>

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

radiance · Feb 11, 2004

Thank you again for your patience!!!

I took out the pound signs for the variables and the output is going to the confirm page, but I don't see my buttons to make changes or to continue. Is there something I am missing?

http://bnaibrith.org/members/convention/test.cfm

Thanks in advance!

ecobb · Feb 11, 2004

I looks like this tag <cfif registantStatus IS "Registrant with Guests" AND registration_date GT "05/28/04"> is surrounding both the buttons (and forms). If the values you are passing in the form do not equal the values the IF statement is looking for, the buttons will not show up.

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

radiance · Feb 11, 2004

Thank you. I will look into my code more and let you know if it works!

Thanks so much!!

radiance · Feb 12, 2004

The buttons are showing up, but only the go back and edit. My totals are still not showing. Please advise (I am going to review this evening. This is my confirm.cfm page.



<cfparam name="FORM.convention_date" type="string" default="">
<cfset convention_date = FORM.convention_date>

<cfparam name="FORM.registration_date" type="string" default="">
<cfset registration_date = FORM.registration_date>

<cfparam name="FORM.title" type="string" default="">
<cfset title = FORM.title>

<cfparam name="FORM.fname" type="string" default="">
<cfset fname = FORM.fname>

<cfparam name="FORM.mi" type="string" default="">
<cfset mi = FORM.mi>

<cfparam name="FORM.lname" type="string" default="">
<cfset lname = FORM.lname>

<cfparam name="FORM.nickname" type="string" default="">
<cfset nickname = FORM.nickname>

<cfparam name="FORM.suffix" type="string" default="">
<cfset suffix = FORM.suffix>

<cfparam name="FORM.email" type="string" default="">
<cfset email = FORM.email>

<cfparam name="FORM.stno" type="string" default="">
<cfset stno = FORM.stno>

<cfparam name="FORM.stno2" type="string" default="">
<cfset stno2 = FORM.stno2>

<cfparam name="FORM.city" type="string" default="">
<cfset city = FORM.city>

<cfparam name="FORM.state" type="string" default="">
<cfset state = FORM.state>

<cfparam name="FORM.zip" type="string" default="">
<cfset zip = FORM.zip>

<cfparam name="FORM.country" type="string" default="">
<cfset country = FORM.country>

<cfparam name="FORM.hphone" type="string" default="">
<cfset hphone = FORM.hphone>

<cfparam name="FORM.wphone" type="string" default="">
<cfset wphone = FORM.wphone>

<cfparam name="FORM.fax" type="string" default="">
<cfset fax = FORM.fax>

<cfparam name="FORM.emercontact" type="string" default="">
<cfset emercontact = FORM.emercontact>

<cfparam name="FORM.ephone" type="string" default="">
<cfset edphone = FORM.edphone>

<cfparam name="FORM.eephone" type="string" default="">
<cfset eephone = FORM.eephone>

<cfparam name="FORM.region" type="string" default="">
<cfset region = FORM.region>

<cfparam name="FORM.district" type="string" default="">
<cfset district = FORM.district>

<cfparam name="FORM.lodgeno" type="string" default="">
<cfset lodgeno = FORM.lodgeno>

<cfparam name="FORM.lodgename" type="string" default="">
<cfset lodgename = FORM.lodgename>

<cfparam name="FORM.committee" type="string" default="">
<cfset committee = FORM.committee>

<cfparam name="FORM.lodge_pres" type="string" default="">
<cfset lodge_pres = FORM.lodge_pres>

<cfparam name="FORM.registration_type" type="string" default="">
<cfset registration_type = FORM.registration_type>

<cfparam name="FORM.gfullname" type="string" default="">
<cfset gfullname = FORM.gfullname>

<cfparam name="FORM.gcity" type="string" default="">
<cfset gcity = FORM.gcity>

<cfparam name="FORM.gstate" type="string" default="">
<cfset gstate = FORM.gstate>

<cfparam name="FORM.gcountry" type="string" default="">
<cfset gcountry = FORM.gcountry>

<cfparam name="FORM.guestsallmeals" type="string" default="">
<cfset guestsallmeals = FORM.guestsallmeals>

<cfparam name="FORM.guestsno" type="string" default="">
<cfset guestsno = FORM.guestsno>

<cfparam name="FORM.registrationAmount" type="string" default="">
<cfset registrationAmount = FORM.registrationAmount>



<table cellpadding="2" cellspacing="2" border="0"><tr><td class="text">
<span class="boldtext">Please check the information below and confirm. You will then be taken to <b>PayPal</b> to make a donation.</span>
</td></tr>
<td>
<cfoutput>
<table>
<tr>
<TR>
<TD class="boldtext">
Convention: <span class="text">#convention_date#</span><br><br>

1Registration Status: <span class="text">#registantStatus#</span><br><br>

Prefix: <span class="text">#title#</span><br><br>

First Name: <span class="text">#fname#</span><br><br>

MI:<span class="text">#mi#</span><br><br>

Last Name: <span class="text">#lname#</span><br><br>

Suffix: <span class="text">#suffix#</span><br><br>

Nickname: <span class="text">#nickname#</span><br><br>

Email:<span class="text">#email#</span><br><br>

Address:<span class="text">#stno#</span><br><br>

Apt.<span class="text">#stno2#</span><br><br>

City:<span class="text">#city#</span><br><br>

State/Province:<span class="text">#state#</span><br><br>

Zip/Postal Code:<span class="text">#zip#</span><br><br>

Country:<span class="text">#country#</span>
<br><br>

<span class="boldtext">Daytime Phone</span> (incl. area code):<span class="text">#hphone#</span><br><br>

<span class="boldtext">Evening Phone</span> (incl. area code):<span class="text">#wphone#</span><br><br>

<span class="boldtext">Fax</span> (incl. area code):<span class="text">#fax#</span><br><br>

Emergency Contact:<span class="text">#emercontact#</span><br><br>

<span class="boldtext">Emergency Daytime Phone </span>(incl. area code):
<span class="text">#edphone#</span><br><br>

<span class="boldtext">Emergency Evening Phone</span>(incl. area code):<span class="text">#eephone#</span>
<br><br>



<span class="boldtext">Select a Region</span> (for all members in USA or British Columbia):<span class="text">#region#</span><br><br>

<span class="boldtext">District</span>(Overseas members only):<span class="text">#district#</span><br><br>

Unit/Lodge Number:<span class="text">#lodgeno#</span><br><br>

<span class="boldtext">Unit/Lodge Name</span>(Required for delgates and alternates representing Units & Lodges):<span class="text">#lodgename#</span><br><br>

<span class="boldtext">Are you interested in serving on a Convention Buisness Committee, and if so will you be available to attend a meeting on Sunday June 27th?</span><br><span class="text">#committee#</span><br><br>

<span class="boldtext">Will you be a Unit/Lodge President when the convention takes place?</span><br><span class="text">#lodge_pres#</span><br><br>

Registration Type:<span class="text">#registration_type#</span><br><br>

Will you have guests?<span class="text">#registantStatus#</span><br><br>

How many guests will you have?<span class="text">#guestsno#</span><br><br>

Do you want to register your guests for all sessions, events, and meals?<br>
<span class="text">#guestsallmeals#</span><br><br>

Guest 1 Full Name: <span class="text">#gfullname#</span><br><br>

Guests 1's city:<span class="text">#gcity#</span><br><br>

State:<span class="text">#gstate#</span><br><br>

Country:<span class="text">#gcountry#</span><br><br>
</td>
</tr></table>


<form action="conv04_reg_form.cfm" method="post">
<input type="hidden" name="mode" value="edit">
<input type="submit" value="Go Back & Edit">
</form>

<form action="

https://www.paypal.com/cgi-bin/webscr"

method="post">
<cfif registantStatus IS "Registrant Only" AND registration_date LT "05/28/04">
<cfset registrationAmount="295.00">
</cfif>
<tr><td class"text">
<span class="text">
<b>The following fees are required for your registration:</b><br><br>
Registration Fees: <b>#DOLLARFORMAT(registrationAmount)#</b>
</span></td></tr>

<cfif isDefined("URL.calculate&quot

>
<cfif #URL.calculate# is "yes">
<input type="hidden" name="item_name" value="Convention Registration">
<input type="hidden" name="cmd" value="_ext-enter">
<input type="hidden" name="redirect_cmd" value="_xclick">
<input type="hidden" name="business" value="website@bnaibrith.org">
<input type="hidden" name="item_number" value="#session.total_registrants#">
<input type="hidden" name="first_name" value="#SESSION.fname#">
<input type="hidden" name="amount" value="#SESSION.registrationAmount#">
<input type="hidden" name="last_name" value="#SESSION.lname#">
<input type="hidden" name="address1" value="#SESSION.stno#">
<input type="hidden" name="address2" value="#SESSION.stno2#">
<input type="hidden" name="city" value="#SESSION.city#">
<input type="hidden" name="state" value="#SESSION.state#">
<input type="hidden" name="zip" value="#SESSION.zip#">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="no_shipping" value="0">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="tax" value="0">
<input type="hidden" name="return" value="

http://216.119.115.20/members/convention/success.cfm">

<input type="hidden" name="notify_url" value="

http://216.119.115.20/members/convention/ipn.cfm">

<input type="submit" value="Confirm">
</form>
</cfif>
</cfif>
</cfoutput>




<form action="conv04_reg_form.cfm" method="post">
<input type="hidden" name="mode" value="edit">
<input type="submit" value="Go Back & Edit">
</form>
<cfif isDefined("URL.calculate&quot

>
<cfif #URL.calculate# is "yes">
<cfif registantStatus IS "Registrant with Guests" AND registration_date GT "05/28/04">
<cfset registrationAmount= "325.00">
<cfif isDefined("Form.registrant&quot

>
<cfoutput>
<cfif guests IS 'Yes' AND guestsallmeals IS 'Yes'>
<cfset total_registrants = (#guestsno# + 1)>
<cfset registrationAmount =325 * #total_registrants#>
</cfif>
</cfoutput>
</cfif>
<cfoutput>
<tr><td class"text">
<span class="text">
<b>The following fees are required for your registration:</b>
Registered on: #DateFormat(registration_date, 'mm/dd/yyyy')#</<br><br>
Registration Fees: <b>#DOLLARFORMAT(total_payment)#</b>
</span></td></tr> </cfoutput>
<form action="

https://www.paypal.com/cgi-bin/webscr"

method="post">
<input type="hidden" name="item_name" value="Convention Registration">
<input type="hidden" name="cmd" value="_ext-enter">
<input type="hidden" name="redirect_cmd" value="_xclick">
<input type="hidden" name="business" value="website@bnaibrith.org">
<input type="hidden" name="item_number" value="#session.total_registrants#">
<input type="hidden" name="first_name" value="#SESSION.fname#">
<input type="hidden" name="amount" value="#SESSION.registrationAmount#">
<input type="hidden" name="last_name" value="#SESSION.lname#">
<input type="hidden" name="address1" value="#SESSION.stno#">
<input type="hidden" name="address2" value="#SESSION.stno2#">
<input type="hidden" name="city" value="#SESSION.city#">
<input type="hidden" name="state" value="#SESSION.state#">
<input type="hidden" name="zip" value="#SESSION.zip#">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="no_shipping" value="0">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="tax" value="0">
<input type="hidden" name="return" value="

http://216.119.115.20/members/convention/success.cfm">

<input type="hidden" name="notify_url" value="

http://216.119.115.20/members/convention/ipn.cfm">

ecobb · Feb 12, 2004

Where is the variable total_payment coming from? I don't see anywhere in the code above the you are creating or setting it (although I may have missed it). The only time that variable appears is #DOLLARFORMAT(total_payment)#.

Are you still getting this error?
Error resolving parameter TOTAL_PAYMENT

ColdFusion was unable to determine the value of the parameter

Make sure you set your variable.

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

radiance · Feb 13, 2004

Question: How can I define total_payment? It is not in my form directly, but should come as a result of the calculations. Therefore, would I still place total_payment in the variable listing at the top?

Pls. advise.

Thank you for your help and patience!

So:

<cfif isDefined("URL.calculate&quot

>
<cfif #URL.calculate# is "yes">
<cfif registantStatus IS "Registrant with Guests" AND registration_date GT "05/28/04">
<cfset registrationAmount= "325.00">
<cfif isDefined("Form.registrant&quot

>
<cfoutput>
<cfif guests IS 'Yes' AND guestsallmeals IS 'Yes'>
<cfset total_registrants = (#guestsno# + 1)>
<cfset registrationAmount =325 * #total_registrants#>
<cfelse>
<cfset registrationAmount= "200.00">
<cfset registrationAmount =200 * #total_registrants#>

</cfif>
</cfoutput>
</cfif>

ecobb · Feb 13, 2004

It is not in my form directly, but should come as a result of the calculations
No where in this code are you running any calculations to create the "total_payment" variable. YOU may know what you want it to be, but CF doesn't have a clue.

Is your "total_payment" supposed to be the same thing as your "registrationAmount"? If so, just use the "registrationAmount" variable instead of the "total_payment" variable.

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

radiance · Feb 13, 2004

Question.

I changed the "total_payment" to registrationAmount, but I am still getting "0" instead of a value. Furthermore, if it were right, I can only click on edit (which also has errors). I don't see confirm and go to paypal option.

radiance · Feb 13, 2004

The form outputs the total for single registrant and no guests. But it is still not making the calculation for registrants with guests. why? The condition has not changed much...except the totalRegistrants are only possible if the registrants selects the guests as full- paying registrants.

ecobb · Feb 13, 2004

Ok dude, here's what I'm seeing:

You are setting the inital value of the variable registrationAmount

Code:

<cfparam name=&quot;FORM.registrationAmount&quot; type=&quot;string&quot; default=&quot;&quot;>    
    <cfset registrationAmount = FORM.registrationAmount>

Later, you're re-setting the value of the registrationAmount variable:

Code:

<cfif registantStatus IS &quot;Registrant Only&quot; AND registration_date LT &quot;05/28/04&quot;>
<cfset registrationAmount=&quot;295.00&quot;>
</cfif>

What happens if the user is registering for the 4th of July? What happens if the "registantStatus" value is not "Registrant Only"? Nothing happens. No value is reset, no calculations occur...nothing. You're telling CF that, unless the information provided is exactly equal to both of these 2 values, keep the default values. Most likely that's why you keep getting "0", something is not matching up and the registrationAmount is not getting reset.

Looking again at your IF statements, you have:

Code:

<cfif registantStatus IS &quot;Registrant Only&quot; AND registration_date LT &quot;05/28/04&quot;>

And later:

Code:

<cfif registantStatus IS &quot;Registrant with Guests&quot; AND registration_date GT &quot;05/28/04&quot;>

What happens if there is a "Registrant with Guests" scheduled for 05/01/04? Nothing. With these IF statments, you're only accounting for 2 possible situations when there are several others that could happen. Never assume that your users are going to do what you want them to do, becuase they won't. You always need to have a backup plan, ask yourself "But what if they DON'T do it like this?"

Also, you have to remember, "#URL.calculate#" and "URL.calculate" are not the same thing to ColdFusion. "URL.calculate" is the Name of a variable, and "#URL.calculate#" is the Value of that variable.
So, ColdFusion is reading this:

Code:

<cfif #URL.calculate# is &quot;yes&quot;>

AS

Code:

<cfif Yes is &quot;yes&quot;>

It should probably be:

Code:

<cfif URL.calculate is &quot;yes&quot;>

Don't worry, we're getting there...

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

radiance · Feb 13, 2004

Thank you. I am going to review my code and your suggestions. I will let you know what happens.

Thank you so much.

radiance · Feb 17, 2004

How can I go about telling coldfusion the difference in prices using the variables that I have?

I will post what I have come up with shortly.

radiance · Feb 17, 2004

I reset the variables and am getting an error with URL.calculate as well as with the total registrants. I feel that I am closer to the solution, but not close enough:

Please advise. Thanks in advance for your help.
__________________________________________________

<cfoutput><cfinclude template="#request.header#"></cfoutput>



<cfparam name="FORM.convention_date" type="string" default="">
<cfset convention_date = FORM.convention_date>

<cfparam name="FORM.registration_date" type="string" default="">
<cfset registration_date = FORM.registration_date>

<cfparam name="FORM.title" type="string" default="">
<cfset title = FORM.title>

<cfparam name="FORM.fname" type="string" default="">
<cfset fname = FORM.fname>

<cfparam name="FORM.mi" type="string" default="">
<cfset mi = FORM.mi>

<cfparam name="FORM.lname" type="string" default="">
<cfset lname = FORM.lname>

<cfparam name="FORM.nickname" type="string" default="">
<cfset nickname = FORM.nickname>

<cfparam name="FORM.suffix" type="string" default="">
<cfset suffix = FORM.suffix>

<cfparam name="FORM.email" type="string" default="">
<cfset email = FORM.email>

<cfparam name="FORM.stno" type="string" default="">
<cfset stno = FORM.stno>

<cfparam name="FORM.stno2" type="string" default="">
<cfset stno2 = FORM.stno2>

<cfparam name="FORM.city" type="string" default="">
<cfset city = FORM.city>

<cfparam name="FORM.state" type="string" default="">
<cfset state = FORM.state>

<cfparam name="FORM.zip" type="string" default="">
<cfset zip = FORM.zip>

<cfparam name="FORM.country" type="string" default="">
<cfset country = FORM.country>

<cfparam name="FORM.hphone" type="string" default="">
<cfset hphone = FORM.hphone>

<cfparam name="FORM.wphone" type="string" default="">
<cfset wphone = FORM.wphone>

<cfparam name="FORM.fax" type="string" default="">
<cfset fax = FORM.fax>

<cfparam name="FORM.emercontact" type="string" default="">
<cfset emercontact = FORM.emercontact>

<cfparam name="FORM.ephone" type="string" default="">
<cfset edphone = FORM.edphone>

<cfparam name="FORM.eephone" type="string" default="">
<cfset eephone = FORM.eephone>

<cfparam name="FORM.region" type="string" default="">
<cfset region = FORM.region>

<cfparam name="FORM.district" type="string" default="">
<cfset district = FORM.district>

<cfparam name="FORM.lodgeno" type="string" default="">
<cfset lodgeno = FORM.lodgeno>

<cfparam name="FORM.lodgename" type="string" default="">
<cfset lodgename = FORM.lodgename>

<cfparam name="FORM.committee" type="string" default="">
<cfset committee = FORM.committee>

<cfparam name="FORM.lodge_pres" type="string" default="">
<cfset lodge_pres = FORM.lodge_pres>

<cfparam name="FORM.registration_type" type="string" default="">
<cfset registration_type = FORM.registration_type>

<cfparam name="FORM.gfullname" type="string" default="">
<cfset gfullname = FORM.gfullname>

<cfparam name="FORM.gcity" type="string" default="">
<cfset gcity = FORM.gcity>

<cfparam name="FORM.gstate" type="string" default="">
<cfset gstate = FORM.gstate>

<cfparam name="FORM.gcountry" type="string" default="">
<cfset gcountry = FORM.gcountry>

<cfparam name="FORM.guestsallmeals" type="string" default="">
<cfset guestsallmeals = FORM.guestsallmeals>

<cfparam name="FORM.guestsno" type="string" default="">
<cfset guestsno = FORM.guestsno>

<cfparam name="FORM.registrationAmount" type="string" default="">
<cfset registrationAmount = FORM.registrationAmount>

<cfparam name="FORM.registration_date" type="string" default="">
<cfset registration_date = FORM.registration_date>
<cfif registration_date LT 05/28/04>
<cfset registrationAmount=295>
<cfelse>
<cfset registrationAmount=325>
</cfif>



<cfparam name="FORM.registrantStatus" type="string" default="">
<cfif registrantStatus IS 'Registrant_Guests' AND guestsallmeals IS 'yes'>
<cfset total_registrants = (#guestsno# +1)>
<cfelse>
<cfset total_registrants = 1>
</cfif>



<cfparam name="FORM.total_registrants" type="string" default="">
<cfset total_registrants = FORM.total_registrants>



<table cellpadding="2" cellspacing="2" border="0"><tr><td class="text">
<span class="boldtext">Please check the information below and confirm. You will then be taken to <b>PayPal</b> to make a donation.</span>
</td></tr>
<td>
<cfoutput>
<table>
<tr>
<TR>
<TD class="boldtext">
Convention: <span class="text">#convention_date#</span><br><br>

1Registration Status: <span class="text">#registantStatus#</span><br><br>

Prefix: <span class="text">#title#</span><br><br>

First Name: <span class="text">#fname#</span><br><br>

MI:<span class="text">#mi#</span><br><br>

Last Name: <span class="text">#lname#</span><br><br>

Suffix: <span class="text">#suffix#</span><br><br>

Nickname: <span class="text">#nickname#</span><br><br>

Email:<span class="text">#email#</span><br><br>

Address:<span class="text">#stno#</span><br><br>

Apt.<span class="text">#stno2#</span><br><br>

City:<span class="text">#city#</span><br><br>

State/Province:<span class="text">#state#</span><br><br>

Zip/Postal Code:<span class="text">#zip#</span><br><br>

Country:<span class="text">#country#</span>
<br><br>

<span class="boldtext">Daytime Phone</span> (incl. area code):<span class="text">#hphone#</span><br><br>

<span class="boldtext">Evening Phone</span> (incl. area code):<span class="text">#wphone#</span><br><br>

<span class="boldtext">Fax</span> (incl. area code):<span class="text">#fax#</span><br><br>

Emergency Contact:<span class="text">#emercontact#</span><br><br>

<span class="boldtext">Emergency Daytime Phone </span>(incl. area code):
<span class="text">#edphone#</span><br><br>

<span class="boldtext">Emergency Evening Phone</span>(incl. area code):<span class="text">#eephone#</span>
<br><br>



<span class="boldtext">Select a Region</span> (for all members in USA or British Columbia):<span class="text">#region#</span><br><br>

<span class="boldtext">District</span>(Overseas members only):<span class="text">#district#</span><br><br>

Unit/Lodge Number:<span class="text">#lodgeno#</span><br><br>

<span class="boldtext">Unit/Lodge Name</span>(Required for delgates and alternates representing Units & Lodges):<span class="text">#lodgename#</span><br><br>

<span class="boldtext">Are you interested in serving on a Convention Buisness Committee, and if so will you be available to attend a meeting on Sunday June 27th?</span><br><span class="text">#committee#</span><br><br>

<span class="boldtext">Will you be a Unit/Lodge President when the convention takes place?</span><br><span class="text">#lodge_pres#</span><br><br>

Registration Type:<span class="text">#registration_type#</span><br><br>

Will you have guests?<span class="text">#registantStatus#</span><br><br>

Total Registrants:
<cfif registrantStatus IS 'Registrant_Guests' and guestsallmeals IS 'yes'>
#total_registrants#
</cfif>

How many guests will you have?<span class="text">#guestsno#</span><br><br>

Do you want to register your guests for all sessions, events, and meals?<br>
<span class="text">#guestsallmeals#</span><br><br>

Guest 1 Full Name: <span class="text">#gfullname#</span><br><br>

Guests 1's city:<span class="text">#gcity#</span><br><br>

State:<span class="text">#gstate#</span><br><br>

Country:<span class="text">#gcountry#</span><br><br>
</td>
</tr></table>


<form action="test.cfm" method="post">
<input type="hidden" name="mode" value="edit">
<input type="submit" value="Go Back & Edit">
</form>

<form action="

https://www.paypal.com/cgi-bin/webscr"

method="post">
<tr><td class"text">
<span class="text">
<b>The following fees are required for your registration:</b><br><br>
Registration Fees: <b>#DOLLARFORMAT(registrationAmount)#</b>
</span></td></tr>

<cfif URL.calculate is "yes">
<input type="hidden" name="item_name" value="Convention Registration">
<input type="hidden" name="cmd" value="_ext-enter">
<input type="hidden" name="redirect_cmd" value="_xclick">
<input type="hidden" name="business" value="website@bnaibrith.org">
<input type="hidden" name="item_number" value="#session.total_registrants#">
<input type="hidden" name="first_name" value="#SESSION.fname#">
<input type="hidden" name="amount" value="#SESSION.registrationAmount#">
<input type="hidden" name="last_name" value="#SESSION.lname#">
<input type="hidden" name="address1" value="#SESSION.stno#">
<input type="hidden" name="address2" value="#SESSION.stno2#">
<input type="hidden" name="city" value="#SESSION.city#">
<input type="hidden" name="state" value="#SESSION.state#">
<input type="hidden" name="zip" value="#SESSION.zip#">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="no_shipping" value="0">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="tax" value="0">
<input type="hidden" name="return" value="

http://216.119.115.20/members/convention/success.cfm">

<input type="hidden" name="notify_url" value="

http://216.119.115.20/members/convention/ipn.cfm">

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

IPN and payment conflict- please help......

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Similar threads

Log in

Part and Inventory Search

Sponsor