Re: [WebDNA] form data compared to existing database

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112644
interpreted = N
texte = 227 --Apple-Mail=_913A67B1-A6D3-4FF4-9A76-92FD3E015C09 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii I know you said you wanted to avoid show ifs. But how about lookups? = That's supposed to be faster. In fact, it would be better, as it will = detect if someone is making a change in capitalization. I use this = technique in an instance where I want to pass through the change, which = would otherwise show no change if checked with a show if. Terry W On Mar 16, 2016, at 11:41 AM, Stephen Braun = wrote: > Thanks Michael, > I know how to write a javascript to recognize the onchange event, but = I don't know how javascript would set a [text] variable in WebDNA. > Is this even possible? >=20 > thanks, > sfb >=20 >=20 > Stephen F Braun > sbraun1@twcny.rr.com >=20 > On Wed, Mar 16, 2016 at 2:09 PM, Michael Davis = wrote: > You could also use javascript and set a variable based on onchange = events, if you're strictly looking for a way to flag if any input values = have been changed. >=20 >=20 >> On Mar 15, 2016, at 12:40 PM, Steve @ Tailored Web Solutions = wrote: >>=20 >> I would like to know if my users hit submit on the form with making = changes >> or >> I would like to know if my users hit submit on the form without = making any changes >>=20 >>=20 >> Stephen Braun >> Tailored Web Solutions >> steve@tailoredwebsolutions.net >> www.tailoredwebsolutions.com >> 315.343.1744 >>=20 >> On Tue, Mar 15, 2016 at 3:23 PM, Kenneth Grome = wrote: >> > 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 ... >>=20 >> What's the point? Just replace them all every time and you'll get >> the same result. >>=20 >> Regards, >> Kenneth Grome >> WebDNA Solutions >> http://www.webdnasolutions.com >> Web Database Systems and Linux Server Administration >>=20 >> --------------------------------------------------------- >> 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 >>=20 >> --------------------------------------------------------- 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 >=20 > --------------------------------------------------------- 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 >=20 > --------------------------------------------------------- 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=_913A67B1-A6D3-4FF4-9A76-92FD3E015C09 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii I = know you said you wanted to avoid show ifs. But how about lookups? = That's supposed to be faster. In fact, it would be better, as it will = detect if someone is making a change in capitalization. I use this = technique in an instance where I want to pass through the change, which = would otherwise show no change if checked with a show = if.

Terry W


On Mar 16, = 2016, at 11:41 AM, Stephen Braun <sbraun1@twcny.rr.com> = wrote:

Thanks = Michael,
I know how to write a javascript to recognize the = onchange event,  but I don't know how javascript would set a [text] = variable in WebDNA.
Is this even = possible?

thanks,
sfb


Stephen F = Braun
sbraun1@twcny.rr.com

On Wed, Mar 16, 2016 at 2:09 PM, Michael = Davis <admin@network13.net> = wrote:
You could also use javascript and set a = variable based on onchange events, if you're strictly looking for a way = to flag if any input values have been = changed.


On Mar 15, 2016, at 12:40 PM, Steve @ Tailored Web = Solutions <steve@tailoredwebsolutions.net> = wrote:

I would like to know if my users hit submit on the form = with making changes
or
I would like to know if my users hit = submit on the form without making any changes


Stephen Braun
Tailored Web = Solutions
steve@tailoredwebsolutions.net
www.tailoredwebsolutions.com
315.343.1744

On Tue, Mar 15, 2016 at 3:23 PM, Kenneth = Grome <ken@webdnasolutions.com> = wrote:
> 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 = ....

What's the point?  Just replace them all every time and you'll = get
the same result.

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database Systems and Linux Server Administration

---------------------------------------------------------
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>

