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:
Corruption in images (2004)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
Windows-based Code Editor (2002)
Understanding texta (1997)
Mozilla/4. and Browser Info.txt (1997)
all records returned. (1997)
port 16080 problem (2003)
Convert Chars Q (2000)
emailer (1997)
calendar (2001)
Error Log with Linux? (2000)
Weird problems with [SHOWIF]s (1997)
Not really WebCat (1997)
back button problem (1999)
Date Range Sorting (1997)
A Current Feature or Futre Concept (1998)
Purchased cart being overwritten (1997)
searching numbers (1998)
I give up!! (1997)