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:
Save Word/Excel Docs to Server (2002)
[table] retained in memory (2006)
[UPPERCASE] (1997)
Missing from Docs [folderName] (1997)
Searching multiple Databases (1997)
Line Feed Character Appended (1998)
A Global Variable (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
WebCatalog and Filemaker (1996)
[date format] w/in sendmail (1997)
Discounts (2002)
Putting together a econimic server (2004)
plugin-acgi, different results (1997)
Sendmail Woes (2002)
Template transformed itself into a database? (1998)
Writing multiple data into one field (1998)
Date Calulation (1997)
Criticism of WebCatalog: Keep It Coming! (1998)
(1997)
Fun with Dates - revisited (1997)