Re: searching illegal HTML
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44395
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
Error Lob.db records error message not name (1997)
emailer (1997)
Rendering out a page (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
SMSI -- a [notfound] context? (2002)
Help formatting search results w/ table (1997)
August 15th WebDNA Chat Transcript (2002)
Download Question (1997)
TRAINING videos - Prove IT. (1998)
trouble updating records in database (1998)
Using Plug-In while running 1.6.1 (1997)
HELP!!! (1998)
Lambada for Macintosh is Here! (1996)
Webcat no longer supported? (2006)
WebCatalog Technical Reference (1997)
Is there a max number of fields? (1998)
Generating Report Totals (1997)
PROBLEM (1997)
math on date? (1997)
Showif date range comparison (1999)