Re: searching illegal HTML
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44395
interpreted = N
texte = If the values in the databases are [url]'d you will need to [url] the fieldsyou are searching for ..&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'llneed to do a search that is nested inside the first search. The way below isthe 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]HTHAlain> 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/
Associated Messages, from the most recent to the oldest:
If the values in the databases are [url]'d you will need to [url] the fieldsyou are searching for ..&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'llneed to do a search that is nested inside the first search. The way below isthe 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]HTHAlain> 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/
Alain Russell
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:
New command suggestion (1997)
Somewhat OT: IE issues (2002)
OFF-TOPIC: Free webdna.net email addresses ... (2003)
REPOST: [numfound] within summ=t (2000)
[WebDNA] Ubuntu 10.4 & WebDNA 6.2 (2011)
encrypt (2000)
Formulas.db (1997)
Re:quit command on NT (1997)
Sandbox Prefs (2003)
Digest Version (2000)
Search results templates (1996)
Help name our technology! (1997)
What am I missing (1997)
Uh...can someone help me out with the b10? (1997)
[authenticate] (1999)
Serving Images from SSL (was NT vs Mac) (1997)
price formula (1999)
problem: mail changed (1997)
emptying shopping carts and orders folder (2004)
Re:listfiles-looking for slick solution (1997)