Run OQL having LIMIT 1

[Pankaj khurana]

Hi i want to run oql whose first value comes means limit is 1

SELECT Team AS t JOIN lnkDeliveryModelToContact AS l1 ON l1.contact_id=t.id JOIN DeliveryModel AS dm ON l1.deliverymodel_id=dm.id JOIN Organization AS o ON o.deliverymodel_id=dm.id WHERE o.id = :this->org_id

I want to display team with limit 1...can anyone help to help this...

Thanks in advance...

[Denis]

Hi Pankaj,

There is no LIMIT statement in OQL rigth now. So you cannot include this limit in the query itself.

However if you're doing this programmatically, the class DBObjectSet has a SetLimit method:

SetLimit($iLimitCount, $iLimitStart = 0)

[Pankaj khurana]

Thanks Sir