knandan

int Database::PrepareStatementHandles(sqlo_stmt_handle_t& sth_target, sqlo_stmt_handle_t& sth_criteria)
{
        STACKTRACE;

        if(0 > (sth_target = sqlo_prepare(g_dbHandle,
                        "select guid, pool_id, priority, targethost, targetpage, frameflag from crs_web_target where pool_id = :1")))
        {
                crslog(LOG_ALERT, "Failed to prepare target statement\n");
                return -1;
        }


        if(0 > (sth_criteria = sqlo_prepare(g_dbHandle,
                "select CRS_WEB_CRITERIA.GUID, CRS_WEB_CRITERIA.PRIORITY, LOWER(CRS_WEB_HEADER.NAME), CRS_WEB_CRITERIA.CASE_INSENSITIVE, CRS_WEB_CRITERIA.HEADER_PATTERN, CRS_WEB_MATCH.ID from CRS_WEB_CRITERIA, CRS_WEB_HEADER, CRS_WEB_MATCH where CRS_WEB_CRITERIA.TARGET_ID = :2 and CRS_WEB_HEADER.GUID = CRS_WEB_CRITERIA.HEADER_ID and CRS_WEB_MATCH.ID = CRS_WEB_CRITERIA.HEADER_MATCH_ID")))
        {
                crslog(LOG_ALERT, "Failed to prepare criteria statement\n");
                return -1;
        }


        return 0;
}