RE: [WebDNA] Re: AUTONUMBER in Form

This WebDNA talk-list message is from

2020


It keeps the original formatting.
numero = 115080
interpreted = N
texte = 2709 --_000_LNXP123MB178540A8385DDD0AA58225C281C80LNXP123MB1785GBRP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable For the middle one: You can use the 'AUTONUMBER=3D' parameter with the [append] or [replace] co= ntext 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=3DmyDB.db&AUTONUMBER=3DmyAutonumberField]NAME=3DScott&EMAIL=3Dsc= ott@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=3D"POST" action=3D"index.tpl"><input type=3D"hidden" name=3D"command" value=3D"Append"><input type=3D"hidden" name=3D"db" value=3D"Data.db"><input value=3D"autonumber" name=3D"seq"><input name=3D"name" value=3D""><input type=3D"submit"></form>
--------------------------------------------------------- This message is s= ent 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.u= s/page.dna?numero=3D55 Bug Reporting: support@webdna.us --------------------------------------------------------- This message is s= ent 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.u= s/page.dna?numero=3D55 Bug Reporting: support@webdna.us --_000_LNXP123MB178540A8385DDD0AA58225C281C80LNXP123MB1785GBRP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

For the middle one:

 

You can use the 'AUTONUMBER=3D' parameter with the [= append] or [replace] context to instruct WebDNA to automatically generate t= he 'next highest number' value for the given fieldname. This is useful for = 'ID' type fields, where unique values are required. 

 

Example:

[append db=3DmyDB.db&AUTONUMBER=3DmyAutonumberFi= eld]NAME=3DScott&EMAIL=3Dscott@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 Autonum= bering 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

 

<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 <jess.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-mail to: talk-leave@webdna.us archives: http://www.webdna.u= s/page.dna?numero=3D55 Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is s= ent 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.u= s/page.dna?numero=3D55 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=3D55 Bug Reporting: support@webdna.us --_000_LNXP123MB178540A8385DDD0AA58225C281C80LNXP123MB1785GBRP_-- . 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)
2709 --_000_LNXP123MB178540A8385DDD0AA58225C281C80LNXP123MB1785GBRP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable For the middle one: You can use the 'AUTONUMBER=3D' parameter with the [append] or [replace] co= ntext 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=3DmyDB.db&AUTONUMBER=3DmyAutonumberField]NAME=3DScott&EMAIL=3Dsc= ott@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=3D"POST" action=3D"index.tpl"><input type=3D"hidden" name=3D"command" value=3D"Append"><input type=3D"hidden" name=3D"db" value=3D"Data.db"><input value=3D"autonumber" name=3D"seq"><input name=3D"name" value=3D""><input type=3D"submit"></form>
--------------------------------------------------------- This message is s= ent 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.u= s/page.dna?numero=3D55 Bug Reporting: support@webdna.us --------------------------------------------------------- This message is s= ent 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.u= s/page.dna?numero=3D55 Bug Reporting: support@webdna.us --_000_LNXP123MB178540A8385DDD0AA58225C281C80LNXP123MB1785GBRP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

For the middle one:

 

You can use the 'AUTONUMBER=3D' parameter with the [= append] or [replace] context to instruct WebDNA to automatically generate t= he 'next highest number' value for the given fieldname. This is useful for = 'ID' type fields, where unique values are required. 

 

Example:

[append db=3DmyDB.db&AUTONUMBER=3DmyAutonumberFi= eld]NAME=3DScott&EMAIL=3Dscott@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 Autonum= bering 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

 

<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 <jess.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-mail to: talk-leave@webdna.us archives: http://www.webdna.u= s/page.dna?numero=3D55 Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is s= ent 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.u= s/page.dna?numero=3D55 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=3D55 Bug Reporting: support@webdna.us --_000_LNXP123MB178540A8385DDD0AA58225C281C80LNXP123MB1785GBRP_-- . "Scott @ Itsula"

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:

PCS Frames (1997) WC2.0 Memory Requirements (1997) WebCat2 - Getting to the browser's username/password data (1997) Server crashes and triggers . . . are they linked? (2001) Initiating NewCart (1997) Autonumber in Table (2006) Annoying character on writefile... (2004) Problems with [Applescript] (1997) Thanks ! (1997) Simple Database close connection (2001) [SearchString] usage (1997) [sendmail] on NT? (1997) Squares instead of spaces (2001) [random] only for 1-100??? (1997) randomness (1997) select multiple (1997) [ShowNext] feature in 2.0 (1997) WebDNA module - Automated database archiving (1997) Fwd: Problems with Webcatalog Plug-in (1997) [url] link (1998)