Re: [WebDNA] [thisautonumber] and [lastautonumber]

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 106588
interpreted = N
texte = This is a multi-part message in MIME format. --------------060700060104080602080907 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I actually discovered the autonumber feature relatively recently (how did I miss this before?). [lastautonumber] and [thisautonumber] are only available inside of the [append] context, so a code should look something like this.. [append db=your.db&autonumber=IDfield]var1=[var1]&var2=[var3][text]lastID=[lastAutonumber][/text][/append] autonumbers are generated as simple numerical increments of 1 - the first record will be given a value of "1", the next "2", and so on. If you need to create record IDs in a custom format, I don't think this will work. On 4/28/11 3:21 PM, Steve Raslevich -Northern Sound & Light wrote: > Hi, > > Can anyone give me a sample of the syntax on how to use > [thisautonumber] and/or [lastautonumber] to assign it to a text or > math variable? I want to [append] to a db using "autonumber" and then > use that same autonumber within a replace further down my template. > > All I found in the online documentation was this: > > You can use [thisautonumber] tag from within an [append] or [replace] > context, to retrieve the current auto-generated number (if the > AUTONUMBER parameter was used). > > > > Is the code below safe to use with a heavily appended database? > > [append db=../../data/sku.db&autonumber=SEQNUM][formvariables > name=_&exact=F][getchars > start=2][name][/getchars]=[url][value][/url]&[/formvariables][/append] > [text]_sku=[lastautonumber][/text] > > Thanks, > Steve > --------------------------------------------------------- This message > is sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: > support@webdna.us --------------060700060104080602080907 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit I actually discovered the autonumber feature relatively recently (how did I miss this before?).  [lastautonumber] and [thisautonumber] are only available inside of the [append] context, so a code should look something like this..

[append db=your.db&autonumber=IDfield]var1=[var1]&var2=[var3][text]lastID=[lastAutonumber][/text][/append]

autonumbers are generated as simple numerical increments of 1 - the first record will be given a value of "1", the next "2", and so on.  If you need to create record IDs in a custom format, I don't think this will work. 



On 4/28/11 3:21 PM, Steve Raslevich -Northern Sound & Light wrote:
Hi,

Can anyone give me a sample of the syntax on how to use [thisautonumber] and/or [lastautonumber] to assign it to a text or math variable? I want to [append] to a db using "autonumber" and then use that same autonumber within a replace further down my template.

All I found in the online documentation was this:

You can use [thisautonumber] tag from within an [append] or [replace] context, to retrieve the current auto-generated number (if the AUTONUMBER parameter was used).



Is the code below safe to use with a heavily appended database?

[append db=../../data/sku.db&autonumber=SEQNUM][formvariables name=_&exact=F][getchars start=2][name][/getchars]=[url][value][/url]&[/formvariables][/append]
[text]_sku=[lastautonumber][/text]

Thanks,
Steve
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------060700060104080602080907-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [thisautonumber] and [lastautonumber] (Steve Raslevich -Northern Sound 2011)
  2. Re: [WebDNA] [thisautonumber] and [lastautonumber] (Brian Fries 2011)
  3. Re: [WebDNA] [thisautonumber] and [lastautonumber] (Steve Raslevich - Northern Sound 2011)
  4. Re: [WebDNA] [thisautonumber] and [lastautonumber] (Aaron Michael Kaczmarek 2011)
  5. [WebDNA] [thisautonumber] and [lastautonumber] (Steve Raslevich -Northern Sound 2011)
This is a multi-part message in MIME format. --------------060700060104080602080907 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I actually discovered the autonumber feature relatively recently (how did I miss this before?). [lastautonumber] and [thisautonumber] are only available inside of the [append] context, so a code should look something like this.. [append db=your.db&autonumber=IDfield]var1=[var1]&var2=[var3][text]lastID=[lastautonumber][/text][/append] autonumbers are generated as simple numerical increments of 1 - the first record will be given a value of "1", the next "2", and so on. If you need to create record IDs in a custom format, I don't think this will work. On 4/28/11 3:21 PM, Steve Raslevich -Northern Sound & Light wrote: > Hi, > > Can anyone give me a sample of the syntax on how to use > [thisautonumber] and/or [lastautonumber] to assign it to a text or > math variable? I want to [append] to a db using "autonumber" and then > use that same autonumber within a replace further down my template. > > All I found in the online documentation was this: > > You can use [thisautonumber] tag from within an [append] or [replace] > context, to retrieve the current auto-generated number (if the > AUTONUMBER parameter was used). > > > > Is the code below safe to use with a heavily appended database? > > [append db=../../data/sku.db&autonumber=SEQNUM][formvariables > name=_&exact=F][getchars > start=2][name][/getchars]=[url][value][/url]&[/formvariables][/append] > [text]_sku=[lastautonumber][/text] > > Thanks, > Steve > --------------------------------------------------------- This message > is sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: > support@webdna.us --------------060700060104080602080907 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit I actually discovered the autonumber feature relatively recently (how did I miss this before?).  [lastautonumber] and [thisautonumber] are only available inside of the [append] context, so a code should look something like this..

[append db=your.db&autonumber=IDfield]var1=[var1]&var2=[var3][text]lastID=[lastautonumber][/text][/append]

autonumbers are generated as simple numerical increments of 1 - the first record will be given a value of "1", the next "2", and so on.  If you need to create record IDs in a custom format, I don't think this will work. 



On 4/28/11 3:21 PM, Steve Raslevich -Northern Sound & Light wrote:
Hi,

Can anyone give me a sample of the syntax on how to use [thisautonumber] and/or [lastautonumber] to assign it to a text or math variable? I want to [append] to a db using "autonumber" and then use that same autonumber within a replace further down my template.

All I found in the online documentation was this:

You can use [thisautonumber] tag from within an [append] or [replace] context, to retrieve the current auto-generated number (if the AUTONUMBER parameter was used).



Is the code below safe to use with a heavily appended database?

[append db=../../data/sku.db&autonumber=SEQNUM][formvariables name=_&exact=F][getchars start=2][name][/getchars]=[url][value][/url]&[/formvariables][/append]
[text]_sku=[lastautonumber][/text]

Thanks,
Steve
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------060700060104080602080907-- Aaron Michael Kaczmarek

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:

b12 cannot limit records returned and more. (1997) UPDATE PROBLEM (1997) Rephrased: Web Site Stats (2002) Country & Ship-to address & other fields ? (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) WebCat2: Found Items syntax, etc. (1997) Delete file through browser (1999) Multiple SSL Keys (1998) Multiple catalog databases and showcart (1997) Redirect frame targets (1998) Format question (2001) Eudora Plugin (1999) textarea text truncated by browser (2000) Generating Report Totals (1997) RE:It just Does't add up!!! (1997) suggestion (1997) international time (1997) Defualt folder locations (2004) HTTP Header / Meta Equiv (1999) [interpret] inside the db field? (1997)