VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Display Orders: add oauthorization status
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

49 Posts

Posted - January 15 2007 :  14:13:47  Show Profile  Reply with Quote
We need to be able to see right up front on all grids/views that display orders whether or not it's a valid order, to show the response from the gateway.

In shopa_displayorders.asp I changed fieldnames(5) from country (not used) to oauthorization:

HeadNames(5)="CCD Auth"

The oauthorization field is very long and I'd like to trim it to just return the first 25 characters. I've tried a number of ways but getting error. What is the correct syntax to make this work?

Tried fieldnames(5)=left("oauthorization",25) but that doesn't work either.

*** EDIT *** Ideally I would just like to display a red * if the order was declined or errored out in any way.

Edited by - nxpage on January 15 2007 14:19:34

Starting Member

49 Posts

Posted - January 21 2007 :  21:48:01  Show Profile  Reply with Quote
This is a bit of a fiddly one - should be a bit easier to modify i think but anyways...

fieldnames(5) has to be the actual database field name so have fieldnames(5)="oauthorization"

Then in the sub generatetable routine you can see lines of code like:

response.write "<td>"
response.write shopformatcurrency (rsorder(fieldname),getconfig("xdecimalpoint"))
response.write "</td>"

You need to add another one of these for oauthorization. eg:

response.write "<td>"
response.write left(rsorder(fieldname),25)
response.write "</td>"

I think that'll do it for you.

Go to Top of Page

Starting Member

49 Posts

Posted - January 25 2007 :  13:59:18  Show Profile  Reply with Quote
Thanks k-otic! Worked like a charm. Now able to highlight declined transactions as well with that snippet of code help. A simple way to exclude declined $ transactions from sales figures would be nice :)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000