| 2 |
* |
* |
| 3 |
* $Revision$ |
* $Revision$ |
| 4 |
* $Log$ |
* $Log$ |
| 5 |
|
* Revision 1.74 2005/02/26 05:11:31 tani |
| 6 |
|
* getGroupItemID追加. |
| 7 |
|
* |
| 8 |
* Revision 1.73 2005/02/25 07:41:35 tani |
* Revision 1.73 2005/02/25 07:41:35 tani |
| 9 |
* getGroupItemID追加. |
* getGroupItemID追加. |
| 10 |
* item, indexのlimitフィールドを登録,更新処理に追加. |
* item, indexのlimitフィールドを登録,更新処理に追加. |
| 4183 |
sql += " AND certify_state=" + unsignedIntToString( index::CERTIFIED ); |
sql += " AND certify_state=" + unsignedIntToString( index::CERTIFIED ); |
| 4184 |
sql += " AND item_type_id !=" + unsignedIntToString( item::ITID_INDEX ); |
sql += " AND item_type_id !=" + unsignedIntToString( item::ITID_INDEX ); |
| 4185 |
sql += " AND item_type_id !=" + unsignedIntToString( item::ITID_BINDER ); |
sql += " AND item_type_id !=" + unsignedIntToString( item::ITID_BINDER ); |
| 4186 |
sql += " AND tx.gid=" + unsignedIntToString( sess_uid ); |
sql += " AND tx.gid=" + unsignedIntToString( gid ); |
| 4187 |
|
|
| 4188 |
syslog_printf( "\nsql at %d=%s", __LINE__, sql.c_str() ); |
syslog_printf( "\nsql at %d=%s", __LINE__, sql.c_str() ); |
| 4189 |
|
dst = new itemid_t[ dst_max ]; |
| 4190 |
|
*iids = dst; |
| 4191 |
if( ( sqlcode = SQLAllocHandle( SQL_HANDLE_STMT, hdbc, &hstmt ) ) == SQL_SUCCESS ) { |
if( ( sqlcode = SQLAllocHandle( SQL_HANDLE_STMT, hdbc, &hstmt ) ) == SQL_SUCCESS ) { |
| 4192 |
if( ( sqlcode = SQLExecDirect( hstmt, (SQLCHAR*)sql.c_str(), sql.length() ) ) == SQL_SUCCESS ){ |
if( ( sqlcode = SQLExecDirect( hstmt, (SQLCHAR*)sql.c_str(), sql.length() ) ) == SQL_SUCCESS ){ |
| 4193 |
itemid_t iid = 0; |
itemid_t iid = 0; |