Re: searching illegal HTML
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44399
interpreted = N
texte = You can do two different comparisons on the same field in webdna.Ie .. [search db=some.db&waFIELDdatarq=1&wnFIELDdatarq=2] is not valid ..You could replace the fields in the db using [replacefounditems][search db=the.db&neSKUdata=find_all] [replacefounditems]KEY=[url][key][/url][/replacefounditems] [/search]As a rule pretty much everyhting needs to be [url]'d when going into a db. > About the search > I think my search is working > http://www.iconoplus.com/Index.tpl?action=powersearch > do 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/ ------------------------------------------------------------- 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:
You can do two different comparisons on the same field in webdna.Ie .. [search db=some.db&waFIELDdatarq=1&wnFIELDdatarq=2] is not valid ..You could replace the fields in the db using [replacefounditems][search db=the.db&neSKUdata=find_all] [replacefounditems]KEY=[url][key][/url][/replacefounditems] [/search]As a rule pretty much everyhting needs to be [url]'d when going into a db. > About the search > I think my search is working > http://www.iconoplus.com/Index.tpl?action=powersearch > do 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/ ------------------------------------------------------------- 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:
WebCat2 Append problem (B14Macacgi) (1997)
OT: Where to turn (2003)
GuestBook example (1997)
[replace] has protection feature like [delete]? (2000)
A few questions. . . (1997)
Developer Edition - Connection Limit (2006)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Verifying and adding new users (1997)
Showif Context combined with Search (1997)
multiple price line in formula.db (2004)
Multi Actions (1999)
migrating from MacOS to unix [drifting off-topic] (2000)
2.0.1 new commands and contexts (1997)
dates as search criteria (2000)
about this server and links to who (1997)
WebCommerce: Folder organization ? (1997)
[OSX] Creative Page (2003)
Locking up with WebCatalog... (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Help name our technology! I found it (1997)