From 3b1d5ce3b98406ef71b2625fd5f747b855e10a05 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Ale=C5=A1=20K=C5=99enek?= Date: Tue, 14 Apr 2009 13:03:32 +0000 Subject: [PATCH] fix SQL statement syntax error --- org.glite.lb.server/src/query.c | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/org.glite.lb.server/src/query.c b/org.glite.lb.server/src/query.c index ae3b197..69372da 100644 --- a/org.glite.lb.server/src/query.c +++ b/org.glite.lb.server/src/query.c @@ -376,10 +376,9 @@ int edg_wll_QueryJobsServer( if ( (where_flags & FL_SEL_STATUS) ) trio_asprintf(&qbase,"SELECT DISTINCT j.dg_jobid,j.userid " - "FROM jobs j, states s WHERE j.jobid=s.jobid %s %s %s %s ORDER BY j.jobid", + "FROM jobs j, states s WHERE j.jobid=s.jobid %s %s AND %s ORDER BY j.jobid", (job_where) ? "AND" : "", (job_where) ? job_where : "", - (ctx->isProxy) ? "AND" : "", (ctx->isProxy) ? "j.proxy='1'" : "j.server='1'"); else trio_asprintf(&qbase,"SELECT DISTINCT j.dg_jobid,j.userid " -- 1.8.2.3