Re: Saving/Looking Up customer numbers
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16038
interpreted = N
texte = On 2/15/98 4:34 PM, Larry Orchier so noted...>I need to assign each customer a unique customer code. >After they have filled out their information form, I need to find out >the last number assigned, increment it by one, and then place that in >their record in the customer database. > >Is their an example anywhere that I could see?I don't know if this is the most elegant solution, but it's what I used when I had a similar need.I have a customer.db file such as:date user id 1/2/98 bob 1 1/5/98 chuck 2 1/9/98 sally 3 end
4Then, when a new customer is added (with a form passing the value for [userName]), the following is executed:[delete db=customer.db&eqDateData=end] [append db=customer.db]date=[date]&user=[userName]&id=[math]newID[/math][/append] [append db=customer.db]date=end&id=[math]newID +1[/math][/append]Hope this is of some help,Rob Marquardt Designer/Resident Wirehead Toast Design300 First Avenue North, Suite 150 Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com
Associated Messages, from the most recent to the oldest:
On 2/15/98 4:34 PM, Larry Orchier so noted...>I need to assign each customer a unique customer code. >After they have filled out their information form, I need to find out >the last number assigned, increment it by one, and then place that in >their record in the customer database. > >Is their an example anywhere that I could see?I don't know if this is the most elegant solution, but it's what I used when I had a similar need.I have a customer.db file such as:date user id 1/2/98 bob 1 1/5/98 chuck 2 1/9/98 sally 3 end 4Then, when a new customer is added (with a form passing the value for [username]), the following is executed:[delete db=customer.db&eqDateData=end] [append db=customer.db]date=[date]&user=[username]&id=[math]newID[/math][/append] [append db=customer.db]date=end&id=[math]newID +1[/math][/append]Hope this is of some help,Rob Marquardt Designer/Resident Wirehead Toast Design300 First Avenue North, Suite 150 Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com
Rob Marquardt
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:
Stymied by [ShowNext] with drop down list on a form (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
MacWEEK article help needed (1996)
Sharing DBs across domains (2001)
Re:2nd WebCatalog2 Feature Request (1996)
WebDNA and SQL (2003)
New Cart No. on same page (2003)
WebCat2b15MacPlugin - [protect] (1997)
WEBCAT with SQL backend. Help please! (2000)
Javascript Fields of Strawberry Roses and Green Bananas (2000)
RE: Clearing orders and database help! (1997)
Adding Message to Order (1997)
WebCatalog seems to choke on large (2meg) html files. (1998)
Multiple Users.db Possible? (1997)
searchable list archive (1997)
[SubTotal] again (1998)
Locking up with WebCatalog... (1997)
Nested tags count question (1997)
[BoldWords] WebCat.acgib15Mac (1997)