[ Previous ] [ Contents ] [ Index ] [ Next ]

Ns_PdDbBindRow

Overview

Return a list of column names of rows.

Syntax

    void Ns_PdDbBindRow(Ns_DbHandle *handle);

Description

The Ns_PdDbBindRow function should return a list of column names of rows to be returned by the SQL command previously executed by Ns_PdDbExec().

The Ns_PdDbSetRowInfoItem inserts the data info the rowData array. You associate data to AOLserver via Ns_PdDbSendRowInfo. The Ns_PdDbSendRowInfo uses Ns_PdDbSendString to send the number of columns and Ns_PdDbSendData to send the row data (e.g., Ns_PdSendData(rowInfo->rowData[i].elData, size);).

Psuedo-code Example

    /* Things italicized would be your DBMS-specific structures and 
calls. */
    typedef struct Ns_PdRowData {
    int elSize;
    char *elData;

} Ns_PdRowData; typedef struct Ns_PdRowInfo {

    int numColumns;
    Ns_PdRowData *rowData;

} Ns_PdRowInfo; void Ns_PdDbBindRow(void *handle) { DBMSState *state = (DBMSState *)handle; Ns_PdRowInfo *rowInfo; if ((rowInfo = DBMSBindRow(state)) == NULL) { Ns_PdSendException(state->exceptionCode, state->exceptionMsg); } else { Ns_PdSendString(OK_STATUS); Ns_PdSendRowInfo(rowInfo); Ns_PdFreeRowInfo(rowInfo, 1); } }

Top of Page

[ Previous ] [ Contents ] [ Index ] [ Next ]
Copyright © 1998-99 America Online, Inc.