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:
Bit off subject -- Faxing orders (1997)
[WebDNA] [TEXT] limit (2019)
POST (1997)
Error message (1999)
Need relative path explanation (1997)
Max Record length restated as maybe bug (1997)
Nested vs conditional (1997)
Sorting error (1997)
Attention all list readers (1997)
attn: smitmicro - cart limitation (2002)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Individual Tax on Items (1998)
PROBLEM (1997)
Porting to NT (2001)
[WebDNA] More APIs - Viral Heat - Twitter Data Pipe (2011)
WebCat and HTML/OS (2001)
WebDNA vs SQL ? (2002)
'does not contain' operator needed ... (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
math on date? (1997)