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:

WebCAT has the devil in it! (2003) WebCatalog2 Feature Feedback (1996) 2.0 Info (1997) WebCat2 several catalogs? (1997) Emailer prefs in two places ... (1997) It just Does't add up!!! (1997) listing [text] variables? (1999) Grepping spaces (2004) Execute Applescript (1997) Share cost of training videos! (1998) 'does not contain' operator needed ... (1997) Founditems context returning only 1 item (1997) Find one not all, code not working (2003) remotely add + sign (1997) RE: [WebDNA] [OT] the "Work in progress" thread. (2009) serial number dishing (1997) [format 40s]text[/format] doesn't work (1997) Formatting date to number - more (2000) Showif, Hideif reverse logic ? (1997) Okay, I give up... (1999)