Re: [WebDNA] Re: AUTONUMBER in Form

This WebDNA talk-list message is from

2020


It keeps the original formatting.
numero = 115081
interpreted = N
texte = 2710 --0000000000004b76ee05a22feb46 Content-Type: text/plain; charset="UTF-8" tsk, so I will just proceed of using form to throw something inside a SHOWIF [showif [key]=some_value] [append db=my.db&autonumber=seq]name=[url][name][/url][/append] [/showif] Originally, I was employing this code [search ...] [text]NextValue=[math][max field=seq]+1[/math][/text] [/search] Duplicates happen in the SEQ field especially during multi-user sessions. Hope AUTONUMBER solves this problem Thanks On Wed, Apr 1, 2020 at 3:14 AM wrote: > For the middle one: > > > > You can use the 'AUTONUMBER=' parameter with the [append] or [replace] > context to instruct WebDNA to automatically generate the 'next highest > number' value for the given fieldname. This is useful for 'ID' type fields, > where unique values are required. > > > > Example: > > [append db=myDB.db&AUTONUMBER=myAutonumberField]NAME=Scott&EMAIL=scott@here > com[/append] > > > > > > *From: *talk@webdna.us > *Sent: *31 March 2020 20:03 > *To: *talk@webdna.us > *Subject: *RE: [WebDNA] Re: AUTONUMBER in Form > > > > Use a JavaScript fuction on the form, or use Autonumbering via WebDNA when > writing to db, or use [cart]. > > > > Scott > > > > *From: *talk@webdna.us > *Sent: *31 March 2020 12:09 > *To: *talk@webdna.us > *Subject: *[WebDNA] Re: AUTONUMBER in Form > > >
> > > > > >
> > On Tue, Mar 31, 2020 at 7:07 PM Jess Villamor > wrote: > >> how to implement AUTONUMBER in a FORM >> >> this didn't work. >> >> 
>> <form method="POST" action="index.tpl">>> <input type="hidden" name="command" value="Append">>> <input type="hidden" name="db" value="Data.db">>> <input value="autonumber" name="seq">>> <input name="name" value="">>> <input type="submit">>> </form>>>
>> > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=55 Bug Reporting: support@webdna.us > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=55 Bug Reporting: support@webdna.us > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=55 Bug Reporting: support@webdna.us --0000000000004b76ee05a22feb46 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
tsk, so I will just proceed of using form to throw somethi= ng inside a SHOWIF

[showif [key]=3Dsome_value]
[append db=3D= my.db&autonumber=3Dseq]name=3D[url][name][/url][/append]
[/sh= owif]

Originally, I was employing this code

[search ...][text]NextValue=3D[math][max field=3Dseq]+1[/math][/text]
[/search]
Duplicates happen in the SEQ field especially during multi-user sessio= ns. Hope AUTONUMBER solves this problem

Thanks

On Wed, Apr 1, 2020 = at 3:14 AM <talk@webdna.us> wro= te:

For the middle one:

=C2=A0

You can use the 'AUTONUMBER=3D' parameter wi= th the [append] or [replace] context to instruct WebDNA to automatically ge= nerate the 'next highest number' value for the given fieldname. Thi= s is useful for 'ID' type fields, where unique values are required.=C2=A0

=C2=A0

Example:

[append db=3DmyDB.db&AUTONUMBER=3DmyAutonumberFi= eld]NAME=3DScott&EMAIL=3Dscott@here com[/append]

=C2=A0

=C2=A0

From: talk@webdna.us Sent: 31 March 2020 20:03
To: talk@webdna.= us
Subject: RE: [WebDNA] Re: AUTONUMBER in Form

=C2=A0

Use a JavaScript fuction on the form, or use Autonum= bering via WebDNA when writing to db, or use [cart].

=C2=A0

Scott

=C2=A0

From: talk@webdna.us Sent: 31 March 2020 12:09
To: talk@webdna.= us
Subject: [WebDNA] Re: AUTONUMBER in Form

=C2=A0

<form method=3D"POST" action=3D"index.tp= l">
<input type=3D"hidden" name=3D"command" value=3D&quo= t;Append">
<input type=3D"hidden" name=3D"db" value=3D"Dat= a.db">
<input value=3D"autonumber" name=3D"seq">
<input name=3D"name" value=3D"">
<input type=3D"submit">
</form>

On Tue, Mar 31, 2020 at 7:07 PM Jess = Villamor <j= ess.villamor@gmail.com> wrote:
how to implement AUTONUMBER in a FORM

this didn't work.

<pre>
&lt;form method=3D"POST" action=3D"index.tpl"&g= t;
&lt;input type=3D"hidden" name=3D"command" value=3D= "Append"&gt;
&lt;input type=3D"hidden" name=3D"db" value=3D"= ;Data.db"&gt;
&lt;input value=3D"autonumber" name=3D"seq"&gt;=
&lt;input name=3D"name" value=3D""&gt;
&lt;input type=3D"submit"&gt;
&lt;/form&gt;
</pre>
--------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mai= l to: talk-leave@= webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Repo= rting: support@webdna.us
--------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mai= l to: talk-leave@= webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Repo= rting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --0000000000004b76ee05a22feb46-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] AUTONUMBER in Form (Michael Davis 2020)
  2. Re: [WebDNA] AUTONUMBER in Form (Michael Davis 2020)
  3. [WebDNA] AUTONUMBER in Form (Jess Villamor 2020)
