[Zope-DB] result set question
Wed, 13 Mar 2002 14:20:25 +0100
* Joel Burton <email@example.com> [020313 13:40]:
> Splitting results is easy. Look at the Help docs for <dtml-in> and you'll
> see the commands for batching.
> You might want to create a separate ZSQLMethod for the detail view of an
> object, or you might want to share your list-getting method. You can do
> things like:
> # ZSQLMethod
> # parameters: fooid:optional
> SELECT * FROM tblFoo
> <dtml-if fooid>
> WHERE fooid=<dtml-sqlvar fooid type=foo>
dtml provides some special things for that (they just got fixed ...)
<dtml-sqltest fooid type="int" optional>
Would do the same.
> And you can call this method w/o an id to get all records, or with an id to
> get just one. The downside is that it's less clear and that you're getting
> all fields for your list; if your table has many long fields, this is
> unneccessary work. However, it is less to write and less to maintain.
I would provide 2 Queries, for the case you don't want to retrieve all fields of a set
or need to join some other tables for the detail view. This would save some speed and memory.
Christian Theune - firstname.lastname@example.org
gocept gmbh & co.kg - schalaunische strasse 6 - 06366 koethen/anhalt
tel.+49 3496 3099112 - fax.+49 3496 3099118 mob. - 0178 48 33 981
reduce(lambda x,y:x+y,[chr(ord(x)^42) for x in 'zS^BED\nX_FOY\x0b'])