Re: ready for some testing

On Wed, 26 Nov 2003 22:47:20 -0600
Russell Valentine <russ-98fVsw/2eqlQihsdzhub5di2O/[email protected]> wrote:

> So I made the query work although (without $user_options, or
> $ORDER_BY_LIST). This is the query I came up with.I didn't check
> $user_options or $ORDER_BY_LIST but I'll check on that later hope this
> helps for now.

1) PostgreSQL doesn't like && it wants 'and'

includes/functions.inc.php:
-----------------
function z_MysqlDateRange($fieldName,$SourceArray)
{
    // code for this function under GPL and contributed/copyright
    // by Ali Ziad
    $fromDate = z_FormatFormDate("Ymd000000",$fieldName .'_from',$SourceArray);
    $toDate   = z_FormatFormDate("Ymd000000",$fieldName .'_to',$SourceArray);
    $result   = " ( (bugs.$fieldName >= $fromDate) and (bugs.$fieldName<=$toDate) ) ";
    return($result);
}
------------------

With the limited testing I did, I couldn't break Advanced Query. I've been
testing this with only one bug in the database, so shouuld still check it
out.


Russell Valentine

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/xYS/O0EDJO5MgRYRAhPaAJ4tCNZtTOt8/+ixN86JOz/3VIC3YQCfaSLe
Yd2KxDYb09nSfVutHHi3qeE=
=/IgD
-----END PGP SIGNATURE-----