Re: searching illegal HTML
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44398
interpreted = N
texte = About the searchI think my search is workinghttp://www.iconoplus.com/Index.tpl?action=powersearchdo you think your method would gives better result> > &waGroup1datarq=[URL][field1][/URL]> > This assumes the fields were [url]'d when the were appended to the db ..> > Oh - and you can search on the same field twice in the same search .. You'll> need to do a search that is nested inside the first search. The way below is> the way I would get around this .. There are other ways> > [!] Do the initial search here [/!]> > [text]sku_array=[/text]> > [search db=admin/image.db[!]> [/!]&waKEYdatarq=[url][field1][/url][!]> [/!]&woORIENTdatarq=[Orient][!]> [/!]&startat=[startat][!]> [/!]&MAX=[MAX][!]> [/!]&asDOSSIER_EDITEURsort=1[!]> [/!]&asSKUsort=2]> > [!] create a temporary array of the records that math [/!]> > [founditems]> [text]sku_array=[sku_array]+[sku][/text]> [/founditems]> [/search]> > [search db=admin/image.db[!]> [/!]&woSKUdatarq=[sku_array][!]> [/!]&SKUwbrk=+[!]> [/!]&SKUword=ww[!]> [/!]&wnKEYdatarq=[URL][field2][/URL]]> > [founditems]> > Here are the results that math> > [/founditems]> [/search]> > HTH> Alain> > > > > >> 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>> >> Thank for help>> >> Lawrence>> >> >> ------------------------------------------------------------->> 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/> > > -------------------------------------------------------------> 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/-------------------------------------------------------------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:
About the searchI think my search is workinghttp://www.iconoplus.com/Index.tpl?action=powersearchdo you think your method would gives better result> > &waGroup1datarq=[url][field1][/URL]> > This assumes the fields were [url]'d when the were appended to the db ..> > Oh - and you can search on the same field twice in the same search .. You'll> need to do a search that is nested inside the first search. The way below is> the way I would get around this .. There are other ways> > [!] Do the initial search here [/!]> > [text]sku_array=[/text]> > [search db=admin/image.db[!]> [/!]&waKEYdatarq=[url][field1][/url][!]> [/!]&woORIENTdatarq=[Orient][!]> [/!]&startat=[startat][!]> [/!]&MAX=[MAX][!]> [/!]&asDOSSIER_EDITEURsort=1[!]> [/!]&asSKUsort=2]> > [!] create a temporary array of the records that math [/!]> > [founditems]> [text]sku_array=[sku_array]+[sku][/text]> [/founditems]> [/search]> > [search db=admin/image.db[!]> [/!]&woSKUdatarq=[sku_array][!]> [/!]&SKUwbrk=+[!]> [/!]&SKUword=ww[!]> [/!]&wnKEYdatarq=[url][field2][/URL]]> > [founditems]> > Here are the results that math> > [/founditems]> [/search]> > HTH> Alain> > > > > >> 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>> >> Thank for help>> >> Lawrence>> >> >> ------------------------------------------------------------->> 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/> > > -------------------------------------------------------------> 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/-------------------------------------------------------------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/
lb Lawrence
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:
Support ?? (1997)
Plugin or CGI or both (1997)
New Title (2003)
Help name our technology! (1997)
$purchase WITHOUT creditcar (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
[shownext max=?] armed (1997)
Request Time Out (1997)
Error.html (1997)
Appending with +1 ... (1997)
F3 crashing server (1997)
Ampersand (1997)
Variables for chat (1997)
Suddenly can't see files... (2000)
encrypted database (2004)
Been meaning to ask... (1997)
[WebDNA] unix timestamp in WebDNA (2009)
Search context not finding recent entries (1998)
serial number generation (1997)
Proper file locations (1997)