Re: searching illegal HTML
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44425
interpreted = N
texte = see below...At 4:09 PM 10/25/02, Michael Davis wrote: >On Friday, October 25, 2002, at 12:23 PM, lb Lawrence wrote: > >>Hi, >> >>I have been going round and round with this problem. >> >>I have to search a db that have illegal HTML in the fields to search >> >>like bébé Thaïlande athléte >> >>I have tried >> >>[search db=admin/image.db[!] >>[/!]&group1field=KEY[!] >>[/!]&waGroup1datarq=[UnURL][field1][/UnURL][!] >>[/!]&group2field=KEY[!] >>[/!]&wnGroup2datarq=[UnURL][field2][/UnURL][!] >>[/!]&group3field=Orient[!] >>[/!]&woGroup3datarq=[Orient][!] >>[/!]&startat=[startat][!] >>[/!]&MAX=[MAX][!] >>[/!]&asDOSSIER_EDITEURsort=1[!] >>[/!]&asSKUsort=2] >> >>I thought [UnURL] would fix my problem but nothing is working >> > >Do not use [unurl]. > >Problems with your search that I see... You are using grouping >without actually grouping any fields. You are also comparing the >same field more than once in the same search. The first problem may >work just fine, but is not necessary. The second problem will >absolutely break your search context. You cannot do two comparisons >on the KEY field like that. If you are saying KEY word-and = >field1, then use a [hideif [url][KEY][/url]=[url][field2][/url]] >within the [founditems] instead of the second KEY word-not field >comparison. > >Mike >Actually the method above does work in general and is specifically designed to allow you to search the same field two times.While you cannot say waKEYdatarq=XX YY ZZ&wnKEYdatarq=YY, as these both search a key field term named KEY, you can assign the field KEY to two different groups then search each group, thus effectively searching the same field twice.So, searching group1field=KEY&waGroup1datarq=XX YY ZZ&group2field=KEY&wnGroup2datarq=YY will work as designed.My question on this whole search problem, then, is what are the values of [field1] and [field2]? Are they contradicting each other?Based on the wa / wn logic being applied to KEY, if [field2] contains a value that is not contained in [field1], then no results will be returned.Lawrence... Can you show us the values of [field1] and [field2]?- brian -- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- 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:
see below...At 4:09 PM 10/25/02, Michael Davis wrote: >On Friday, October 25, 2002, at 12:23 PM, lb Lawrence wrote: > >>Hi, >> >>I have been going round and round with this problem. >> >>I have to search a db that have illegal HTML in the fields to search >> >>like bébé Thaïlande athléte >> >>I have tried >> >>[search db=admin/image.db[!] >>[/!]&group1field=KEY[!] >>[/!]&waGroup1datarq=[unurl][field1][/UnURL][!] >>[/!]&group2field=KEY[!] >>[/!]&wnGroup2datarq=[unurl][field2][/UnURL][!] >>[/!]&group3field=Orient[!] >>[/!]&woGroup3datarq=[Orient][!] >>[/!]&startat=[startat][!] >>[/!]&MAX=[MAX][!] >>[/!]&asDOSSIER_EDITEURsort=1[!] >>[/!]&asSKUsort=2] >> >>I thought [unurl] would fix my problem but nothing is working >> > >Do not use [unurl]. > >Problems with your search that I see... You are using grouping >without actually grouping any fields. You are also comparing the >same field more than once in the same search. The first problem may >work just fine, but is not necessary. The second problem will >absolutely break your search context. You cannot do two comparisons >on the KEY field like that. If you are saying KEY word-and = >field1, then use a [hideif [url][KEY][/url]=[url][field2][/url]] >within the [founditems] instead of the second KEY word-not field >comparison. > >Mike >Actually the method above does work in general and is specifically designed to allow you to search the same field two times.While you cannot say waKEYdatarq=XX YY ZZ&wnKEYdatarq=YY, as these both search a key field term named KEY, you can assign the field KEY to two different groups then search each group, thus effectively searching the same field twice.So, searching group1field=KEY&waGroup1datarq=XX YY ZZ&group2field=KEY&wnGroup2datarq=YY will work as designed.My question on this whole search problem, then, is what are the values of [field1] and [field2]? Are they contradicting each other?Based on the wa / wn logic being applied to KEY, if [field2] contains a value that is not contained in [field1], then no results will be returned.Lawrence... Can you show us the values of [field1] and [field2]?- brian -- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- 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 Fries
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:
[/application] error? (1997)
requiring form fields? (2000)
[ShowIf] and empty fields (1997)
PCS Frames (1997)
Frames and WebCat (1997)
Showing unopened cart (1997)
How to pass from a detail page to another? (1998)
OFF-TOPIC: No messages since Saturday (1998)
[OT] Dedicated Image Uploader/Server [/OT] (2003)
generate sequential numbers (2000)
Multiple servers and Webcat (1998)
docs for WebCatalog2 (1997)
WCS Newbie question (1997)
download database (2000)
MacAutorize and T1 (1998)
CT Scan might have saved my life!! (2006)
Clear command and ShoppingCart.tmpl (1997)
Emailer setup (1997)
Deleting Orders (1997)
WebCat2 several catalogs? (1997)