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:

To Use Cookies or Not To Use Cookies (2003) WebCatalog for guestbook ? (1997) stopping/restarting service on NT? (1998) Emailer (1997) Erotic Sites (1997) Allow-Deny: Solved with [Getchars] (1998) problem with WebDNA Command (2004) rotating thumbnails (1997) Nested tags count question (1997) PCS Frames (1997) products db philosophy (2001) Include a big block of text (1997) Redirect frame targets (1998) Quitting WebMerchant ? (1997) multi-part email help (2001) Conditional searching & displaying (1997) LOOP and IF statements (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Next (1997) RE: Purchased cart being overwritten (1997)