Re: From database to email

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23616
interpreted = N
texte = >I'm putting info containing & and into a database using both type=text....> and . I'm using > >[append.........]fieldname=[URL][fieldname][/URL][/append] > >to keep the info from truncating at the & and when I retrieve it using > >[search.....][founditems][fieldname][/founditems][/search]. > >This all works fine. The problem I'm having is when I try to retrieve that >same information and put it into an email: > >[search.....][founditems] >[sendmail....][fieldname1][fieldname2][/sendmail]. >[/founditems][/search] > >The & and that was input with comes out just fine >in [fieldname1], but the & and that was input with comes >out as & and " in [fieldname2]. I've tried >[input][fieldname2][/input] with no luck. Any other ideas?Yes, try: [unurl][fieldname2][/unurl]Sincerely, Ken Grome WebDNA Consultant Associated Messages, from the most recent to the oldest:

    
  1. Re: From database to email (Kenneth Grome 1999)
  2. From database to email (Michael Gribbin 1999)
>I'm putting info containing & and into a database using both type=text....> and . I'm using > >[append.........]fieldname=[url][fieldname][/URL][/append] > >to keep the info from truncating at the & and when I retrieve it using > >[search.....][founditems][fieldname][/founditems][/search]. > >This all works fine. The problem I'm having is when I try to retrieve that >same information and put it into an email: > >[search.....][founditems] >[sendmail....][fieldname1][fieldname2][/sendmail]. >[/founditems][/search] > >The & and that was input with comes out just fine >in [fieldname1], but the & and that was input with comes >out as & and " in [fieldname2]. I've tried >[input][fieldname2][/input] with no luck. Any other ideas?Yes, try: [unurl][fieldname2][/unurl]Sincerely, Ken Grome WebDNA Consultant Kenneth Grome

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:

WebCat2 - [include] tags (1997) Navigator Parsing (1997) Upgrading from 2.1 to 3.0.7 (2000) [cart] not being interpreted inside [founditems] (1997) Using Eudora instead of Emailer, and cron facility (1998) input and accents (2000) Calendar using WebCatalog? (1997) WebCatalog f2 Installation (1997) Signal Raised Error (Part III) (1997) RE: type 2 errors with ssl server (1997) Exclamation point (1997) Test (2001) Format of Required fields error message (1997) Re:Running 2 two WebCatalog.acgi's (1996) [carts] and databases (1997) Limiting user access to .tmpl files (1997) Rollovers (1999) Plugin or CGI or both (1997) [WriteFile] problems (1997) Message Board (2001)