SELECT SecLink FROM Security WHERE SecLink=52 AND UserLink=
;
OUTPUT NIL
DELETE FROM MapImage WHERE MapImageID=
;
FINISH
$res=`rm $in{BIDIR}/mapimages/Map$in{MapImageID}.gif`;
Map Deleted.
SELECT COUNT(*) ItemCnt FROM MapImage;
OUTPUT NIL
Maps
MAPS
-
of
Category
--Any--
SELECTED>
SELECT ContainerCategoryID CCID,CategoryName CCName FROM ContainerCategory ORDER BY CategoryName;
OUTPUT
Geographic Coverage
--Any--
SELECTED>
SELECT DISTINCT MapGroup TCat FROM MapImage ORDER BY MapGroup;
OUTPUT
Start Year
End Year
Name
ne ''>Attach
>
-
-
-
-
[Attach]
SELECT m.*,c.* FROM MapLocation as l,MapLocationAttach as a,MapImage as m,ContainerCategory as c WHERE l.LMBy=
AND a.MapLocationLink=l.MapLocationID AND m.MapImageID=a.MapImageLink AND ContainerCategoryID=m.CategoryLink ORDER BY l.LastModified DESC LIMIT 1;
OUTPUT
SELECT * FROM MapImage as m,ContainerCategory as c WHERE ContainerCategoryID=m.CategoryLink
AND YEAR(m.MapStartDate)=
AND YEAR(m.MapEndDate)=
AND m.CategoryLink=
ne ''>AND MapGroup=
ne ''>
AND MapName LIKE
ORDER BY CategoryName,MapGroup,MapName,MapStartDate LIMIT
,
;
OUTPUT