Re: CART question

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59998
interpreted = N
texte = devaulw@onebox.com wrote: > I'm not clear about the limitations of autonumber. Can you elaborate? > I thought autonumber would have been a good choice (relational or not). > Once the number is assigned, that's it. > Am I missing something? > > Bill Yea, its asigned unless the record is deleted. Then that number *could* be asigned to a totaly different record.. in this case a member profile. So if you have an invoice or some other record (in another .db file) that links to that record Id, your going to get the wrong profile (which could be bad). a way around this is to have a database where its only purpose is to create consectutive numbers that never get deleted. Those numbers are then used. ... thus the term "global ID". Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: CART question ( Donovan Brooke 2004)
  2. Re: CART question ( Brian Fries 2004)
  3. Re: CART question ( devaulw@onebox.com 2004)
  4. Re: CART question ( Patrick J. 2004)
  5. Re: CART question ( Donovan Brooke 2004)
  6. Re: CART question ( John Peacock 2004)
  7. Re: CART question ( Stuart Tremain 2004)
  8. Re: CART question ( "Sal D'Anna" 2004)
  9. Re: CART question ( 2004)
  10. CART question ( Patrick J. 2004)
  11. Re: More Shopping Cart Questions/Problems (Brian Boegershausen 2000)
  12. More Shopping Cart Questions/Problems (Brady J. Horenstein 2000)
  13. Re: Cart Question: The Epic Saga (Will Starck 1998)
  14. Re: Cart Question: The Epic Saga (Will Starck 1998)
  15. Re: Cart Question: The Epic Saga (PCS Technical Support 1998)
  16. Re: Cart Question (Kenneth Grome 1998)
  17. Re: Cart Question (PCS Technical Support 1998)
  18. Re: Cart Question (Will Starck 1998)
  19. Re: Cart Question (Kenneth Grome 1998)
  20. Re: Cart Question (Will Starck 1998)
  21. Re: Cart Question (PCS Technical Support 1998)
  22. Re: Cart Question (Bob Minor 1998)
  23. Re: Cart Question (Will Starck 1998)
  24. Re: Cart Question (Kenneth Grome 1998)
  25. Re: Cart Question (Bob Minor 1998)
  26. Re: Cart Question (Bob Minor 1998)
  27. Re: Cart Question (Will Starck 1998)
  28. Re: Cart Question (PCS Technical Support 1998)
  29. Re: Cart Question (Will Starck 1998)
  30. Re: Cart Question (charles kline 1998)
  31. Re: Cart Question (PCS Technical Support 1998)
  32. adding item to cart question (Chris Martin 1998)
  33. RE: Shopping Cart Questions (PCS Technical Support 1998)
  34. RE: Shopping Cart Questions (Pat McCormick 1998)
  35. RE: Shopping Cart Questions (josh 1998)
  36. Re: Shopping Cart Questions (Rob Marquardt 1998)
  37. Shopping Cart Questions (josh 1998)
  38. RE: Shopping Cart Questions (Pat McCormick 1998)
  39. Price lookup problem - was Re: Cart questions (Paul Winchester 1997)
  40. Re: Cart questions (Grant Hulbert 1997)
  41. Re: Cart questions (Grant Hulbert 1997)
  42. Re: Cart questions (Paul Winchester 1997)
  43. Re: Cart questions (Paul Winchester 1997)
  44. Re: Cart questions (Grant Hulbert 1997)
  45. three cart questions (Thomas Wedderburn-Bisshop 1997)
devaulw@onebox.com wrote: > I'm not clear about the limitations of autonumber. Can you elaborate? > I thought autonumber would have been a good choice (relational or not). > Once the number is assigned, that's it. > Am I missing something? > > Bill Yea, its asigned unless the record is deleted. Then that number *could* be asigned to a totaly different record.. in this case a member profile. So if you have an invoice or some other record (in another .db file) that links to that record Id, your going to get the wrong profile (which could be bad). a way around this is to have a database where its only purpose is to create consectutive numbers that never get deleted. Those numbers are then used. ... thus the term "global ID". Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/ Donovan Brooke

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:

WebCatalog2 Feature Feedback (1996) ConvertChars request (1999) Bug? (1997) Multiple Passwords (1997) Emailer setup (1997) [dos] command question (1997) Unknown error: OrderNotCreated (1997) [ShowCart]-- was ThankYou page problems (1997) Not really WebCat (1997) Help name our technology! (1997) Hard Questions ? (1997) flushdatabases (1997) Automated email (2000) [WebDNA] Post-Parse Script to remove extra returns. (2009) creating a ShipCosts database (1997) Calculating multiple shipping... (1997) changing order number (1998) Multiple prices (1997) [UPPERCASE] (1997) SPAM (OT) (2004)