U++ forum: Welcome to the forum

OrderBy Descending missing [message #21048]

Tue, 28 April 2009 19:25

phirox
Messages: 49
Registered: December 2007

Member

I found this previous topic about the same thing. But it says there is a descending() function, I could find no such thing. So I just added the suggested OrderByDesc() function.

In Sqlexp.h:

SqlSelect& OrderByDesc(const SqlSet& columnset);
SqlSelect& OrderByDesc(SqlVal a)                      { return OrderByDesc(SqlSet(a)); }
SqlSelect& OrderByDesc(SqlVal a, SqlVal b)            { return OrderByDesc(SqlSet(a, b)); }
SqlSelect& OrderByDesc(SqlVal a, SqlVal b, SqlVal c)  { return OrderByDesc(SqlSet(a, b, c)); }

And in SqlStatement.cpp

SqlSelect& SqlSelect::OrderByDesc(const SqlSet& set) {
	if(!set.IsEmpty())
		text << " order by " << ~set << " desc";
	return *this;
}

[Updated on: Wed, 29 April 2009 10:04]

Report message to a moderator