Re: history file
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43595
interpreted = N
texte = Paul wrote:> Hi>> I would like to make sure that when someone logs onto the website that> all his previous purchases are shown on a user page which he has to log> onto with the username and password he created the first time he joined,> what is the easiest way of doing this?Hi paul, I am sure there is a few ways to do this. I would probably assignan ID to that customer when he/she registers. this ID would probably bein the clients.db file that you have currently.I would probably then create a second database... (order_history.db or something)Then when a customer purchases an order (perhaps on the thankyou page) youcan append to this database the ID and the order info. This way, when a userlogs in first a query is done (probably a lookup) to the clients.db for the ID.when the ID is found a search is done on the order history with that ID number(if you store the date also you could sort by date). There is a whole slew ofthingsyou *could* do though so have fun!.cheers,Donovan>>> Is there a way of adding multiple SKU numbers to his entry in the> clients.db file I have rather than search all the old orders as i would> rather do it this way>> Any help appreciated>> Paul>>-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Paul wrote:> Hi>> I would like to make sure that when someone logs onto the website that> all his previous purchases are shown on a user page which he has to log> onto with the username and password he created the first time he joined,> what is the easiest way of doing this?Hi paul, I am sure there is a few ways to do this. I would probably assignan ID to that customer when he/she registers. this ID would probably bein the clients.db file that you have currently.I would probably then create a second database... (order_history.db or something)Then when a customer purchases an order (perhaps on the thankyou page) youcan append to this database the ID and the order info. This way, when a userlogs in first a query is done (probably a lookup) to the clients.db for the ID.when the ID is found a search is done on the order history with that ID number(if you store the date also you could sort by date). There is a whole slew ofthingsyou *could* do though so have fun!.cheers,Donovan>>> Is there a way of adding multiple SKU numbers to his entry in the> clients.db file I have rather than search all the old orders as i would> rather do it this way>> Any help appreciated>> Paul>>-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------------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://search.smithmicro.com/
Donovan
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:
PCS Emailer's role ? (1997)
Country & Ship-to address & other fields ? (1997)
The Guru Speaks-Is That Really the Only Manuel? (1998)
New Command prefs ... (1997)
WebCat name recognition (1998)
Banner Ad example (Typhoon) and WebCatalog (1997)
f2 download problems (1997)
Bug Report, maybe (1997)
Nesting format tags (1997)
[OT] On a side note.. (2003)
Buying sans cart (1997)
WebCommerce: Folder organization ? (1997)
authenticating a second user (1997)
price carry over (1997)
[purchase] (1999)
syntax question, not in online refernce (1997)
RE: Displaying Location (1997)
File not found error message (1998)
Show all from database (2001)
Not really WebCat (1997)