> > $query = $queries[STUFF_FROM_TABLE1][SELECTED_DRIVER]; > > $query = sprintf($query, $parameter1, $parameter2); > > I'd vote for trying to do what Bacula does -- simplify the > SQL and not use any > non-standard MySQL SQL unless absolutely necessary. Doing > that, we should be > able to keep the differences to only a few lines of SQL. If > Bacula can do > it, then bacula-web can too (I think). If we can accomplish > that then a few > lines of code as Juan Luis has shown are a good solution.
this approach would be very elegant for supporting additional databases (eg, DB/2, Oracle, etc). -- db ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