2710 --0000000000004b76ee05a22feb46 Content-Type: text/plain; charset="UTF-8" tsk, so I will just proceed of using form to throw something inside a SHOWIF [showif [key]=some_value] [append db=my.db&autonumber=seq]name=[url][name][/url][/append] [/showif] Originally, I was employing this code [search ...] [text]NextValue=[math][max field=seq]+1[/math][/text] [/search] Duplicates happen in the SEQ field especially during multi-user sessions. Hope AUTONUMBER solves this problem Thanks On Wed, Apr 1, 2020 at 3:14 AM wrote: > For the middle one: > > > > You can use the 'AUTONUMBER=' parameter with the [append] or [replace] > context to instruct WebDNA to automatically generate the 'next highest > number' value for the given fieldname. This is useful for 'ID' type fields, > where unique values are required. > > > > Example: > > [append db=myDB.db&AUTONUMBER=myAutonumberField]NAME=Scott&EMAIL=scott@here > com[/append] > > > > > > *From: *talk@webdna.us > *Sent: *31 March 2020 20:03 > *To: *talk@webdna.us > *Subject: *RE: [WebDNA] Re: AUTONUMBER in Form > > > > Use a JavaScript fuction on the form, or use Autonumbering via WebDNA when > writing to db, or use [cart]. > > > > Scott > > > > *From: *talk@webdna.us > *Sent: *31 March 2020 12:09 > *To: *talk@webdna.us > *Subject: *[WebDNA] Re: AUTONUMBER in Form > > >
> > > > > >
> > On Tue, Mar 31, 2020 at 7:07 PM Jess Villamor > wrote: > >> how to implement AUTONUMBER in a FORM >> >> this didn't work. >> >> 
>> <form method="POST" action="index.tpl">>> <input type="hidden" name="command" value="Append">>> <input type="hidden" name="db" value="Data.db">>> <input value="autonumber" name="seq">>> <input name="name" value="">>> <input type="submit">>> </form>>>
>> > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=55 Bug Reporting: support@webdna.us > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=55 Bug Reporting: support@webdna.us > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=55 Bug Reporting: support@webdna.us --0000000000004b76ee05a22feb46 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
tsk, so I will just proceed of using form to throw somethi= ng inside a SHOWIF

[showif [key]=3Dsome_value]
[append db=3D= my.db&autonumber=3Dseq]name=3D[url][name][/url][/append]
[/sh= owif]

Originally, I was employing this code

[search ...][text]NextValue=3D[math][max field=3Dseq]+1[/math][/text]
[/search]
Duplicates happen in the SEQ field especially during multi-user sessio= ns. Hope AUTONUMBER solves this problem

Thanks

On Wed, Apr 1, 2020 = at 3:14 AM <talk@webdna.us> wro= te:

For the middle one:

=C2=A0

You can use the 'AUTONUMBER=3D' parameter wi= th the [append] or [replace] context to instruct WebDNA to automatically ge= nerate the 'next highest number' value for the given fieldname. Thi= s is useful for 'ID' type fields, where unique values are required.=C2=A0

=C2=A0

Example:

[append db=3DmyDB.db&AUTONUMBER=3DmyAutonumberFi= eld]NAME=3DScott&EMAIL=3Dscott@here com[/append]

=C2=A0

=C2=A0

From: talk@webdna.us Sent: 31 March 2020 20:03
To: talk@webdna.= us
Subject: RE: [WebDNA] Re: AUTONUMBER in Form

=C2=A0

Use a JavaScript fuction on the form, or use Autonum= bering via WebDNA when writing to db, or use [cart].

=C2=A0

Scott

=C2=A0

From: talk@webdna.us Sent: 31 March 2020 12:09
To: talk@webdna.= us
Subject: [WebDNA] Re: AUTONUMBER in Form

=C2=A0

<form method=3D"POST" action=3D"index.tp= l">
<input type=3D"hidden" name=3D"command" value=3D&quo= t;Append">
<input type=3D"hidden" name=3D"db" value=3D"Dat= a.db">
<input value=3D"autonumber" name=3D"seq">
<input name=3D"name" value=3D"">
<input type=3D"submit">
</form>

On Tue, Mar 31, 2020 at 7:07 PM Jess = Villamor <j= ess.villamor@gmail.com> wrote:
how to implement AUTONUMBER in a FORM

this didn't work.

<pre>
&lt;form method=3D"POST" action=3D"index.tpl"&g= t;
&lt;input type=3D"hidden" name=3D"command" value=3D= "Append"&gt;
&lt;input type=3D"hidden" name=3D"db" value=3D"= ;Data.db"&gt;
&lt;input value=3D"autonumber" name=3D"seq"&gt;=
&lt;input name=3D"name" value=3D""&gt;
&lt;input type=3D"submit"&gt;
&lt;/form&gt;
</pre>
--------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mai= l to: talk-leave@= webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Repo= rting: support@webdna.us
--------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mai= l to: talk-leave@= webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Repo= rting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --0000000000004b76ee05a22feb46-- . Jess Villamor

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:

Summing fields (1997) RE: WebCatalog2 for NT Beta Request (1997) Test (2003) .. more on sliding discounts... (1997) Error: Error: expected [/APPLICATION] ??? (1998) WebCatalog for Postcards ? (1997) Help name our technology! (1997) Bug Report, maybe (1997) taxTotal (1997) problems with 2 tags (1997) question: Eudora 3.1.1 (1997) DataBaseHelper Flawed (1997) Not really WebCat (1997) WebCatalog for Postcards ? (1997) WC2b15 File Corruption (1997) Emailer port change (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) [Sum] function? (1997) [GetMIMEHeader] does not work (under Linux?) (2000) Limiting user access to .tmpl files (1997)