--------------------------------------------------------- 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

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/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=_913A67B1-A6D3-4FF4-9A76-92FD3E015C09-- . 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)
227 --Apple-Mail=_913A67B1-A6D3-4FF4-9A76-92FD3E015C09 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii I know you said you wanted to avoid show ifs. But how about lookups? = That's supposed to be faster. In fact, it would be better, as it will = detect if someone is making a change in capitalization. I use this = technique in an instance where I want to pass through the change, which = would otherwise show no change if checked with a show if. Terry W On Mar 16, 2016, at 11:41 AM, Stephen Braun = wrote: > Thanks Michael, > I know how to write a javascript to recognize the onchange event, but = I don't know how javascript would set a [text] variable in WebDNA. > Is this even possible? >=20 > thanks, > sfb >=20 >=20 > Stephen F Braun > sbraun1@twcny.rr.com >=20 > On Wed, Mar 16, 2016 at 2:09 PM, Michael Davis = wrote: > You could also use javascript and set a variable based on onchange = events, if you're strictly looking for a way to flag if any input values = have been changed. >=20 >=20 >> On Mar 15, 2016, at 12:40 PM, Steve @ Tailored Web Solutions = wrote: >>=20 >> I would like to know if my users hit submit on the form with making = changes >> or >> I would like to know if my users hit submit on the form without = making any changes >>=20 >>=20 >> Stephen Braun >> Tailored Web Solutions >> steve@tailoredwebsolutions.net >> www.tailoredwebsolutions.com >> 315.343.1744 >>=20 >> On Tue, Mar 15, 2016 at 3:23 PM, Kenneth Grome = wrote: >> > 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 ... >>=20 >> What's the point? Just replace them all every time and you'll get >> the same result. >>=20 >> Regards, >> Kenneth Grome >> WebDNA Solutions >> http://www.webdnasolutions.com >> Web Database Systems and Linux Server Administration >>=20 >> --------------------------------------------------------- >> 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 >>=20 >> --------------------------------------------------------- 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 >=20 > --------------------------------------------------------- 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 >=20 > --------------------------------------------------------- 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=_913A67B1-A6D3-4FF4-9A76-92FD3E015C09 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii I = know you said you wanted to avoid show ifs. But how about lookups? = That's supposed to be faster. In fact, it would be better, as it will = detect if someone is making a change in capitalization. I use this = technique in an instance where I want to pass through the change, which = would otherwise show no change if checked with a show = if.

Terry W


On Mar 16, = 2016, at 11:41 AM, Stephen Braun <sbraun1@twcny.rr.com> = wrote:

Thanks = Michael,
I know how to write a javascript to recognize the = onchange event,  but I don't know how javascript would set a [text] = variable in WebDNA.
Is this even = possible?

thanks,
sfb


Stephen F = Braun
sbraun1@twcny.rr.com

On Wed, Mar 16, 2016 at 2:09 PM, Michael = Davis <admin@network13.net> = wrote:
You could also use javascript and set a = variable based on onchange events, if you're strictly looking for a way = to flag if any input values have been = changed.


On Mar 15, 2016, at 12:40 PM, Steve @ Tailored Web = Solutions <steve@tailoredwebsolutions.net> = wrote:

I would like to know if my users hit submit on the form = with making changes
or
I would like to know if my users hit = submit on the form without making any changes


Stephen Braun
Tailored Web = Solutions
steve@tailoredwebsolutions.net
www.tailoredwebsolutions.com
315.343.1744

On Tue, Mar 15, 2016 at 3:23 PM, Kenneth = Grome <ken@webdnasolutions.com> = wrote:
> 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 = ....

What's the point?  Just replace them all every time and you'll = get
the same result.

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database Systems and Linux Server Administration

---------------------------------------------------------
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>

--------------------------------------------------------- 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

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/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=_913A67B1-A6D3-4FF4-9A76-92FD3E015C09-- . Terry Wilson

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:

Access Denied! But why? (1997) Any one heard from SM since that last email? (2006) pop up menu's (1998) Emails sent twice (2000) Trouble with Netscape (1998) [DOS]/DOS query - A SOLUTION (2003) [WebDNA] showif/sendmail question (2008) Archives... (1997) [OT] Bookmarking code (2003) latest version? (1998) Webstar 1.3.1 PPC (1997) Quitting WebMerchant ? (1997) WebMerchant 1.6 and SHTML (1997) [search] in formulas.db (1997) Nested Loops and SHOWIFs (1997) Error Messages Returned to User (1997) Multiple Ad databases? (1997) AUTONUMBER (2003) Need help!! on searching in two databases. (1998) Separate SSL Server (1997)