I know how to use free text search, but thats not what I need - I need to be
able to ask a question in english, and get sql generated that will answer
the question when executed.
This is what english query does - and it is working, however One of the
fields in a db table contains the deescription of a product - and I want
within english query to be able to find matches against part of the field.
cheers
Dan
-----Original Message-----
From: Alex Schrimsher [mailto:[EMAIL PROTECTED]]
Sent: 01 May 2001 14:19
To: SQL
Subject: Re: English Query
Use a freetext search. That will find a particular word, or form / tense of
a word.
Alex
----- Original Message -----
From: "Daniel Lancelot" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 8:43 AM
Subject: English Query
> Anyone know any good resources for English query 4 sql 7???
>
> In particular, I would like to know how to get it to find partial
matches -
> for instance finding a single word within a description...
>
> Cheers
>
> Daniel Lancelot
> Web Developer
> Netstep Corporate Communications
> Tel +44 (0) 1422 200308
> Fax +44 (0) 1422 200306
> e-mail: [EMAIL PROTECTED]
> www: http://www.netstep.co.uk
>
> <NOTE: The information contained in this e-mail is intended for the named
> recipient(s) only. It may also be privileged and confidential. If you
are
> not an intended recipient, you must not copy, distribute or take any
action
> in reliance upon it. No warranties or assurances are made in relation to
> the safety and content of this e-mail and any attachments. No liability
is
> accepted for any consequences arising from it.>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
