Re: Populating a db from a form textarea
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61867
interpreted = N
texte = Thanks Bill, I think that's a piece of the puzzle, but perhaps I didn't explain the situation properly. I'm wanting to take the list that comes from a single textarea, and have it populate a database in the format of: SKU
ADDRESSSENT 1tom@jones.com 2tom2@jones.com 3tom3@jones.com etc... Where those email addresses are just fictitious, it depends on what the client pastes into the textarea in the format of: tom1@jones.com tom2@jones.com tom3@jones.com etc... So, on my append, this just puts all the addresses under a single SKU: [append db=email_list.db][!] [/!]SKU=[math]Newsku=([Search db=email_list.db&neSKUdatarq=[blank]&deSKUsort=1&SKUtype=num&max=1][FoundItems][SKU][/FoundItems][/Search]+1)[/math][!] [/!]&ADDRESS=[listwords words=[ADDRESS]&delimiters= ,%0B][ADDRESS][/listwords][!] [/!]&SENT=[!] [/!][/append] As in: 1 tom1@jones.comtom2@jones.comtom3@jones.cometc.... I think I'm going to need a combination of formvariables and listwords to get that list formatted properly. Any ideas (anybody)? GJK At 12:56 PM 4/26/2005, you wrote: >I pulled a snippet I've used. I forgot that sometimes users enter commas >and line breaks. You might add a semicolon as well, just in case. > >[listwords words=[inputfromtextarea]&delimiters= ,%0B][/listwords] > >Bill ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thanks Bill, I think that's a piece of the puzzle, but perhaps I didn't explain the situation properly. I'm wanting to take the list that comes from a single textarea, and have it populate a database in the format of: SKUADDRESSSENT 1tom@jones.com 2tom2@jones.com 3tom3@jones.com etc... Where those email addresses are just fictitious, it depends on what the client pastes into the textarea in the format of: tom1@jones.com tom2@jones.com tom3@jones.com etc... So, on my append, this just puts all the addresses under a single SKU: [append db=email_list.db][!] [/!]SKU=[math]Newsku=([Search db=email_list.db&neSKUdatarq=[blank]&deSKUsort=1&SKUtype=num&max=1][founditems][SKU][/FoundItems][/Search]+1)[/math][!] [/!]&ADDRESS=[listwords words=[ADDRESS]&delimiters= ,%0B][ADDRESS][/listwords][!] [/!]&SENT=[!] [/!][/append] As in: 1 tom1@jones.comtom2@jones.comtom3@jones.cometc.... I think I'm going to need a combination of formvariables and listwords to get that list formatted properly. Any ideas (anybody)? GJK At 12:56 PM 4/26/2005, you wrote: >I pulled a snippet I've used. I forgot that sometimes users enter commas >and line breaks. You might add a semicolon as well, just in case. > >[listwords words=[inputfromtextarea]&delimiters= ,%0B][/listwords] > >Bill ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Gary Krockover
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:
Quickie question on the email templates (1997)
OT - quiet on the list today - here's something (2004)
(thx) automating a POST (2002)
[WebDNA] Apache or Nginx (2016)
Bug alert! (1997)
WC 2.0 frames feature (1997)
Hiding HTML and breaking the page (1997)
RE: webcat error log (1998)
Copyright ? (1997)
emailer cc to figured out (1997)
webcat (2000)
Re2: frames & carts (1997)
WebCatalog Technical Reference (1997)
Can you 'swap' 2 items in the same field? (2001)
WebCat2 - Getting to the browser's username/password data (1997)
Protect (1997)
Return records from another (1997)
no global [username] or [password] displayed ... (1997)
Sami (1998)
Date search - yes or no (1997)