| in() {
... get rs, port and socket from previous page ...
sqlrcon con=sqlrcon_alloc("host",9000,"","user","password",0,1);
sqlrcur cur=sqlrcur_alloc(con);
sqlrcon_resumeSession(con,port,socket);
sqlrcur_resumeResultSet(cur,rs);
sqlrcur_sendQuery(cur,"commit");
sqlrcon_endSession(con);
sqlrcur_free(cur);
sqlrcon_free(con);
}
You can also distribute the processing of a result set across a series of CGI''''s using suspended sessions. If you''''re buffering a result set in chunks instead of all at once and suspend a session, when you resume the session you can continue to retrieve rows from the result set. Similarly, if you''''re buffering a result set in chunks, caching that result set and suspend your session. When you resume the session, you can continue caching the result set. You must use sqlrcur_resumeCachedResultSet() instead of sqlrcur_resumeResultSet() however.
<< 上一页 [11] [12] |