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:

Bug Report, maybe (1997) ' add to cart ' or ' sku ' problem (1998) [input] [/input] (1997) 4.5 Upgrade (2003) NT vs Mac (1997) too many nested [xxx] (1997) Error Log.db --however (1997) shipcost (1997) PLEASE REMOVE MY EMAIL ADDRESS (1997) PSC recommends what date format yr 2000??? (1997) TeaRoom Order fields email account remain empty even thoughthewy are filled. (1997) WebCommerce: Folder organization ? (1997) [index] (1997) Mac: [ListFiles] bug alert (1997) WebDelivery downloads alias, not original ? (1997) [WebDNA] PCI fubar (2012) Simple Page (2000) [WebDNA] Pretty URLS (2011) WebTen? (1997) The List is Changing (1997)