Browse CVS Repository
Diff of /xoonips/AL/commonal.cc
Parent Directory
| Revision Log
| Revision Graph
| Patch
| 2 |
* |
* |
| 3 |
* $Revision$ |
* $Revision$ |
| 4 |
* $Log$ |
* $Log$ |
| 5 |
|
* Revision 1.14 2004/11/27 01:07:31 youi |
| 6 |
|
* criteria2str: LIMITとORDER BYの順番を入れ替えた. |
| 7 |
|
* |
| 8 |
* Revision 1.13 2004/11/27 00:35:39 youi |
* Revision 1.13 2004/11/27 00:35:39 youi |
| 9 |
* getAccountsを定義. |
* getAccountsを定義. |
| 10 |
* getAccountを修正,内部でgetAccountsを呼び出す. |
* getAccountを修正,内部でgetAccountsを呼び出す. |
| 98 |
{ |
{ |
| 99 |
string sql; |
string sql; |
| 100 |
|
|
|
if( cri -> getLimitStart( ) != 0 || cri -> getLimitRows( ) != 0 ){ |
|
|
sql += " LIMIT " + string( intToString( cri -> getLimitStart( ) ) ) |
|
|
+ ", " + string( intToString( cri -> getLimitRows( ) ) ); |
|
|
} |
|
| 101 |
const orderby* odrby = cri -> headOrderBy( ); |
const orderby* odrby = cri -> headOrderBy( ); |
| 102 |
if( odrby != 0 ){ |
if( odrby != 0 ){ |
| 103 |
sql += " ORDER BY " + string( odrby -> getColumn( ) ); |
sql += " ORDER BY " + string( odrby -> getColumn( ) ); |
| 107 |
sql += ( odrby -> getOrder( ) == orderby::DESC ) ? " DESC" : " "; |
sql += ( odrby -> getOrder( ) == orderby::DESC ) ? " DESC" : " "; |
| 108 |
} |
} |
| 109 |
} |
} |
| 110 |
|
|
| 111 |
|
if( cri -> getLimitStart( ) != 0 || cri -> getLimitRows( ) != 0 ){ |
| 112 |
|
sql += " LIMIT " + string( intToString( cri -> getLimitStart( ) ) ) |
| 113 |
|
+ ", " + string( intToString( cri -> getLimitRows( ) ) ); |
| 114 |
|
} |
| 115 |
return sql; |
return sql; |
| 116 |
} |
} |
| 117 |
|
|
|
|
Legend:
| Removed from v.1.13 |
|
| changed lines |
| |
Added in v.1.14 |
|
|
|