🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.intrabuilder.data.sql
Article #59

Freetext SQL search in textarea fields

#59
From: �yvind Liberg
Date: Wed, 04 Mar 1998 00:00
26 lines
1475 bytes
I have noticed that the textarea fields of a form I designed do not seem
to respond to SQL queries. However, the single line text fields appear
to function OK. Why is this so? 

I have some considerable chunks of text in a number of text area fields,
and I want to do freetext search on information in these. How do I
achieve that? There is an example in the FAQ on Borlands web pages, but
that did not make me any wiser. In all examples I have seen on queries,
there seems to be a particular string being searched for. I may have
missed a point here, but I cannot possibly see the real use of searching
for fixed text strings. 

I am very new to database development, so apologies for any daft
questions.

One final question: How do I change the date fields to accept data in
dd/mm/yy format, and not the mm/dd/yy format?

Please notify me by e-mail as well.

Thanks,

�yvind Liberg
2044 Frogner, Norway
oliberg@online.no
Technical Details
Message-ID: <34FC9AD5.3E7@online.no>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 101d9a,a2b41bca34e5fb24,start
X-Google-Attributes: gid101d9a,public
From: �yvind Liberg <oliberg@online.no>
Subject: Freetext SQL search in textarea fields
Date: 1998/03/04
Message-ID: <34FC9AD5.3E7@online.no>
X-Deja-AN: 330575761
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Reply-To: oliberg@online.no
Newsgroups: borland.public.intrabuilder.data.sql