Function columnName

mapmssql2008.c:296–331

Get columns name from query results */

/* Get columns name from query results */
static int columnName(msODBCconn *conn, int index, char *buffer, int bufferLength)
{
    SQLRETURN rc;

    SQLCHAR columnName[SQL_COLUMN_NAME_MAX_LENGTH + 1];
    SQLSMALLINT columnNameLen;
    SQLSMALLINT dataType;
    SQLUINTEGER columnSize;
    SQLSMALLINT decimalDigits;
    SQLSMALLINT nullable;

    rc = SQLDescribeCol(
         conn->hstmt,
         (SQLUSMALLINT)index,
         columnName,
         SQL_COLUMN_NAME_MAX_LENGTH,
         &columnNameLen,
         &dataType,
         &columnSize,
         &decimalDigits,
         &nullable);

    if (rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO)
    {
        if (bufferLength < SQL_COLUMN_NAME_MAX_LENGTH + 1)
            strlcpy(buffer, (const char *)columnName, bufferLength);
        else
            strlcpy(buffer, (const char *)columnName, SQL_COLUMN_NAME_MAX_LENGTH + 1);
        return 1;
    }
    else
    {
        setStmntError(conn);
        return 0;
    }
}

/* open up a connection to the MS SQL 2008 database using the connection string in layer->connection */
/* ie. "driver=<driver>;server=<server>;database=<database>;integrated security=?;user id=<username>;password=<password>" */