Re: Credit card arrangement
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63518
interpreted = N
texte = Pat,I think I have to offer you something else to take care of this. I know =what your clients need. I'll email you offline.Bess Ho=20Business Analyst/Webmaster=20Dept of Marketing=20US Merchant Systems=203125 Skyway Court=20Fremont CA 94539=20Direct 510-771-2100 Ext 119=20Fax 800-329-0961=20bessh@usms.com=20www.usms.com=20-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfPatrick McCormickSent: Wednesday, November 30, 2005 2:42 PMTo: WebDNA TalkSubject: Re: Credit card arrangementI think I need to save the CC info. My customers have signed a =20contract. Their office uses the site to process orders which they'll =20do many times a day. All orders will be charged to the credit card. =20Unless I want to drive them crazy, I need to store the CC info. I =20also need to get authorization with each transaction before allowing =20them to proceed on the site.I need something cagey that allows me to tell the CC company that the =20CC info is not stored on the server.On Nov 30, 2005, at 3:26 PM, Marc Thompson wrote:> Good point Bob. When we save an encrypted CCnumber we also save a =20> time stamp with it for comparison later. We use a trigger to =20> compare the stored time stamp with the current time and take action =20> based on that comparison.> Here's the code for creating a time stamp:> [text]timestamp=3D[math]((([math]{[date]}[/math])-1)*86400)+([math]=20> {[time]}[/math])[/math][/text]>> The above code was gathered from this talk list. Works great!>> Marc>> Bob Minor wrote:>>> And only keep them store for the length of time necessary. Too =20>> many folks just keep em to keep them. Reduce your liability by =20>> keeping them for as short a period as possible.>> On Nov 30, 2005, at 1:12 PM, Marc Thompson wrote:>>> The following has worked very well for encrypting and decrypting =20>>> numbers:>>> [Text]CCnum_Encrypted=3D[url][url][Encrypt =seed=3D8chars][CCnumber][/ =20>>> Encrypt][/url][/url][/Text]>>>>>> [Text]CCnumber=3D[Decrypt seed=3D8chars][unurl][CCnum_Encrypted][/=20>>> unurl] [/Decrypt][/Text]>>>>>> Be sure to keep your seed value (8 characters of your choice) =20>>> secret!>> ------------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list
.>> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > digest@talk.smithmicro.com>>> Web Archive of this list is at: http://webdna.smithmicro.com/>> --=20> -------------------------------------------> Marc Thompson> Software Engineer> Office of Information Technology> University of Utah> 801.585.9264> marc.thompson@utah.edu> ------------------------------------------->> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to =Web Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Pat,I think I have to offer you something else to take care of this. I know =what your clients need. I'll email you offline.Bess Ho=20Business Analyst/Webmaster=20Dept of Marketing=20US Merchant Systems=203125 Skyway Court=20Fremont CA 94539=20Direct 510-771-2100 Ext 119=20Fax 800-329-0961=20bessh@usms.com=20www.usms.com=20-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfPatrick McCormickSent: Wednesday, November 30, 2005 2:42 PMTo: WebDNA TalkSubject: Re: Credit card arrangementI think I need to save the CC info. My customers have signed a =20contract. Their office uses the site to process orders which they'll =20do many times a day. All orders will be charged to the credit card. =20Unless I want to drive them crazy, I need to store the CC info. I =20also need to get authorization with each transaction before allowing =20them to proceed on the site.I need something cagey that allows me to tell the CC company that the =20CC info is not stored on the server.On Nov 30, 2005, at 3:26 PM, Marc Thompson wrote:> Good point Bob. When we save an encrypted CCnumber we also save a =20> time stamp with it for comparison later. We use a trigger to =20> compare the stored time stamp with the current time and take action =20> based on that comparison.> Here's the code for creating a time stamp:> [text]timestamp=3D[math]((([math]{[date]}[/math])-1)*86400)+([math]=20> {[time]}[/math])[/math][/text]>> The above code was gathered from this Talk List. Works great!>> Marc>> Bob Minor wrote:>>> And only keep them store for the length of time necessary. Too =20>> many folks just keep em to keep them. Reduce your liability by =20>> keeping them for as short a period as possible.>> On Nov 30, 2005, at 1:12 PM, Marc Thompson wrote:>>> The following has worked very well for encrypting and decrypting =20>>> numbers:>>> [text]CCnum_Encrypted=3D[url][url][Encrypt =seed=3D8chars][CCnumber][/ =20>>> Encrypt][/url][/url][/Text]>>>>>> [text]CCnumber=3D[Decrypt seed=3D8chars][unurl][CCnum_Encrypted][/=20>>> unurl] [/Decrypt][/Text]>>>>>> Be sure to keep your seed value (8 characters of your choice) =20>>> secret!>> ------------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > digest@talk.smithmicro.com>>> Web Archive of this list is at: http://webdna.smithmicro.com/>> --=20> -------------------------------------------> Marc Thompson> Software Engineer> Office of Information Technology> University of Utah> 801.585.9264> marc.thompson@utah.edu> ------------------------------------------->> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to =Web Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Bess Ho"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCatalog can't find database (1997)
Two stores, one server (1998)
Generating Report Totals (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
automating txt downloads for conversion to webcat db (2006)
back button problem (1999)
[WebDNA] Hard-coded db write delay when running certain code? (2011)
PLEASE REMOVE MY EMAIL ADDRESS (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
_ in front of field name (1998)
Nitro plugin? (1998)
submit a form using javascript in netscape (2001)
[writefile] and CR's (2001)
Auto entering Friday's date in a field (2002)
Color options for items (1999)
still facing truncated [texta] problem (2000)
WebTen? (1997)
Error Lob.db records error message not name (1997)
Help! I've fallen in Structured Query Language and can'tget (2002)
Caching [include] files ... (1997)