Re: [Zope] Using sql to search in zope

2000-06-02 Thread Stuart 'Zen' Bishop
On Fri, 2 Jun 2000 [EMAIL PROTECTED] wrote: > I tried to build a search feature using sql in zope, this is what I normal > do in sql to do a range search : > > select * from table1 where table1_id = %field1_value% > > But when I try it with zope, it will become > > select * from table1 where t

Re: [Zope] Using sql to search in zope

2000-06-02 Thread Jim Sanford
- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 02, 2000 3:10 AM Subject: [Zope] Using sql to search in zope Hi All, I tried to build a search feature using sql in zope, this is what I normal do in sql to do a range search : select * from t

Re: [Zope] Using sql to search in zope

2000-06-02 Thread Graham Chiu
In article <93F7843B0CACD311A5320090271F3C224D7938@redlion2>, peter <[EMAIL PROTECTED]> writes >Where's the 'LIKE' ? It's Access. -- Regards, Graham Chiu gchiucompkarori.co.nz http://www.compkarori.co.nz/index.php Powered by Interbase and Zope ___ Z

Re: [Zope] Using sql to search in zope

2000-06-02 Thread Graham Chiu
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes >Hi All, > >I tried to build a search feature using sql in zope, this is what I normal >do in sql to do a range search : > >select * from table1 where table1_id = %field1_value% where table1_id = -- Regards, Graham Chiu gchiucompkaro

RE: [Zope] Using sql to search in zope

2000-06-02 Thread peter
Where's the 'LIKE' ? Such as SELECT * FROM table1 WHERE table1_id LIKE %field1_value% -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: 02 June 2000 09:10 To: [EMAIL PROTECTED] Subject: [Zope] Using sql to search in zope Hi All,