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:
Add more fields to an existent data base (1997)
[WebDNA] [OT] Google redirect or not (2014)
creator code (1997)
Re:quit command on NT (1997)
A question on sub-categories (1997)
Great product and great job ! (1997)
WebCatalog Use Question (1997)
shipcost (1997)
Exclamation point (1997)
emailer on Windows Beta 18 (1997)
WebCat B13 Mac CGI -- Frames question (1997)
Credit Card Checking?? (1998)
MacWEEK article help needed (1996)
Almost There But? WebCat Keeps Changing Cart Numbers onMe! (2002)
easiest way to check for a non-alphanumeric character? (2000)
Bug or syntax error on my part? (1997)
pretty Urgent: Crash after addlineitem (2001)
WebCat2.0 [format thousands .0f] no go (1997)
Redhat 7.3 (2002)
Multiple prices (1997)