Re: [SQLObject] select from multiple tables

2006-09-11 Thread Oleg Broytmann
On Mon, Sep 11, 2006 at 10:14:42AM +0200, Ivan Horvath wrote: > after many trials it seems to me that order by clause works only for > one field. > if the orderBy parameter receives list or tuple, because i need more order > clause then the system parse this as sequence and the result withi

Re: [SQLObject] select from multiple tables

2006-09-11 Thread Ivan Horvath
Dear Oleg, after many trials it seems to me that order by clause works only for one field. if the orderBy parameter receives list or tuple, because i need more order clause then the system parse this as sequence and the result within brackets - and it is true this sql cannot execute in

Re: [SQLObject] select from multiple tables

2006-09-08 Thread Oleg Broytmann
On Fri, Sep 08, 2006 at 03:58:42PM +0200, Ivan Horvath wrote: > SELECT history.username, objects.type, objects.obj_file, history.datetime, > history.comment FROM objects, history WHERE (((history.username) = ('Ivan')) > AND ((objects.id) = (history.objects_id))) ORDER BY (history.datetime, > obj

[SQLObject] select from multiple tables

2006-09-08 Thread Ivan Horvath
Best regards, Ivan Horvath Chief Programmer   Alcatel ISD  PMS 2000 Product Team   H-1116, Budapest  Kondorfa u. 10.  Tel.: +36 1 209 9546  Fax.: +36 1 209 9599  Mobil: +36 30 257 0235  VOIP: +49 511 676 478010  [EMAIL PROTECTED] Anyone who has never made a mistake has never tried