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 Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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:
|
- Re: [WebDNA] Re: AUTONUMBER in Form (Jess Villamor 2020)
- RE: [WebDNA] Re: AUTONUMBER in Form ("Scott @ Itsula" 2020)
- Re: [WebDNA] AUTONUMBER in Form (Michael Davis 2020)
- RE: [WebDNA] Re: AUTONUMBER in Form ("Scott @ Itsula" 2020)
- Re: [WebDNA] AUTONUMBER in Form (Michael Davis 2020)
- [WebDNA] Re: AUTONUMBER in Form (Jess Villamor 2020)
- [WebDNA] AUTONUMBER in Form (Jess Villamor 2020)
- Re: [WebDNA] thisAutonumber? (Kenneth Grome 2011)
- Re: [WebDNA] thisAutonumber? (Donovan Brooke 2011)
- Re: [WebDNA] thisAutonumber? (Kenneth Grome 2011)
- Re: [WebDNA] thisAutonumber? (Kenneth Grome 2011)
- Re: [WebDNA] thisAutonumber? (Steve Raslevich 2011)
- Re: [WebDNA] thisAutonumber? (Paul Willis 2011)
- Re: [WebDNA] thisAutonumber? (Steve Raslevich 2011)
- Re: [WebDNA] thisAutonumber? (Steve Raslevich 2011)
- [WebDNA] thisAutonumber? (Kenneth Grome 2011)
- Re: [WebDNA] [thisautonumber] and [lastautonumber] (Steve Raslevich -Northern Sound 2011)
- Re: [WebDNA] [thisautonumber] and [lastautonumber] (Brian Fries 2011)
- Re: [WebDNA] [thisautonumber] and [lastautonumber] (Steve Raslevich - Northern Sound 2011)
- Re: [WebDNA] [thisautonumber] and [lastautonumber] (Aaron Michael Kaczmarek 2011)
- [WebDNA] [thisautonumber] and [lastautonumber] (Steve Raslevich -Northern Sound 2011)
- Re: [WebDNA] When was autonumber added? (Kenneth Grome 2010)
- Re: [WebDNA] When was autonumber added? (Stuart Tremain 2010)
- [WebDNA] When was autonumber added? (Kenneth Grome 2010)
- Re: [WebDNA] Query re: autonumber (Govinda 2010)
- Re: [WebDNA] Query re: autonumber (Tom Duke 2010)
- Re: [WebDNA] Query re: autonumber (Kenneth Grome 2010)
- Re: [WebDNA] Query re: autonumber (Govinda 2010)
- Re: [WebDNA] Query re: autonumber (Govinda 2010)
- Re: [WebDNA] Query re: autonumber (Kenneth Grome 2010)
- Re: [WebDNA] Query re: autonumber (Tom Duke 2010)
- Re: [WebDNA] Query re: autonumber (Kenneth Grome 2010)
- [WebDNA] Query re: autonumber (Tom Duke 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Tom Duke 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & ("Terry Wilson" 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Govinda 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Dale Therio 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Govinda 2010)
- [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
- Re: [WebDNA] How high will autonumber go? (Dan Strong 2009)
- [WebDNA] How high will autonumber go? (Kenneth Grome 2009)
- Re: Autonumber in Table ( Stuart Tremain 2006)
- Re: Autonumber in Table ( devaulw@onebox.com 2006)
- Autonumber in Table ( Stuart Tremain 2006)
- Example for adding an autonumber field to a database ( William DeVaul 2006)
- Limitation of AUTONUMBER ( Stuart Tremain 2005)
- Re: Lastautonumber ( Donovan Brooke 2005)
- Re: Lastautonumber ( "Nitai @ ComputerOil" 2005)
- Re: Lastautonumber ( Donovan Brooke 2005)
- Re: Lastautonumber ( "Nitai @ ComputerOil" 2005)
- Re: Lastautonumber ( Stuart Tremain 2005)
- Re: Lastautonumber ( Donovan Brooke 2005)
- Re: Lastautonumber ( Gary Krockover 2005)
- Re: Lastautonumber ( Donovan Brooke 2005)
- Re: Lastautonumber ( Donovan Brooke 2005)
- Re: Lastautonumber ( Gary Krockover 2005)
- Lastautonumber ( Donovan Brooke 2005)
- Feature Request: Autonumber adendum ( Donovan Brooke 2004)
- Re: AutoNumber not working ( Tim Robinson 2004)
- AutoNumber not working ( Phil Marshall 2004)
- Re: AUTONUMBER ( Tim Robinson 2004)
- Re: AUTONUMBER ( Donovan Brooke 2003)
- Re: AUTONUMBER ( Marc Kaiwi 2003)
- AUTONUMBER ( Donovan Brooke 2003)
- Re: Autonumber ( "Nitai @ ComputerOil" 2003)
- Autonumber ( Tim Robinson 2003)
- Re: Replace and Autonumber ( Donovan Brooke 2003)
- Replace and Autonumber ( Donovan Brooke 2003)
- Re: Autonumber Work-Around (Gary Krockover 2003)
- Autonumber Work-Around (Justin Carroll 2003)
- Re: Webcat 4.5.1 equivalent of autonumber (Alan White 2003)
- Re: Webcat 4.5.1 equivalent of autonumber (Donovan 2003)
- Re: Webcat 4.5.1 equivalent of autonumber (Brian Boegershausen 2003)
- Webcat 4.5.1 equivalent of autonumber (Alan White 2003)
- Re: ThisAutoNumber (Stuart Tremain 2003)
- Re: ThisAutoNumber (Nitai @ ComputerOil 2003)
- Re: ThisAutoNumber (Stuart Tremain 2003)
- Re: ThisAutoNumber (Alain Russell 2003)
- ThisAutoNumber (Stuart Tremain 2003)
- Re: Autonumber (Stuart Tremain 2003)
- Re: Autonumber (Scott Anderson 2003)
- Autonumber (Stuart Tremain 2003)
- Re: AUTONUMBER (Ron Ceballos 2003)
- AUTONUMBER (Ron Ceballos 2003)
- [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 Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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)