On Wed, Nov 18, 2009 at 11:29:38AM +0100, Fahrer, Julian wrote:
> Hey,
>
> yes it seems tob e the same problem.
> The sql statement in the sub "db_find_last_jobid" is:
> "SELECT JobId FROM Job WHERE Type='B' AND JobStatus IN ('T','W') AND "
> "Name='%s' ORDER BY StartTime DESC LIMIT 1", Name);
>
> I think changing it to something like
>
> "SELECT JobId FROM Job WHERE Type='B' AND JobStatus IN ('T','W') AND "
> "Name='%s' ORDER BY StartTime DESC, JobId DESC LIMIT 1", Name);
>
> would fix the problem for me right now. But I am not sure what problems would
> occure then...
The obvious problem is that you wouldn't be able to verify the original job. :)
>
> Thanks for submitting my mail to the devil list
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
