Home » U++ Library support » U++ SQL » SqlArray Limit and Offset
SqlArray Limit and Offset [message #4466] |
Fri, 11 August 2006 01:03 |
zsolt
Messages: 698 Registered: December 2005 Location: Budapest, Hungary
|
Contributor |
|
|
I have implemented it. I don't know if this is a good interface or not, but I hope so.
SqlArray declaration private section (SqlCtrl.h):
unsigned int limit;
bool limit_set;
int64 offset;
bool offset_set;
SqlArray declaration public section:
SqlArray& SetLimit(unsigned int _limit) { limit = _limit; limit_set = true; return *this; }
SqlArray& SetOffset(int64 _offset) { offset = _offset; offset_set = true; return *this; }
In SqlArray::SqlArray() and SqlArray::Clear()
limit_set = false;
offset_set = false;
In void SqlArray::AppendQuery(SqlBool where)
I have changed
sql * ::Select(cols).From(table).Where(wh).OrderBy(orderby);
to
SqlSet set = ::Select(cols).From(table).Where(wh).OrderBy(orderby);
if(limit_set)
if(offset_set) set.Limit(offset, limit);
else set.Limit(limit);
else
if(offset_set) set.Offset(offset);
sql * set;
|
|
|
|
|
SqlArray Limit and Offset
By: zsolt on Fri, 11 August 2006 01:03
|
|
|
Re: SqlArray Limit and Offset
By: mirek on Fri, 11 August 2006 08:35
|
|
|
Re: SqlArray Limit and Offset
By: mirek on Fri, 11 August 2006 09:05
|
|
|
Re: SqlArray Limit and Offset
By: zsolt on Fri, 11 August 2006 09:41
|
|
|
Re: SqlArray Limit and Offset
By: zsolt on Fri, 11 August 2006 09:50
|
|
|
Re: SqlArray Limit and Offset
By: rbmatt on Fri, 11 August 2006 18:36
|
|
|
Re: SqlArray Limit and Offset
By: mirek on Fri, 11 August 2006 18:44
|
|
|
Re: SqlArray Limit and Offset
By: mirek on Fri, 11 August 2006 23:47
|
|
|
Re: SqlArray Limit and Offset
By: zsolt on Tue, 22 August 2006 14:10
|
|
|
Re: SqlArray Limit and Offset
By: mirek on Tue, 22 August 2006 15:21
|
|
|
Re: SqlArray Limit and Offset
By: fabio on Wed, 20 December 2006 16:49
|
|
|
Re: SqlArray Limit and Offset
By: mirek on Wed, 20 December 2006 21:00
|
|
|
Re: SqlArray Limit and Offset
By: fabio on Thu, 21 December 2006 15:17
|
|
|
Re: SqlArray Limit and Offset
By: mirek on Thu, 21 December 2006 21:49
|
|
|
Re: SqlArray Limit and Offset
By: fabio on Sat, 23 December 2006 10:01
|
|
|
Re: SqlArray Limit and Offset
By: mirek on Sat, 23 December 2006 12:55
|
|
|
Re: SqlArray Limit and Offset
By: fabio on Wed, 27 December 2006 17:09
|
|
|
Re: SqlArray Limit and Offset
By: mirek on Sun, 31 December 2006 09:27
|
Goto Forum:
Current Time: Tue May 14 14:43:06 CEST 2024
Total time taken to generate the page: 0.01893 seconds
|