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:

    
  1. Re: Saving/Looking Up customer numbers (Rob Marquardt 1998)
  2. Re:Saving/Looking Up customer numbers (Jay Van Vark 1998)
  3. Saving/Looking Up customer numbers (Larry Orchier 1998)
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:

WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Newbie from and old bee (1997) Help with Repost Data msg from form (1997) another problem (1997) [WebDNA] heads up - are your sandbox prefs broken? (If not, are you vulnerable to formvar hacks?) (2011) Upgrade to WebCat2 from Commerce Lite (1997) IE problems persist (2004) WebCommerce: Folder organization ? (1997) form data submission gets truncated (1997) Make sure I understand this??? (1997) Too many database headers? (2003) RE: Re:Signal Raised (1997) still having shipCost.db Problem (1997) searchable list archive (1997) Possible Bug in 2.0b15.acgi (1997) Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) WebCat2 - many [carts] on one template page? (1997) Frames (1997) [WebDNA] 6.2 Monitor (2012) Some Advise needed (1997)