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 given
under any of the
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.
J
>
> 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
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".
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?
Just in case you don't know already, the date fields