How to Save Credit Card Information to the Receipt Table

ID: Q229845

The information in this article applies to:

Microsoft Site Server version 3.0, Commerce Edition

SUMMARY

By default, credit card information is not saved to the receipt table in sites generated by the Commerce 3.0 Wizard. The SaveReceipt component in the accept stage has _cc_ in the No Save Key prefix.

In some situations such as when a non-commerce aware credit card verification package is being used, it may be desirable to save the credit card number, type, and expiration date to the receipt table.

MORE INFORMATION

Credit card information can be saved to the receipt table by performing the following steps:

Remove _cc_ from the No Save Key prefix of the SaveReceipt component.

Add a column to the receipt table for each element of the order form you want to save.
For example:

_cc_number with a datatype of varchar(16)
_cc_type with a data type of varchar(10)
_cc_expmonth data type varchar(2)
_cc_expyear data type varchar(4)

Additional query words:


Keywords          : 
Version           : winnt:3.0
Platform          : winnt 
Issue type        : kbhowto

Last Reviewed: May 14, 1999