[Zope] searching names in a query

Farrell, Troy troy.farrell@wilcom.com
Fri, 19 Jan 2001 11:40:02 -0600


Jacintha,
This is from the Gadfly SQL support page at:
http://www.chordate.com/kwParsing/gfSQL.html
*****

Some important omissions from ODBC 2.0 at this point are

Nulls.
Outer joins.
CHECK conditions.
Enforced data type constraints.
Alter table (can't implement until NULLs arrive).
Date, Time, and Interval data types
It is hoped these will be implemented at some future time.

Less important omissions include

Cursor based updates and deletes
  (justification: if you really need them the db design
   is flawed, and it's possible to use python instead).
LIKE string predicate
  (justification: use Python regexes in python code).
Users and permissions
  (justification: Gadfly is not intended for full multiuser
   use at this time).
*****

Note that Gadfly does not support LIKE.  They suggest that you use regexes
in python code.  I may be totally wrong, but in order to do this, you must
use external methods.  Anyone know better?

Troy

-----Original Message-----
From: jacintha menezes [mailto:jacintha.menezes@wipro.com]
Sent: Friday, January 19, 2001 6:02 AM
To: ethan mindlace fremen; Tim Cook; Graham Chiu; ethan mindlace fremen;
Dieter Maurer; Daniel Rusch; Cornelis J. de Brabander
Cc: zope@zope.org
Subject: [Zope] searching names in a query


hi,
   " Like" in SQL query under Gadfly database doesn't work. Is there any
other way
by which when give half name all the names related to that should be
displayed.
eg. *abc*
    abcde
    efabcthy
                     Thanks,
                       jacintha


_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )