¡¡¡Full Text Search!!!

[Esteban Caldentey Morales]

Hi there, i'm building a C/S application with D3 and SQL Server. The
application needs to perform a full text search on a complete table that
has two different TEXT Field (2 blob field on a same record ). I don´t
know how to do that and how to index the table. I don´t know if there is
a special component to full search a text field. The result i need is
something like a search on the Internet (Infoseek, Yahoo, etc).

If somebody can help i will appreciate it.

Thank in advance, Esteban

[John Hair]

> Hi there, i'm building a C/S application with D3 and SQL Server. The
> application needs to perform a full text search on a complete table that
> has two different TEXT Field (2 blob field on a same record ). I don´t
> know how to do that and how to index the table. I don´t know if there is
> a special component to full search a text field. The result i need is
> something like a search on the Internet (Infoseek, Yahoo, etc).

I would use a query (or even better, a stored procedure!) that looked
something like ;

SELECT * FROM Table1
WHERE BlobField1 LIKE '%' + :SearchString + '%' OR
BlobField2 LIKE '%' + :SearchString + '%'

You can use the LIKE keyword on text fields, as long as they actually do
contain text!<g>

This is untested, but it should produce a result set of the records that
you require.
I wouldn't even attempt to do this with a TTable.

Hope this helps.

Cheers

John Hair
Designer Systems Ltd
(Remove .NOSPAM from address if responding by email)

[Esteban Caldentey Morales]

Hi John, i did what you told me and i resolved my problems.
Thank a lot, Esteban.

John Hair escribió:

[fq...@my-dejanews.com]

In article <35A4AB5C...@chilesat.net>,

Esteban Caldentey Morales <ecal...@chilesat.net> wrote:
> Hi there, i'm building a C/S application with D3 and SQL Server. The
> application needs to perform a full text search on a complete table that
> has two different TEXT Field (2 blob field on a same record ). I don´t
> know how to do that and how to index the table. I don´t know if there is
> a special component to full search a text field. The result i need is
> something like a search on the Internet (Infoseek, Yahoo, etc).
>

> If somebody can help i will appreciate it.
>
> Thank in advance, Esteban
>
>

I'm trying to add FTS (full text search) capabilities to my application via
ftsrch.dll functions (of the winhelp). i' want information; Delphi, c++...
something. sorry by my english. thanks.
Gabriel Pittau - Buenos Aires - Argentina - gpi...@yahoo.com

pd: supongo que hablas español. espero que mi mensaje te dé una pista (por lo
de la dll). lo lamentable es que estemos del mismo lado demandante. Nos
mantenemos en contacto?

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum