Function msMSSQL2008LayerGetShape

mapmssql2008.c:1467–1559

Execute a query on the DB based on the query result. */

/* Execute a query on the DB based on the query result. */
int msMSSQL2008LayerGetShape(layerObj *layer, shapeObj *shape, resultObj *record)
{
    char    *query_str;
    char    *columns_wanted = 0;
    
    msMSSQL2008LayerInfo  *layerinfo;
    int                 t;
    char buffer[32000] = "";
    long shapeindex = record->shapeindex;
    long resultindex = record->resultindex;

    if(layer->debug) {
        msDebug("msMSSQL2008LayerGetShape called for shapeindex = %i\n", shapeindex);
    }

    layerinfo = getMSSQL2008LayerInfo(layer);

    if(!layerinfo) {
        /* Layer not open */
        msSetError(MS_QUERYERR, "msMSSQL2008LayerGetShape called on unopened layer (layerinfo = NULL)", "msMSSQL2008LayerGetShape()");

        return MS_FAILURE;
    }

    if (resultindex >= 0 && layerinfo->sql)
    {
        /* trying to provide the result from the current resultset (single-pass query) */
        if( resultindex < layerinfo->row_num)
        {
            /* re-issue the query */
            if (!executeSQL(layerinfo->conn, layerinfo->sql))
            {
                msSetError(MS_QUERYERR, "Error executing MSSQL2008 SQL statement: %s\n-%s\n", "msMSSQL2008LayerGetShape()", layerinfo->sql, layerinfo->conn->errorMessage);

                return MS_FAILURE;
            }
            layerinfo->row_num = 0;
        }
        while( layerinfo->row_num < resultindex )
        {
            /* move forward until we reach the desired index */
            if (msMSSQL2008LayerGetShapeRandom(layer, shape, &(layerinfo->row_num)) != MS_SUCCESS)
                return MS_FAILURE;
        }

        return msMSSQL2008LayerGetShapeRandom(layer, shape, &(layerinfo->row_num));
    }

    /* non single-pass case, fetch the record from the database */

    if(layer->numitems == 0) 
    {
        snprintf(buffer, sizeof(buffer), "%s.STAsBinary(), convert(varchar(36), %s)", layerinfo->geom_column, layerinfo->urid_name);
        columns_wanted = msStrdup(buffer);
    } 
    else 
    {
        for(t = 0; t < layer->numitems; t++) {