From: zacheiss Date: Tue, 30 Apr 2002 02:18:15 +0000 (+0000) Subject: Allow wildcards in the container related get queries. X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/59aecfaf9a818576ee49717b085d027ca40899d3 Allow wildcards in the container related get queries. --- diff --git a/server/queries2.c b/server/queries2.c index 4c7d7e97..0814cdcd 100644 --- a/server/queries2.c +++ b/server/queries2.c @@ -6987,7 +6987,7 @@ struct query Queries[] = { "name, description, location, contact, acl_type, acl_id, memacl_type, memacl_id, TO_CHAR(modtime, 'DD-mon-YYYY HH24:MI:SS'), modby, modwith FROM containers", gcon_fields, 11, - "name = '%s' AND cnt_id != 0", + "name LIKE '%s' AND cnt_id != 0", 1, NULL, &gcon_validate, @@ -7089,7 +7089,7 @@ struct query Queries[] = { "m.name, c.name FROM machine m, containers c, mcntmap mcn", gmnm_fields, 2, - "m.name = UPPER('%s') AND mcn.cnt_id = c.cnt_id AND mcn.mach_id = m.mach_id", + "m.name LIKE UPPER('%s') AND mcn.cnt_id = c.cnt_id AND mcn.mach_id = m.mach_id", 1, NULL, NULL,