Databases
StackOverflow2013
Postsdbo
POPayPal ExpressCheckout Missing Total column
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPayPal ExpressCheckout Missing Total column
    primarykey
    data
    text
    <p>Why am I missing the total on the checkout page?</p> <p><img src="https://i.stack.imgur.com/UJj26.png" alt="Missing Totals"></p> <p>Apologies.</p> <p>As my code is working, because it actually got to PayPal and does have all the field correct. I didn't think it was necessary to post the code. I thought it could be answered simply, "you're missing the XXXX variable in your post to PayPal."</p> <p>But, seeing as this is StackOverflow, code is required.</p> <p>This is COLDFUSION (yes caps because people think this is a dead/dying language).</p> <pre><code>&lt;cffunction name="expressCheckout" access="remote" returnformat="JSON" output="false" description="Processes PayPal Subscription"&gt; &lt;cfargument name="L_BILLINGAGREEMENTDESCRIPTION0" type="string" required="yes" /&gt; &lt;cfargument name="L_BILLINGTYPE0" type="string" required="yes" /&gt; &lt;cfargument name="AMT" type="numeric" required="yes" /&gt; &lt;cfset var username = "wpp_1306278086_biz_api1.blahblah.com"&gt; &lt;cfset var password = "1306278555"&gt; &lt;cfset var signature = "someSig"&gt; &lt;cfset var serverURL = "https://api-3t.sandbox.paypal.com/nvp"&gt; &lt;cfset var version = "65.1"&gt; &lt;cfset requestData = StructNew()&gt; &lt;cfset requestData.USER = "#USERNAME#"&gt; &lt;cfset requestData.PWD = "#PASSWORD#"&gt; &lt;cfset requestData.SIGNATURE = "#SIGNATURE#"&gt; &lt;cfset requestData.SUBJECT = ""&gt; &lt;cfset requestData.VERSION = "#version#"&gt; &lt;cfset requestData.METHOD = "SetExpressCheckout"&gt; &lt;cfset requestData.AMT = "#arguments.AMT#"&gt; &lt;cfset requestData.DESC = "#arguments.L_BILLINGAGREEMENTDESCRIPTION0#"&gt; &lt;cfset requestData.CUSTOM = "#session.rfcid#"&gt; &lt;cfset requestData.returnURL = "http://localhost:8500/rfc2-1/membership/payPalConfirm.cfm"&gt; &lt;cfset requestData.cancelURL = "http://localhost:8500/rfc2-1/membership/creditcardform.cfm"&gt; &lt;cfset payPalReturn = doHttppost(requestData, serverURL, "no")&gt; &lt;cfset payPalReturn = getNVPResponse(#URLDecode(payPalReturn)#)&gt; &lt;cfif payPalReturn.ACK EQ "Failure"&gt; &lt;!--- return the error message ---&gt; &lt;cfset payPalReturn.ERRORMESSAGE = #payPalReturn.L_LONGMESSAGE0#&gt; &lt;/cfif&gt; &lt;cfreturn payPalReturn&gt; &lt;/cffunction&gt; </code></pre> <p>This retuns a json object to the browser. The browser then sends me to: <a href="https://sandbox.paypal.com/cgi-bin/webscr?cmd=_express-checkout&amp;token=SomeToken" rel="nofollow noreferrer">https://sandbox.paypal.com/cgi-bin/webscr?cmd=_express-checkout&amp;token=SomeToken</a></p> <p>All fine when I get to PayPal. Just missing the total in the left hand box (as diagrammed)</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLoony2nz
    1. USLoony2nz
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COIs this supposed to be a guessing game, or are we supposed to use ESP to see your code? You posted absolutely no information that can be used to help you. Voting to close as "not a real question".
      singulars
      1. POPayPal ExpressCheckout Missing Total column
      1. USKen White
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload