Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Credit Card Number Validation Escalar Function Expand / Collapse
Author
Message
Posted Thursday, March 18, 2010 7:30 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, April 2, 2012 5:41 PM
Points: 645, Visits: 138
Comments posted to this topic are about the item Credit Card Number Validation Escalar Function
Post #886016
Posted Wednesday, March 24, 2010 2:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 2:38 AM
Points: 1, Visits: 26
This does make the assumption that the Credit Card number is unencrypted (If stored in the Database) and as the PCI/DSS regulations strictly forbids this, I would be very careful about the use of using any form of un-encrypted credit cards. This will cause you major headaches with PCI DSS - also in practice Credit Card encryption has to be performed to the Payment Card Industry standard (so you can't generally use your own encryption methods)

Reference: Requirements 3 and 4 of the PCI DSS version 1.2
https://www.pcisecuritystandards.org/security_standards/pci_dss.shtml

The Standards document as a PDF: https://www.pcisecuritystandards.org/security_standards/download.html?id=pci_dss_v1-2.pdf
Post #888746
Posted Wednesday, March 24, 2010 2:42 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 14, 2010 4:54 AM
Points: 40, Visits: 45
Hi Thor,

Give some examples
Output is not coming!.....
Only 0 returns what ever the credit card no. given it returns only 0 not 1.

One more Query, Why u are asking for 16 digit no. for credit card. Ther are many cards with 12 digit no.


Try Try Try Again,
One Day u vl succeed..................
Post #888748
Posted Wednesday, March 24, 2010 6:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 23, 2012 6:40 AM
Points: 7, Visits: 103
this works for everything but american express ... in any case my impression was that PCI DSS allows encrypted storage untill it is processed, once processed you must purge it asap.
Post #888893
Posted Wednesday, March 24, 2010 7:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 22, 2010 8:59 AM
Points: 110, Visits: 952
I was really expecting to see a set-based approach to this formula.

Post #888933
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse