Ns_PdDbSetMaxRows

Syntax

void Ns_PdDbSetMaxRows (void *handle);

Description

This function sets the max rows for the database if the DBMS supports it. If this function is successful or the SQL command is undefined for your specific DBMS, it should call Ns_PdSendString with an OK_STATUS. If set-max-rows is defined for your specific DBMS and there is an exception raised, then this function should send an exception code with Ns_PdSendException. If this function is undefined for the DBMS, then this function should call Ns_PdSendString with an OK_STATUS.

Pseudo-code Example

/* DBMSState and DBMSExec are your DBMS-specific structures and calls. */

void
Ns_PdDbSetMaxRows(void *handle, char *maxRows) {
  DBMSState *state = (DBMSState *)handle;
  Ns_PdLog(Trace, "setmaxrows:");
  sprintf(state->sqlbuf, "set rowcount %s", maxRows);
  if (DBMSExec(state, state->sqlbuf) != DB_DML) {
    Ns_PdLog(Error, "DbSetMaxRows: Exec(%s) failed", state->sqlbuf);
    Ns_PdSendException(state->exceptionCode, state->exceptionMsg);
  }
  Ns_PdSendString(OK_STATUS);
}