On Wed, Feb 22, 2006 at 02:58:11PM +0100, Geir Asle Borgen wrote: > OK, but I'm no SQL guru ... I'm capable to get in to query-mode (using > bconsole) ... But any hint om SQL queryes for MySQL is welcome :)
Not sure why you would need to do this directly in sql, but the query in postgres looks like: select Path.path || Filename.name from File, Path, Filename where File.jobid = yourjobnumber and File.pathid = Path.pathid and File.filenameid = Filename.filenameid Replace yourjobnumber with the job number you want the files for. Unless you are coding up some sort of app, I'd suggest sticking with bconsole. -- Karl Hakimian [EMAIL PROTECTED] ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
