Paul Tew

Hi

Can anybody help with customising the sort order of credit card profiles please I've tried using SQL Server Profiler to work out which stored procedures are being executed, but it isn't obvious how they are being retrieved.

Any help would be much appreciated.

Regards

Paul Tew



Re: Commerce Server 2007 Credit Card sorting

Joe Wasson - MSFT

If you are talking about the Starter Site and/or the Credit Cards that are listed in the user's profile, they are shown in the order that they are stored inthe multi-value property. The multi-value property (credit_card_list) is a delimited string of profile IDs (<guid>;<guid>) and each profile is retrieved individually. You will most likely need to do the sorting in the application. There is no join being performed.



Re: Commerce Server 2007 Credit Card sorting

Paul Tew

Thanks Joe, I meant the list of credit cards that the website accepts. I've added new card types to the list, but there doesn't seem to be any logical sorting (not even by the order they exist in the database).