Re: [Zope] Fw: [Zope] Parameter in ZSQL

2000-08-13 Thread jan
Indra Gunawan wrote: > > Thanks man that really works..!!... > I want to ask another question > can I retrieve a random row from a table? Yes, you can - but how is a bit dependent on your database, if you want it to be efficient. The problem here is that SQL does not by itseld define a rownum

[Zope] Fw: [Zope] Parameter in ZSQL

2000-08-13 Thread Indra Gunawan
Thanks man that really works..!!... I want to ask another question can I retrieve a random row from a table? if can, could anyone tell me (using the same table and scheme from the previous question) Thanks again Mr Philipp Auersperg -IGUN- ICQ:1474584 > > > > call : > > > > > >

Re: [Zope] Parameter in ZSQL

2000-08-13 Thread Philipp Auersperg
call : with you just define a variable in the current namespace Philipp Auersperg (zwork) *** REPLY SEPARATOR *** On 13.08.2000 at 17:27 Indra Gunawan wrote: >Hello All >here's the problem >my Zope 2.2.0 is running on win98 >my Database is a MySQL > >I created a ZSQL method

[Zope] Parameter in ZSQL

2000-08-13 Thread Indra Gunawan
Hello All here's the problem my Zope 2.2.0 is running on win98 my Database is a MySQL I created a ZSQL method named ShowProduct with parameter product_id the template as follows : select * from products where why can't I call the ZSQL method directly (without using the GET/POST variables)? I t