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:
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:
[WebDNA] XML error? (2015)
Press Release hit the NewsWire!!! (1997)
Emailer port change (1997)
Re:Emailer and encryption (1997)
Which GUI HTML editors work with WC ? (1997)
Bug Report, maybe (1997)
Email (1998)
Document Contains No Data! (1997)
Triggers (2001)
Color (1997)
One Hour Email (2002)
WCS Newbie question (1997)
WebTen? (1997)
talk lists down - email question (2002)
Its not that weird. (1997)
WebDNA Developer Resource Center (2002)
[SearchString] problem with [search] context (1997)
Country & Ship-to address & other fields ? (1997)
Caching problem... (2000)
Listfiles path bug ... (2005)