count(*) implementation

[Hassan Abolhassani]

Hi,

What is the best way to implement a query like following in Torque:

  select count(*) from table1, table2 
  where table1.id=table2.id and table2.field='something'

I want to have a function in peer class of table1 like:

  public static int getCount()

That returns the result of that count.

___

Razorfish Japan, Inc.

アボルハッサニ　ハッサン   Hassan Abolhassani  [Technology network]
株式会社　レーザーフィッシュ・ジャパン
[EMAIL PROTECTED]
Tel:03-5436-9980 Fax:03-5436-9126


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]