On Wed, 2006-02-22 at 06:54 -0800, Karl Hakimian wrote: > 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: No need for SQL ... but I can't find the proper way to do this in bconsol ... or any oter tool ... testing the wxconsole-hint from Arno ... and that made me understand that I can use query in bconsol and get the info I need :D Thanks Arno!
Now I only have to tind a way to put this info to a file ... I read some
where that bconsole can be run whit options as a normale *nix
command ... looking ... have to read ... no prob :)
> 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.
>
--
Phone Work: +47 69212321 / 2321 Phone Priv: +47 69809853 (o_ <><
+47 99521685 / 3137 //\
ICQ: 48948625 MSN: [EMAIL PROTECTED] V_/_ i n u x
Registered Linux User # 171776 (http://counter.li.org)
signature.asc
Description: This is a digitally signed message part
