A [Loop][APPEND][URL] ... [/URL][/APPEND]/Loop] Question

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 31907
interpreted = N
texte = Hi All,I'm using WebCAT 3.0.8 in the Mac. I'm entering the following text string into a database: Andy & Vicky PerezThis text is passed via a form variable.Using [Convertchars] in the code below, the only thing entered into the database would be the text Andy (without the quotes) and everything else would be cut off. I arrived at the following code after a lot of experimenting with the [ConvertChars] tag. On a whim I threw the [URL] tag in what you see below.[showif [action]=Append][loop start=1&end=8&advance=1] [Showif [Interpret][_owner[index]][/Interpret]!] [Append db=^capitolracing/owners/owners.db]OWNER_NAME=[URL][Interpret][_owner[index]][/Interpret][/URL][/Append] [/Showif] [/loop][/showif]When I look at the database in a text editor the entry is: Andy & Vicky Perez (Great, thats what I want) Not: Andy%20%26%201Vicky%20PerezI'm curious though...why does this work this way? Why doesn't the string Andy%20%26%201Vicky%20Perez get input into the database?Putting this [URL][Interpret][_owner[index]][/Interpret][/URL] outside the [Append] context but still inside the loop displays the following: Andy%20%26%201Vicky%20PerezPutting this [Interpret][_owner[index]][/Interpret] outside the [Append] context but still inside the loop displays the following: Andy & 1Vicky PerezHowever, if I use [Interpret][_owner[index]][/Interpret] inside the [Append] without the [URL] tags around it, the data going into the database gets cut off at the ampersand. I double checked the docs, but I must have missed something. Can anyone shed any light on this? I'm glad its working the way I want, but I don't understand why. Whenever that happens, I know something unexpected will come and haunt me later on.Thanks for your time and have a great day!Brian Digital Gear Is there some other way I should enter ampersands into a database?------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: A [Loop][APPEND][URL] ... [/URL][/APPEND]/Loop] Question (Brian Wallace 2000)
  2. Re: A [Loop][APPEND][URL] ... [/URL][/APPEND]/Loop] Question (Mike Davis 2000)
  3. A [Loop][APPEND][URL] ... [/URL][/APPEND]/Loop] Question (Brian Wallace 2000)
Hi All,I'm using WebCAT 3.0.8 in the Mac. I'm entering the following text string into a database: Andy & Vicky PerezThis text is passed via a form variable.Using [convertchars] in the code below, the only thing entered into the database would be the text Andy (without the quotes) and everything else would be cut off. I arrived at the following code after a lot of experimenting with the [convertchars] tag. On a whim I threw the [url] tag in what you see below.[showif [action]=Append][loop start=1&end=8&advance=1] [Showif [interpret][_owner[index]][/Interpret]!] [Append db=^capitolracing/owners/owners.db]OWNER_NAME=[url][interpret][_owner[index]][/Interpret][/URL][/Append] [/Showif] [/loop][/showif]When I look at the database in a text editor the entry is: Andy & Vicky Perez (Great, thats what I want) Not: Andy%20%26%201Vicky%20PerezI'm curious though...why does this work this way? Why doesn't the string Andy%20%26%201Vicky%20Perez get input into the database?Putting this [url][interpret][_owner[index]][/Interpret][/URL] outside the [append] context but still inside the loop displays the following: Andy%20%26%201Vicky%20PerezPutting this [interpret][_owner[index]][/Interpret] outside the [append] context but still inside the loop displays the following: Andy & 1Vicky PerezHowever, if I use [interpret][_owner[index]][/Interpret] inside the [append] without the [url] tags around it, the data going into the database gets cut off at the ampersand. I double checked the docs, but I must have missed something. Can anyone shed any light on this? I'm glad its working the way I want, but I don't understand why. Whenever that happens, I know something unexpected will come and haunt me later on.Thanks for your time and have a great day!Brian Digital Gear Is there some other way I should enter ampersands into a database?------------------------------------------------------------- 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://search.smithmicro.com/ Brian Wallace

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:

calculating tax rates, mail order solutions and version 2 (1997) New Guy (2000) href name= link from dynamic URL possible? (1998) WebCat with WebTen (1998) Bug Report, maybe (1997) Country & Ship-to address & other fields ? (1997) Problem with webcat install (1998) Re(2): Append command (1999) Set Line Item (1999) WebCat2.0 acgi vs plugin (1997) RequiredFields notes ... (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Smith Micro - no competition (2000) taxTotal confusion (1998) How is it done? (1998) Strange intermittent WebDNA problems (2008) I'm tired of all this! (2000) Reload of the shoppingcart.tmpl page (1999) mac os HOG? (2001) Error.html (1997)