Re: [WebDNA] form data compared to existing database

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112624
interpreted = N
texte = 206 --Apple-Mail=_82E344AC-AFC1-4261-98C6-F3FD9125C6E4 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Stephen: Concatenate de 8 variables and compare Regards, Francisco -- Lic. Francisco A. Hirsch http://www.fiscaldemesa.com.ar > On 15/03/2016, at 15:32, Stephen Braun wrote: >=20 > Hi all, >=20 > I have a simple form to update a database. > There are only eight variables, replacing eight fields in the = database. > I am looking for an easy way to compare the variables from the form to = the db. >=20 > I would like to set a variable to 'no changes' if all the variables = from the form are the same as the ones in the db, > or=20 > I would like to set a variable to 'yes changes' if any one of the 8 = variables are different from any of the corresponding fields in the .db >=20 > I'm looking for a way to do this with out having eight nested [showif] = tags. >=20 > Thanks for any insight. > sfb >=20 >=20 >=20 >=20 >=20 >=20 > Stephen F Braun > sbraun1@twcny.rr.com > --------------------------------------------------------- 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 --Apple-Mail=_82E344AC-AFC1-4261-98C6-F3FD9125C6E4 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
Stephen:
Concatenate de 8 variables and = compare
Regards,
Francisco
--
Lic. Francisco A. Hirsch

On 15/03/2016, at 15:32, Stephen Braun <sbraun1@twcny.rr.com> wrote:

Hi all,

I have a simple = form to update a database.
There are only eight = variables, replacing eight fields in the database.
I am looking for an easy way to compare = the variables from the form to the db.

I would like to set a variable to 'no = changes' if all the variables from the form are the same as the ones in = the db,
or
I would like = to set a variable to 'yes changes' if any one of the 8 variables are = different from any of the corresponding fields in the .db

I'm looking for a way to = do this with out having eight nested [showif] tags.

Thanks for any insight.
sfb






Stephen F Braun
sbraun1@twcny.rr.com
--------------------------------------------------------- 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

= --------------------------------------------------------- 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 --Apple-Mail=_82E344AC-AFC1-4261-98C6-F3FD9125C6E4-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] form data compared to existing database (Terry Wilson 2016)
  2. Re: [WebDNA] form data compared to existing database (Stephen Braun 2016)
  3. Re: [WebDNA] form data compared to existing database (Michael Davis 2016)
  4. Re: [WebDNA] form data compared to existing database ("Steve @ Tailored Web Solutions" 2016)
  5. Re: [WebDNA] form data compared to existing database (Kenneth Grome 2016)
  6. Re: [WebDNA] form data compared to existing database (Francisco Hirsch 2016)
  7. [WebDNA] form data compared to existing database (Stephen Braun 2016)
206 --Apple-Mail=_82E344AC-AFC1-4261-98C6-F3FD9125C6E4 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Stephen: Concatenate de 8 variables and compare Regards, Francisco -- Lic. Francisco A. Hirsch http://www.fiscaldemesa.com.ar > On 15/03/2016, at 15:32, Stephen Braun wrote: >=20 > Hi all, >=20 > I have a simple form to update a database. > There are only eight variables, replacing eight fields in the = database. > I am looking for an easy way to compare the variables from the form to = the db. >=20 > I would like to set a variable to 'no changes' if all the variables = from the form are the same as the ones in the db, > or=20 > I would like to set a variable to 'yes changes' if any one of the 8 = variables are different from any of the corresponding fields in the .db >=20 > I'm looking for a way to do this with out having eight nested [showif] = tags. >=20 > Thanks for any insight. > sfb >=20 >=20 >=20 >=20 >=20 >=20 > Stephen F Braun > sbraun1@twcny.rr.com > --------------------------------------------------------- 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 --Apple-Mail=_82E344AC-AFC1-4261-98C6-F3FD9125C6E4 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
Stephen:
Concatenate de 8 variables and = compare
Regards,
Francisco
--
Lic. Francisco A. Hirsch

On 15/03/2016, at 15:32, Stephen Braun <sbraun1@twcny.rr.com> wrote:

Hi all,

I have a simple = form to update a database.
There are only eight = variables, replacing eight fields in the database.
I am looking for an easy way to compare = the variables from the form to the db.

I would like to set a variable to 'no = changes' if all the variables from the form are the same as the ones in = the db,
or
I would like = to set a variable to 'yes changes' if any one of the 8 variables are = different from any of the corresponding fields in the .db

I'm looking for a way to = do this with out having eight nested [showif] tags.

Thanks for any insight.
sfb






Stephen F Braun
sbraun1@twcny.rr.com
--------------------------------------------------------- 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

= --------------------------------------------------------- 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 --Apple-Mail=_82E344AC-AFC1-4261-98C6-F3FD9125C6E4-- . Francisco Hirsch

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:

Newbie trouble with [url] & [foundItems] (2000) Help! WebCat2 bug (1997) Safari browser and WebDNA set-cookies (2003) checkout.tpl (1999) Content search & results (2008) affiliate marketing program (1998) [ShowIf] a either fields are blank (1998) pc (1997) YACBQ.....(Yet another checkbox question) (2000) Access and WebDNA (2002) form data submission gets truncated (1997) [addlineitems] (1997) [WebDNA] crashes are back (2008) Trouble serving graphics on protected templates (1998) Math (1997) Emailer (WebCat2) (1997) emailer (1997) For those of you not on the WebCatalog Beta... (1997) Smart caching problems with 2.1b3? (1997) Protect Tag and Groups (1998)