Searching text

by "Rob Eager" <rad_dev(at)ihug.com.au>

 Date:  Tue, 2 May 2000 23:16:11 +1000
 To:  <hwg-languages(at)mail.hwg.org>
  todo: View Thread, Original
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,

I'm wondering if someone could give me a few pointers on a question:

I am creating a database that will eventually be used on an intranet.
 Within this database is to be a place for comments.  The general
shape the database will take is this:

client-ID: int, unique.
client-name: <called from another db> (eg client-details)
client-comments:  text area for comments.

Of course it's a little more detailed than that but that is the main
idea.  The problem area is the client-comments field.  This needs to
be fairly extensive which as far as I'm aware rules out using text as
type as it is limited to 255 chars.  A memo type would work well
however as it seems to allow more chars.  The main worry with this
field is the fact that it needs to be searchable in itself.  In other
words it needs to be searchable for each client (eg for client-ID=123
find client-comments="only buys brand names").  It also needs to be
searchable the other way around (eg for client-comments="brand names"
find client-ID).

I hope this is an appropriate forum, it's slightly off web techniques
but the search results will be posted via the usual cgi/script.  The
problem is in getting the comments field searchable.  Any help would
be most appreciated.

Regards,

Rob Eager
Sydney, Au.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBOQ5IdhDBgH3/ltyVEQJF3QCbBqg2VpmoGR3zeM12y6fxU/RLSCgAni2d
Q9iaWxob2kaTvIXylVxi4ELK
=44V+
-----END PGP SIGNATURE-----

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA