21489 Posts in 5783 Topics by 2622 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 1252 Views |
-
Offset in query

26 January 2009 at 9:41pm
Is it possible to set the offset of a query? Do I have to use regular mysql queries to do this?
Thanks!
-
Re: Offset in query

26 January 2009 at 9:56pm
Have not tried it yet, but I guess it belongs in the "limit" parameter place, e.g. "'LIMIT'='$count' 'OFFSET'='$offset'".
-
Re: Offset in query

26 January 2009 at 11:03pm
yes, for a limit it would be something like:
return DataObject::get("MyPage", "", "Date DESC", "", "$limit");
or with an offset and a limit:
return DataObject::get("MyPage", "", "Date DESC", "", "$offset, $limit");
| 1252 Views | ||
|
Page:
1
|
Go to Top |


