Ampersand is breaking search context

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22703
interpreted = N
texte = Hello, I'm still having trouble understanding what exactly is happening when an & (ampersand) is in a db field. I have a db that has sku,type,artist, and title as it's field names. I do a search for an sku to find a unique product: [search db=Catalog.db&eqskudata=250980211&cart=2999507845187] [founditems]Which brings up a product listing. Within that founditems loop, I do another search to find matching [artist] and [title] records with different [sku] numbers:[search db=Catalog.db&eqArtistdatarq=[Artist]&eqTitledatarq=[Title]]This product is available in the following product types:
[founditems] [sku], [type]
[/founditems][/search] [/founditems] [/search]This works fine and finds the matching records until an ampersand is present in the [artist] field for that record. The inner search then finds no matches. If I update the database by substituting the word and for the ampersand, the search works again. If I wrap the [Artist] and [Title] in a [url] context, like: [search db=Catalog.db&eqArtistdatarq=[url][Artist][/url]&eqTitledatarq=[url][Title][ /url]] The search still finds no match. The really baffling thing is, the ampersand is in the [Artist] field and yet if I leave the [Artist] criteria out of the search: [search db=Catalog.db&eqTitledatarq=[Title]] (with or without the [url] wrap) The search still finds no match. Again, if I remove the ampersand from the [Artist] field of the database and use the above search, it finds the matching records, even though I am not using the [Artist] field as part of the search. I have read through the talklist archive and have seen discussion that it is usually the browser that has difficulty with the ampersand but this is happening strictly within *contexts* so the browser has no part in it.So, How do I A: Properly create a form that allows a user to enter a name like Meyer & Frank into a text field that will be appended to my database, and B: Properly construct a search like the above to then find the record that contains the ampersand character.Is there a comprehensive discussion on this subject somewhere in the documentation? If not, I think it would be a welcome addition, considering how many records come up on the subject when searching the talklist archive. Thanks, Mike Davis Associated Messages, from the most recent to the oldest:

    
  1. Re: Ampersand is breaking search context (Mike_Davis 1999)
  2. Re: Ampersand is breaking search context (Kenneth Grome 1999)
  3. Ampersand is breaking search context (Mike_Davis 1999)
Hello, I'm still having trouble understanding what exactly is happening when an & (ampersand) is in a db field. I have a db that has sku,type,artist, and title as it's field names. I do a search for an sku to find a unique product: [search db=Catalog.db&eqskudata=250980211&cart=2999507845187] [founditems]Which brings up a product listing. Within that founditems loop, I do another search to find matching [artist] and [title] records with different [sku] numbers:[search db=Catalog.db&eqArtistdatarq=[Artist]&eqTitledatarq=[Title]]This product is available in the following product types:
[founditems] [sku], [type]
[/founditems][/search] [/founditems] [/search]This works fine and finds the matching records until an ampersand is present in the [artist] field for that record. The inner search then finds no matches. If I update the database by substituting the word and for the ampersand, the search works again. If I wrap the [Artist] and [Title] in a [url] context, like: [search db=Catalog.db&eqArtistdatarq=[url][Artist][/url]&eqTitledatarq=[url][Title][ /url]] The search still finds no match. The really baffling thing is, the ampersand is in the [Artist] field and yet if I leave the [Artist] criteria out of the search: [search db=Catalog.db&eqTitledatarq=[Title]] (with or without the [url] wrap) The search still finds no match. Again, if I remove the ampersand from the [Artist] field of the database and use the above search, it finds the matching records, even though I am not using the [Artist] field as part of the search. I have read through the talklist archive and have seen discussion that it is usually the browser that has difficulty with the ampersand but this is happening strictly within *contexts* so the browser has no part in it.So, How do I A: Properly create a form that allows a user to enter a name like Meyer & Frank into a text field that will be appended to my database, and B: Properly construct a search like the above to then find the record that contains the ampersand character.Is there a comprehensive discussion on this subject somewhere in the documentation? If not, I think it would be a welcome addition, considering how many records come up on the subject when searching the talklist archive. Thanks, Mike Davis Mike_Davis

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:

Location of Browser Info.txt file (1997) [WebDNA] PDF's on the fly from a webdna database (2009) authorizenet (2001) TemplateCacheSize preference! (1998) Snake Bites (1997) Error 11 (1996) Nested tags count question (1997) Do .tpls A Max File Size? (1998) [WebDNA] WebDNA as cgi app (was WebSite Examples) (2008) [WebDNA] Ubuntu 11.10 (2012) WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) [input] .... [/input] usage (2005) Credit back woes (2000) RE: File Uploads (1998) formulas.db problem solved (1998) Some Questions (1997) Limiting user access to .tmpl files (1997) Pre-flight public flag (1997) line endings for Mac OS X files? (2003)