[Bacula-users] Re: File attributes

2006-05-11 Thread Mark Nienberg
James Harper wrote: I just threw together some MS SQL (because that's what I've got in front of me) code that sort of does what you want, but not in a way that could be used in a query (you'd have to put it in a user defined function, which is easy enough to do), and being MSSQL it won't work as

Re: [Bacula-users] Re: File attributes

2006-05-10 Thread Cedric Tefft
Mark Nienberg wrote: Mark Nienberg wrote: I'd like to write an SQL query to extract some information from the bacula catalog including file dates. I see from the bacula developers guide that the File table has a field named LStat that is defined as File attributes in base64 encoding. I

[Bacula-users] Re: File attributes

2006-05-10 Thread Mark Nienberg
Cedric Tefft wrote: Mark Nienberg wrote: I'd like to write an SQL query to extract some information from the bacula catalog including file dates. I see from the bacula developers guide that the File table has a field named LStat that is defined as File attributes in base64 encoding. I

RE: [Bacula-users] Re: File attributes

2006-05-10 Thread James Harper
James Harper wrote: Do you want to deal with it in the query (harder), or in the code that processes the query (easier)? Are you asking what Base64 is, or do you know already and would just like some help doing something useful with it from within the SQL language? My hope was to

Re: [Bacula-users] Re: File attributes

2006-05-10 Thread Troy Daniels
Hi, There was thread a couple of weeks back about the fact that bacula uses a slightly different algorithm to the standard base64 one. Would that apply in this case and would it account for the confusing output received by Mark? Just a thought - could be completely off the mark. Troy.