Re: Changing user submitted data
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28052
interpreted = N
texte = At 10:16 AM -0600 2000/02/25, nospam wrote:>Here is my problem I need to change some text that a user submits into a data base. I know this is possible because when you send an email to the talk list, when smithmicro archives it on search.smithmicro.com the words like Webcatalog are changed into links. So anyway how is this done?>>P.S. I know this is possible in applescript but I need a webcat solution>In your form completion routine, just change it. I use:>[showif [action]=Append]>[replace db=../db/Roster.db&eqSKUdatarq=[url][_sku][/url]&append=T][!]>[/!]&HPhone=[include file=../Includes/-NormalizePhone&var1=[_HPhone]][!] Home>[/!]&EPhone=[include file=../Includes/-NormalizePhone&var1=[_EPhone]][!] Work>[/!]&[ListWords Words=[_BigBrother]][showif [index]=1]BigBrother=[word][/showif][/ListWords][!]>[/!]&[formvariables name=_&exact=F][getchars start=2][name][/getchars]=[url][value][/url]&[/formvariables][/replace]>
Record Added>[commitdatabase db=../db/Roster.db]>[/showif]The [include file=../Includes/-NormalizePhone&var1=[_HPhone]]routine converts all phone numbers to a common format since everyoneenters them differently. -Chuck-__________________________________________________________________________Chuck Rice
-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
At 10:16 AM -0600 2000/02/25, nospam wrote:>Here is my problem I need to change some text that a user submits into a data base. I know this is possible because when you send an email to the Talk List, when smithmicro archives it on search.smithmicro.com the words like Webcatalog are changed into links. So anyway how is this done?>>P.S. I know this is possible in applescript but I need a webcat solution>In your form completion routine, just change it. I use:>[showif [action]=Append]>[replace db=../db/Roster.db&eqSKUdatarq=[url][_sku][/url]&append=T][!]>[/!]&HPhone=[include file=../Includes/-NormalizePhone&var1=[_HPhone]][!] Home>[/!]&EPhone=[include file=../Includes/-NormalizePhone&var1=[_EPhone]][!] Work>[/!]&[ListWords Words=[_BigBrother]][showif [index]=1]BigBrother=[word][/showif][/ListWords][!]>[/!]&[formvariables name=_&exact=F][getchars start=2][name][/getchars]=[url][value][/url]&[/formvariables][/replace]>Record Added
>[commitdatabase db=../db/Roster.db]>[/showif]The [include file=../Includes/-NormalizePhone&var1=[_HPhone]]routine converts all phone numbers to a common format since everyoneenters them differently. -Chuck-__________________________________________________________________________Chuck Rice -------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Chuck Rice
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:
multiple prices (1998)
[OT] md5 or sha-1 on OSX (2007)
Passing form variables to new window created by JavaScript (2001)
Nesting format tags (1997)
Help name our technology! I found it (1997)
Problems getting parameters passed into email. (1997)
WebCat2b15MacPlugin - [protect] (1997)
trouble updating records in database (1998)
docs for WebCatalog2 (1997)
Internet Explorer and caching (2000)
NT Woes (1997)
no time stamp & different times from emailer (1998)
WebCat and search engines (1998)
[BoldWords] WebCat.acgib15Mac (1997)
Format all of a sudden doesn't work (1997)
HomePage Caution (1997)
Multiple prices (1997)
SSL and Webcat Authentication with IIS 5.0 on Win2K box (2000)
Word Break (1999)
Search all Fields in a db (1997)