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:

WebCatalog can't find database (1997) different show next (1997) [lookup] speed sales pitch (2003) Hiding HTML and page breaks (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) triggers have stopped once again (2002) WebCat3.04/w*4/OS8.5.1 and aliases (1999) WCS Newbie question (1997) default error on NT? (1997) Nesting WebDNA in JavaScript (2003) File upload (2002) WebCat2b12 - nesting [tags] (1997) Strange intermittent WebDNA problems Workaround (2008) Multiple fields on 1 input (1997) corrupted images (2002) WC 2.0 frames feature (1997) [addlineitems] (1997) Nested vs conditional (1997) [WebDNA] Small Parsing Problem (2009) WebCat2b15MacPlugin - showing [math] (1997)