U++ framework: U++ SQL » OrderBy Descending missing

Home » U++ Library support » U++ SQL » OrderBy Descending missing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: OrderBy Descending missing [with fix] [message #21049 is a reply to message #21048]

Tue, 28 April 2009 19:35

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

phirox wrote on Tue, 28 April 2009 13:25

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;
}

Well, this is taken from the code I am working on now:

	sql * Select(ROK, CISLO).From(STIZNOST).OrderBy(Descending(ROK), CISLO);

As argument of OrderBy is set, function is must...

Mirek

Report message to a moderator

[Message index]

		OrderBy Descending missing By: phirox on Tue, 28 April 2009 19:25
		Re: OrderBy Descending missing [with fix] By: mirek on Tue, 28 April 2009 19:35
		Re: OrderBy Descending missing [with fix] By: unodgs on Tue, 28 April 2009 21:33
		Re: OrderBy Descending missing [with fix] By: unodgs on Tue, 28 April 2009 21:36

Previous Topic:	sql example with 2 table needed
Next Topic:	sqlite3 get number of occurrences

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Sep 16 22:57:56 GMT+2 2026

Total time taken to generate the page: 0.00628 seconds