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:
ShowNext (1997)
[WebDNA] [WSC] WebDNA Development Summit (2014)
Linux/webcat points (2000)
WCS Newbie question (1997)
japanese characters (1997)
MacFinder -- a new WebDNA web site (1998)
[include ...] behavior (1997)
multi-paragraph fields (1997)
WebDNA 5.0 Questions (2003)
Webten + Webcat running smooth (1998)
suggestions for a Windows based text editor? (2004)
Physical Security for WebCatalog Directories (1997)
Pithy questions on webcommerce & siteedit (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Big Databases (1997)
off topic, converting mail (1998)
More Cookies (2002)
Emailer (WebCat2) (1997)
Head's up to SMSI ... (2003)
WebDNA deletes major DB data big time (2004)