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:
Re:redirect from the errorsMessages.db entry (1997)
Secure Server (1997)
Problem displaying search result (1997)
WebCat2 - many [carts] on one template page? (1997)
Apache suffix mapping for .tpl (2000)
form image (2000)
HELP WITH DATES (1997)
carriage returns in data (1997)
[Shell] question (2000)
[writefile] (1997)
WebDNA 6.0 & MAC OS X Server 10.4.10 (2007)
[shownext] and descending order (1997)
Sorting by date (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Formating Tables w/[founditems] (1998)
search results (1998)
Robust WebDNA Job Manager / Accountant (2006)
RE: creating writefile data from a nested search (1997)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
Re[2]: Putting a page between checkout and invoice (1999)