Re: searching illegal HTML
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44397
interpreted = N
texte = And if the values in the databases are NOT [url]'d !!!!!!!!!!!! le 25/10/02 21:39, Alain Russell à alain.russell@blackpepper.co.nz a écrit :> If the values in the databases are [url]'d you will need to [url] the fields > you 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'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/
Associated Messages, from the most recent to the oldest:
And if the values in the databases are NOT [url]'d !!!!!!!!!!!! le 25/10/02 21:39, Alain Russell à alain.russell@blackpepper.co.nz a écrit :> If the values in the databases are [url]'d you will need to [url] the fields > you 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'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/
lb Lawrence
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:
WebCatalog dying in WebTen Revisited (1998)
WCS Newbie question (1997)
unable to launch acgi in WebCat (1997)
Webcatalog server support (1997)
Triggers-Deadlock (2000)
FEA REQ: One .hdr, multiple .db's (2003)
thankyou.tmpl (1997)
Date problems (1997)
Server Takes 2 Hours to Boot UP (2004)
PIXO Support (1997)
Showif with multiple options (2002)
Details of shipping - Totalqty calculations (1997)
Pithy questions on webcommerce & siteedit (1997)
newbie question about zip code search (2003)
Not Authorised Adding Items (1998)
No Wanna Duppys (1998)
Shopping Cart Problem (1998)
About WebCatalog and iTools 7 (2003)
Here's an example of an applet in a tpl (1997)
Protecting webdelivery (1997)