[Zope-dev] Searching a relational database

Thomas Weholt thomas@cintra.no
Sat, 24 Jun 2000 16:18:52 +0200


This is a multi-part message in MIME format.

------=_NextPart_000_0035_01BFDDF7.E2BD9880
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
=20
How can I search a relational database thru Zope? ( I`m using =
PostgreSQL
7.0.2 on Linux ). I have a DVD/VHS-organizing project that would be
pretty useless if people couldn`t search for movies by entering just
parts of the title.=20
=20
Ex. typing alien should show "Alien" and "Alien 3".=20
=20
Can ZCatalog be used for this? If I have a SQL-statement that returns
all rows in a database, can ZCatalog index this?=20
=20
What I`m looking for is similar to full-text searching on MS SQL 7.0
etc.
=20
Tips, hints or pointers??
=20
Thomas
=20

------=_NextPart_000_0035_01BFDDF7.E2BD9880
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>

<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>How can I search a relational database =
thru Zope? (=20
I`m using PostgreSQL 7.0.2 on Linux ). I have a DVD/VHS-organizing =
project that=20
would be pretty useless if people couldn`t search for movies by =
entering just=20
parts of the title. </FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Ex. typing alien should show "Alien" =
and "Alien 3".=20
</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Can ZCatalog be used for this? If I =
have a=20
SQL-statement that returns all rows in&nbsp;a database, can ZCatalog =
index this?=20
</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>What I`m looking for is similar to =
full-text=20
searching on MS SQL 7.0 etc.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Tips, hints or pointers??</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thomas</FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0035_01BFDDF7.E2BD9880--