Re: Populating a db from a form textarea

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61868
interpreted = N
texte = Put the append inside the listwords and that will perform the multiple appends you need. Bill -----Original Message----- From: Gary Krockover Sent: Tue, 26 Apr 2005 16:16:11 -0500 To: "WebDNA Talk" Subject: Re: Populating a db from a form textarea 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/ ------------------------------------------------------------- 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:

    
  1. Re: Populating a db from a form textarea ( devaulw@onebox.com 2005)
  2. Re: Populating a db from a form textarea ( Gary Krockover 2005)
  3. Re: Populating a db from a form textarea ( devaulw@onebox.com 2005)
  4. Re: Populating a db from a form textarea ( devaulw@onebox.com 2005)
  5. Populating a db from a form textarea ( Gary Krockover 2005)
Put the append inside the listwords and that will perform the multiple appends you need. Bill -----Original Message----- From: Gary Krockover Sent: Tue, 26 Apr 2005 16:16:11 -0500 To: "WebDNA Talk" Subject: Re: Populating a db from a form textarea 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/ ------------------------------------------------------------- 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/ devaulw@onebox.com

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:

[SMSI] WebDNA is too good to go away! (2006) [WebDNA] Base 64 (2010) WC2.0 Memory Requirements (1997) New WebDNA Forum Solution (in development) (2003) Problem (1997) [protect] on NT? (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) More DateMath problems (1997) unusual search problem (1998) Sku numbers (1997) hierarchy question... (2000) Quitting WebMerchant ? (1997) Malformed Pages (1999) [protect] on NT? (1997) WebCatalog 4 Install Problems (2000) [WebDNA] Abandoned Carts (2009) Custom Shipping Charges (1997) Location of Browser Info.txt file (1997) Showing once on a founditems (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997)