> For example, this is how we list files in a directory : > > SELECT File.FilenameId, listfiles.id, listfiles.Name, File.LStat, > File.JobId FROM > (SELECT Filename.Name, max(File.FileId) as id > FROM File, Filename > WHERE File.FilenameId = Filename.FilenameId > AND Filename.Name != '' > AND File.PathId IN ( 10,20,20202,20202 ) > AND File.JobId IN ( 1,2,3,4 ) > GROUP BY Filename.Name > ORDER BY Filename.Name) AS listfiles, > File > WHERE File.FileId = listfiles.id
I think that it's more something like File.PathId = xx than File.PathId IN (...) But it's not important at this time. Bye ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
