Re: Searching HTML with Excalibur Text Search Datablade

In article <6u5jf6$g8j$1@news3.mr.net>,"dmeyers" <dmeyers@wrbc.com> wrote: > I have been told by Informix Tech support that there is no way to search the > HTML data type created by the Web Datablade using Excalibur. The only way > is to dump the HTML into another table in text format. > > Has anyone implemented a work-around to this? Try to store your HTML as CLOBs. This may of course limit what else you can do to the HTML (use DDW? I don't know, haven't tried). You will have to drop and re-create any tables you have. Actually you can copy your HTML tables to CLOB ones (there is an implicit cast). When you store stuff in the CLOB, cast it as HTML when inserting: '<HTML>this is html</HTML>'::html When you retrieve from the CLOBS, they should be OK with the implicit cast to HTML. You should then be able to create an ETX index on the CLOB column using 'etx_clob_doc'. I haven't tried the above but I know someone who did :-) I guess it's also pretty close to what tech support told you. Good luck, Tony -- asalerno@monmouth.com -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum