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:

[WebDNA] First-timer feedback (2014) tcpconnect feature request .. (2003) search form problem.. (1997) Need relative path explanation (1997) Fixed: 2cd pair of eyes please. (2003) MacFinder -- a new WebDNA web site (1998) Verisign is at it again (2003) 2.0Beta Command Ref (can't find this instruction) (1997) Stumpted Again (1997) Rhapsody? (1997) SKU (1997) Closing Databases (1998) Negative number search (2000) Relay link (2002) shownext problems (1998) Unix line endings (2003) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Separate SSL Server (1997) Problem with [CART] number (1998) Null Chars (1999)