Function msMSSQL2008LayerGetItems

mapmssql2008.c:1562–1637

Query the DB for info about the requested table */

/* Query the DB for info about the requested table */
int msMSSQL2008LayerGetItems(layerObj *layer)
{
    msMSSQL2008LayerInfo  *layerinfo;
    char                *geom_column_name = 0;
    char                sql[1000];
    int                 t;
    char                found_geom = 0;
    int                 item_num;
    SQLSMALLINT cols = 0;

    if(layer->debug) 
    {
        msDebug("in msMSSQL2008LayerGetItems  (find column names)\n");
    }

    layerinfo = getMSSQL2008LayerInfo(layer);

    if(!layerinfo) 
    {
        /* layer not opened yet */
        msSetError(MS_QUERYERR, "msMSSQL2008LayerGetItems called on unopened layer", "msMSSQL2008LayerGetItems()");

        return MS_FAILURE;
    }

    if(!layerinfo->conn) 
    {
        msSetError(MS_QUERYERR, "msMSSQL2008LayerGetItems called on MSSQL2008 layer with no connection to DB.", "msMSSQL2008LayerGetItems()");

        return MS_FAILURE;
    }

    snprintf(sql, sizeof(sql), "SELECT top 0 * FROM %s", layerinfo->geom_table); 

    if (!executeSQL(layerinfo->conn, sql))
    {
        msFree(geom_column_name);

        return MS_FAILURE;
    }

    SQLNumResultCols (layerinfo->conn->hstmt, &cols);

    layer->numitems = cols - 1; /* dont include the geometry column */

    layer->items = msSmallMalloc(sizeof(char *) * (layer->numitems + 1)); /* +1 in case there is a problem finding goeometry column */
                                                                /* it will return an error if there is no geometry column found, */
                                                                /* so this isnt a problem */

    found_geom = 0; /* havent found the geom field */
    item_num = 0;

    for(t = 0; t < cols; t++) 
    {
        char colBuff[256];

        columnName(layerinfo->conn, t + 1, colBuff, sizeof(colBuff));