Re: Autonumber

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50962
interpreted = N
texte = I look forward to the next release :)On Friday, June 6, 2003, at 06:49 PM, Scott Anderson wrote:> We added a [lastautonumber] tag to the upcoming 5.1 build (Thank Nitai > for > the idea). This will give you the last auto-generated number for the > last > append or replace context where the AUTONUMBER parameter was used (in > the > current thread). We also added a [thisautonumber] tag for the append > and > replace context that will return the current auto-generated number for > the > current append/replace action (again, if the AUTONUMBER parameter was > used). > The 5.1 builds should be available by the end of next week. For now, > you > will need to do a search, with a descending sort on the SKU field, and > have > a max return of 1, to get the last SKU number generated. > >> -----Original Message----- >> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of >> Stuart Tremain >> Sent: Friday, June 06, 2003 1:01 AM >> To: WebDNA Talk >> Subject: Autonumber >> >> >> Hi >> >> When using AutoNumber >> >> [Append db=my.db&AutoNumber=SKU]name=stuart&country=Australia[/Append] >> >> Would I then have to do a search to get that number if I >> wanted to get >> that record back immediately ? >> >> Or is there a trick ? >> >> eg >> >> [Append db=my.db&AutoNumber=SKU]name=stuart&country=Australia[/Append] >> >> [Lookup >> db=my.db&Value=******AutoNumber******&Lookinfield=SKU&Returnfi >> eld=name] >> >> How can I carry the value into the lookup ? >> >> Do I have to do this? >> >> [Search >> db=my.db&eqNAMEdatarq=Stuart&eqCOUNTRYdatarq=Australia][FoundI >> tems][SKU] >> [/FoundItems][/Search] >> >> >> >> Regards >> >> Stuart Tremain >> idfk web developments >> 114a/40 yeo street neutral bay 2089 australia >> t +612 9908 2134 >> f +612 9908 4837 >> >> >> ------------------------------------------------------------- >> 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/ > > > ------------------------------------------------------------- > 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/ > > RegardsStuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- 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: [WebDNA] Re: AUTONUMBER in Form (Jess Villamor 2020)
  2. RE: [WebDNA] Re: AUTONUMBER in Form ("Scott @ Itsula" 2020)
  3. Re: [WebDNA] AUTONUMBER in Form (Michael Davis 2020)
  4. RE: [WebDNA] Re: AUTONUMBER in Form ("Scott @ Itsula" 2020)
  5. Re: [WebDNA] AUTONUMBER in Form (Michael Davis 2020)
  6. [WebDNA] Re: AUTONUMBER in Form (Jess Villamor 2020)
  7. [WebDNA] AUTONUMBER in Form (Jess Villamor 2020)
  8. Re: [WebDNA] thisAutonumber? (Kenneth Grome 2011)
  9. Re: [WebDNA] thisAutonumber? (Donovan Brooke 2011)
  10. Re: [WebDNA] thisAutonumber? (Kenneth Grome 2011)
  11. Re: [WebDNA] thisAutonumber? (Kenneth Grome 2011)
  12. Re: [WebDNA] thisAutonumber? (Steve Raslevich 2011)
  13. Re: [WebDNA] thisAutonumber? (Paul Willis 2011)
  14. Re: [WebDNA] thisAutonumber? (Steve Raslevich 2011)
  15. Re: [WebDNA] thisAutonumber? (Steve Raslevich 2011)
  16. [WebDNA] thisAutonumber? (Kenneth Grome 2011)
  17. Re: [WebDNA] [thisautonumber] and [lastautonumber] (Steve Raslevich -Northern Sound 2011)
  18. Re: [WebDNA] [thisautonumber] and [lastautonumber] (Brian Fries 2011)
  19. Re: [WebDNA] [thisautonumber] and [lastautonumber] (Steve Raslevich - Northern Sound 2011)
  20. Re: [WebDNA] [thisautonumber] and [lastautonumber] (Aaron Michael Kaczmarek 2011)
  21. [WebDNA] [thisautonumber] and [lastautonumber] (Steve Raslevich -Northern Sound 2011)
  22. Re: [WebDNA] When was autonumber added? (Kenneth Grome 2010)
  23. Re: [WebDNA] When was autonumber added? (Stuart Tremain 2010)
  24. [WebDNA] When was autonumber added? (Kenneth Grome 2010)
  25. Re: [WebDNA] Query re: autonumber (Govinda 2010)
  26. Re: [WebDNA] Query re: autonumber (Tom Duke 2010)
  27. Re: [WebDNA] Query re: autonumber (Kenneth Grome 2010)
  28. Re: [WebDNA] Query re: autonumber (Govinda 2010)
  29. Re: [WebDNA] Query re: autonumber (Govinda 2010)
  30. Re: [WebDNA] Query re: autonumber (Kenneth Grome 2010)
  31. Re: [WebDNA] Query re: autonumber (Tom Duke 2010)
  32. Re: [WebDNA] Query re: autonumber (Kenneth Grome 2010)
  33. [WebDNA] Query re: autonumber (Tom Duke 2010)
  34. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Tom Duke 2010)
  35. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
  36. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
  37. Re: [WebDNA] autonumber duplication, time stamp issue & ("Terry Wilson" 2010)
  38. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Govinda 2010)
  39. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
  40. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
  41. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Dale Therio 2010)
  42. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Govinda 2010)
  43. [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
  44. Re: [WebDNA] How high will autonumber go? (Dan Strong 2009)
  45. [WebDNA] How high will autonumber go? (Kenneth Grome 2009)
  46. Re: Autonumber in Table ( Stuart Tremain 2006)
  47. Re: Autonumber in Table ( devaulw@onebox.com 2006)
  48. Autonumber in Table ( Stuart Tremain 2006)
  49. Example for adding an autonumber field to a database ( William DeVaul 2006)
  50. Limitation of AUTONUMBER ( Stuart Tremain 2005)
  51. Re: Lastautonumber ( Donovan Brooke 2005)
  52. Re: Lastautonumber ( "Nitai @ ComputerOil" 2005)
  53. Re: Lastautonumber ( Donovan Brooke 2005)
  54. Re: Lastautonumber ( "Nitai @ ComputerOil" 2005)
  55. Re: Lastautonumber ( Stuart Tremain 2005)
  56. Re: Lastautonumber ( Donovan Brooke 2005)
  57. Re: Lastautonumber ( Gary Krockover 2005)
  58. Re: Lastautonumber ( Donovan Brooke 2005)
  59. Re: Lastautonumber ( Donovan Brooke 2005)
  60. Re: Lastautonumber ( Gary Krockover 2005)
  61. Lastautonumber ( Donovan Brooke 2005)
  62. Feature Request: Autonumber adendum ( Donovan Brooke 2004)
  63. Re: AutoNumber not working ( Tim Robinson 2004)
  64. AutoNumber not working ( Phil Marshall 2004)
  65. Re: AUTONUMBER ( Tim Robinson 2004)
  66. Re: AUTONUMBER ( Donovan Brooke 2003)
  67. Re: AUTONUMBER ( Marc Kaiwi 2003)
  68. AUTONUMBER ( Donovan Brooke 2003)
  69. Re: Autonumber ( "Nitai @ ComputerOil" 2003)
  70. Autonumber ( Tim Robinson 2003)
  71. Re: Replace and Autonumber ( Donovan Brooke 2003)
  72. Replace and Autonumber ( Donovan Brooke 2003)
  73. Re: Autonumber Work-Around (Gary Krockover 2003)
  74. Autonumber Work-Around (Justin Carroll 2003)
  75. Re: Webcat 4.5.1 equivalent of autonumber (Alan White 2003)
  76. Re: Webcat 4.5.1 equivalent of autonumber (Donovan 2003)
  77. Re: Webcat 4.5.1 equivalent of autonumber (Brian Boegershausen 2003)
  78. Webcat 4.5.1 equivalent of autonumber (Alan White 2003)
  79. Re: ThisAutoNumber (Stuart Tremain 2003)
  80. Re: ThisAutoNumber (Nitai @ ComputerOil 2003)
  81. Re: ThisAutoNumber (Stuart Tremain 2003)
  82. Re: ThisAutoNumber (Alain Russell 2003)
  83. ThisAutoNumber (Stuart Tremain 2003)
  84. Re: Autonumber (Stuart Tremain 2003)
  85. Re: Autonumber (Scott Anderson 2003)
  86. Autonumber (Stuart Tremain 2003)
  87. Re: AUTONUMBER (Ron Ceballos 2003)
  88. AUTONUMBER (Ron Ceballos 2003)
  89. [lastautonumber] ( disp)
I look forward to the next release :)On Friday, June 6, 2003, at 06:49 PM, Scott Anderson wrote:> We added a [lastautonumber] tag to the upcoming 5.1 build (Thank Nitai > for > the idea). This will give you the last auto-generated number for the > last > append or replace context where the AUTONUMBER parameter was used (in > the > current thread). We also added a [thisautonumber] tag for the append > and > replace context that will return the current auto-generated number for > the > current append/replace action (again, if the AUTONUMBER parameter was > used). > The 5.1 builds should be available by the end of next week. For now, > you > will need to do a search, with a descending sort on the SKU field, and > have > a max return of 1, to get the last SKU number generated. > >> -----Original Message----- >> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of >> Stuart Tremain >> Sent: Friday, June 06, 2003 1:01 AM >> To: WebDNA Talk >> Subject: Autonumber >> >> >> Hi >> >> When using AutoNumber >> >> [Append db=my.db&AutoNumber=SKU]name=stuart&country=Australia[/Append] >> >> Would I then have to do a search to get that number if I >> wanted to get >> that record back immediately ? >> >> Or is there a trick ? >> >> eg >> >> [Append db=my.db&AutoNumber=SKU]name=stuart&country=Australia[/Append] >> >> [Lookup >> db=my.db&Value=******AutoNumber******&Lookinfield=SKU&Returnfi >> eld=name] >> >> How can I carry the value into the lookup ? >> >> Do I have to do this? >> >> [Search >> db=my.db&eqNAMEdatarq=Stuart&eqCOUNTRYdatarq=Australia][FoundI >> tems][SKU] >> [/FoundItems][/Search] >> >> >> >> Regards >> >> Stuart Tremain >> idfk web developments >> 114a/40 yeo street neutral bay 2089 australia >> t +612 9908 2134 >> f +612 9908 4837 >> >> >> ------------------------------------------------------------- >> 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/ > > > ------------------------------------------------------------- > 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/ > > RegardsStuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- 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/ Stuart Tremain

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:

Car Database (2002) Further on formula.db failure to calculate shipCost (1997) Multithreading of [replace] (1999) Document Contains No Data msg (1997) RE: Automatic thumbnail images (1998) It just Does't add up!!! (1997) Multiply prices (1997) Summary search -- speed (1997) WebTEN vs webSTAR (1998) [WebDNA] WebDNA Newbie Questions (2008) Need relative path explanation (1997) Emailer setup (1997) Cart questions (1997) ISP needed (2002) Discounts (1998) NT - Thanks and Taxes (1997) WebCatalogCtl (2003) Huge databases and RAM (1998) Small problem (2001) multiple search commands (1997)