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:
Search Form (2000)
WebCat2: Master Counter snippet (1997)
Remove Multiple Line Items (2005)
WebCat2 beta 11 - new prefs ... (1997)
listword db bolding (2002)
Re1000001: Setting up shop (1997)
WC3 and SSL on NT (1998)
eMail volume (2000)
Problem with version 4 browsers (1998)
Can't Update records (1997)
Re:2nd WebCatalog2 Feature Request (1996)
upgrading 5.0 --> 5.1g (2004)
E-mail problem... (1999)
The EMailer and the Blank menu bar? (1999)
WebCatalog can't find database (1997)
Plain Language Manual? (1998)
Interfacing WebMerchant to www.fedex.com (1997)
Candle Light Vigil (2001)
Too Much Rootbeer Free Offer (1997)
search problem (2002)