| 22 |
* |
* |
| 23 |
* $Revision$ |
* $Revision$ |
| 24 |
* $Log$ |
* $Log$ |
| 25 |
|
* Revision 1.97 2005/06/30 07:21:42 aga4096 |
| 26 |
|
* ・get_all_index等で得られるindexが少ないことがあるのを修正. |
| 27 |
|
* |
| 28 |
* Revision 1.96 2005/06/29 00:10:18 aga4096 |
* Revision 1.96 2005/06/29 00:10:18 aga4096 |
| 29 |
* ・login name -> additional info に修正. |
* ・login name -> additional info に修正. |
| 30 |
* |
* |
| 5200 |
" FROM " + indexTable + " AS tx " + |
" FROM " + indexTable + " AS tx " + |
| 5201 |
" LEFT JOIN " + itemTable + " AS ti on tx.index_id = ti.item_id " |
" LEFT JOIN " + itemTable + " AS ti on tx.index_id = ti.item_id " |
| 5202 |
" LEFT JOIN " + groupUserLinkTable + " AS tlink on tlink.gid = tx.gid and tlink.uid = " + uidString + |
" LEFT JOIN " + groupUserLinkTable + " AS tlink on tlink.gid = tx.gid and tlink.uid = " + uidString + |
| 5203 |
" WHERE " + accessRightCond + " AND " + cond + criteriaString; |
" LEFT JOIN " + groupTable + " AS tg on tx.gid = tg.gid " |
| 5204 |
|
" WHERE " + accessRightCond + " AND ( tx.open_level != 2 OR tx.open_level = 2 AND tg.gid IS NOT NULL ) AND " + cond + criteriaString; |
| 5205 |
SQLCHAR title[XNP_ITEM_TITLE_LEN+1], |
SQLCHAR title[XNP_ITEM_TITLE_LEN+1], |
| 5206 |
keywords[XNP_ITEM_KEYWORDS_LEN+1], description[XNP_ITEM_DESCRIPTION_LEN+1]; |
keywords[XNP_ITEM_KEYWORDS_LEN+1], description[XNP_ITEM_DESCRIPTION_LEN+1]; |
| 5207 |
if( ( sqlcode = SQLAllocHandle( SQL_HANDLE_STMT, hdbc, &hstmt ) ) == SQL_SUCCESS ) { |
if( ( sqlcode = SQLAllocHandle( SQL_HANDLE_STMT, hdbc, &hstmt ) ) == SQL_SUCCESS ) { |