Re: searching illegal HTML
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44407
interpreted = N
texte = 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 ------------------------------------------------------------- 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:
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 ------------------------------------------------------------- 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/
Michael 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:
help on brickwalls (2003)
Server Problem (2004)
Sendmail problem on UNIX (2000)
shopcost, unitshipcost (2002)
Problems searching from a FORM (1997)
trouble updating records in database (1998)
Converting characters to numbers ... (1997)
Running _every_ page through WebCat-error.html (1997)
Shared Webstar Directory (1998)
WebCatalog stalls (1998)
Using Cookie for client specific info? (1997)
WebCat 5 (2003)
Locking up with WebCatalog... (1997)
creating writefile data from a nested search (1997)
synching databases on multiple servers (1997)
A Global Variable (1997)
[Announce] WebCatalog 3.0 Beta Program (1998)
Bug Report, maybe (1997)
Multiple Pulldowns (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)