Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Need help

Author  Topic 

levani
Starting Member

5 Posts

Posted - 2008-03-05 : 04:35:14
I have a website created with wordpress. I'm selling some products with this site. For shipping I'm using one of my bank's e-commerce module. It isn't important how this system works, I can just say that when my site visitors click the "Buy Now" button, they are redirected to the bank's page, where they must enter their credit cart information. But I have one problem. I can't get the information who finished the procese and payed money. For this I need to give each registered member some unique value, using sql. This information must accessible only for me, and maybe for bank too. Can you please tell me how can I do it?

Here you can visit my website:

[url]http://www.handmade-model-cars.com[/url]

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-05 : 04:39:06
maybe you can use NEWID() from your database, or SessionID in your browser?


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

levani
Starting Member

5 Posts

Posted - 2008-03-05 : 05:08:17
I don't know how to do it. Can I see some tutorial for it anywhere?
Go to Top of Page

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 2008-03-05 : 20:34:36
Put an Identity column on your member table & use that.
Go to Top of Page
   

- Advertisement -