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:
LookUp Tag (1997)
Practice runs ? (1997)
Is there a way to just get to the last record in the database? (1997)
WCS Newbie question (1997)
& not allowed in db by definition? (1999)
NetSplat and WebCat2 (1997)
Loops N Variables (1998)
Shipping DB (1999)
I try hard to think positively (1998)
unable to launch acgi in WebCat (1997)
Email (1998)
WILDWEBCAT encrypt.tpl submission (1998)
wrong input values? (1997)
[WebDNA] XML vars from Flash (2009)
Custom Shipping Charges (1997)
Security (1998)
[OT] Who's got a cool link (2002)
Grep Help (2003)
Country & Ship-to address & other fields ? (1997)
Running _every_ page through WebCat ? (1997)