Function msMSSQL2008LayerWhichShapes

mapmssql2008.c:682–720

Execute SQL query for this layer */

/* Execute SQL query for this layer */
int msMSSQL2008LayerWhichShapes(layerObj *layer, rectObj rect, int isQuery)
{
    msMSSQL2008LayerInfo  *layerinfo = 0;
    char    *query_str = 0;
    int     set_up_result;

    if(layer->debug) {
        msDebug("msMSSQL2008LayerWhichShapes called\n");
    }

    layerinfo = getMSSQL2008LayerInfo(layer);

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

        return MS_FAILURE;
    }

    if(!layer->data) {
        msSetError(MS_QUERYERR, "Missing DATA clause in MSSQL2008 Layer definition.  DATA statement must contain 'geometry_column from table_name' or 'geometry_column from (sub-query) as foo'.", "msMSSQL2008LayerWhichShapes()");

        return MS_FAILURE;
    }

	set_up_result = prepare_database(layer, rect, &query_str);

    if(set_up_result != MS_SUCCESS) {
        msFree(query_str);

        return set_up_result; /* relay error */
    }

    msFree(layerinfo->sql);
    layerinfo->sql = query_str;
    layerinfo->row_num = 0;

    return MS_SUCCESS;
}

/* Close the MSSQL2008 record set and connection */
int msMSSQL2008LayerClose(layerObj *layer)