How do i create double parenthesis
I want this sql code

WHERE (CalendarRoleBlock.Blocked = '0' or CalendarRoleBlock.Blocked = 0 or CalendarRoleBlock.Blocked is null )
AND ((Event.StartDate >= '2007-11-01' AND Event.StartDate <= '2007-11-30' ) OR (Event.EndDate >= '2007-11-01' AND Event.EndDate <= '2007-11-30' ))

notice their are 2 parenthesis after the first AND logic
I have this so far

$sql->AddWhere('CalendarRoleBlock', 'Blocked', '', 0, '=', 'and', '', 1, 1);
$sql->AddWhere('CalendarRoleBlock', 'Blocked', '', 0, '=', 'or', '', 0);
$sql->AddWhere('CalendarRoleBlock', 'Blocked', '', 'null', 'is', 'or', '', 0);
$sql->EndWhereGroup();
$sql->AddWhere('Event', 'StartDate', '', '2007-11-01' , '>=', 'AND', '', 1,1);
$sql->AddWhere('Event', 'StartDate', '', '2007-11-30', '<=', 'AND', '', 1,0);
$sql->EndWhereGroup();
$sql->AddWhere('Event', 'EndDate', '', '2007-11-01', '>=', 'OR', '', 1,1);
$sql->AddWhere('Event', 'EndDate', '', '2007-11-30', '<=', 'AND', '', 1,0);
$sql->EndWhereGroup();

which gives me this

WHERE (CalendarRoleBlock.Blocked = '0' or CalendarRoleBlock.Blocked = 0 or CalendarRoleBlock.Blocked is null )
AND (Event.StartDate >= '2007-11-01' AND Event.StartDate <= '2007-11-30' ) OR (Event.EndDate >= '2007-11-01' AND Event.EndDate <= '2007-11-30' )

cannot use $sql->StartWhereGroup() as below
$sql->StartWhereGroup() ;
$sql->AddWhere('Event', 'StartDate', '', '2007-11-01' , '>=', 'AND', '', 1,1);
$sql->AddWhere('Event', 'StartDate', '', '2007-11-30', '<=', 'AND', '', 1,0);
$sql->EndWhereGroup();
$sql->AddWhere('Event', 'EndDate', '', '2007-11-01', '>=', 'OR', '', 1,1);
$sql->AddWhere('Event', 'EndDate', '', '2007-11-30', '<=', 'AND', '', 1,0);
$sql->EndWhereGroup();
$sql->EndWhereGroup();
cause then the AND logic disappears. and i get this
WHERE (CalendarRoleBlock.Blocked = '0' or CalendarRoleBlock.Blocked = 0 or CalendarRoleBlock.Blocked is null )
((Event.StartDate >= '2007-11-01' AND Event.StartDate <= '2007-11-30' ) OR (Event.EndDate >= '2007-11-01' AND Event.EndDate <= '2007-11-30' ))
which isn't a valid query. Its because AddWhere function won't add the AppendMethod (AND) if it detects a starting parenthesis, Thats why using $sql->StartWhereGroup() makes the query invalid.
here is the offending code in the AddWhere()
if (!empty($sWheres) && substr($sWheres,strlen($sWheres)-1) != '(') {
$sWheres .= $AppendMethod.' ';
}
this is correct if you DON'T have any existing WHERE and a fresh where group is being started, However, if their is an existing WHERE than this function results in invalid query

No cannot do that either. the first part is generated by a different fucntion than the second part. i just put it in one place for clarity. I cannot switch the order, let say that for now.
they should both append nicely. Its a bug in AddWhere

here is the offending code in the AddWhere()
if (!empty($sWheres) && substr($sWheres,strlen($sWheres)-1) != '(') {
$sWheres .= $AppendMethod.' ';
}
this is correct if you DON'T have any existing WHERE and a fresh where group is being started, However, if their is an existing WHERE than this function results in invalid query by NOT adding the necessary append method
So the fucntion needs to be changed so it works for "WHERE (blah) AND (" but not this "WHERE ("

Yes, it will be great.

I just think, if the code in GetWheres() which if ($StartWhereGroup) $sWheres .= '('; change to if ($StartWhereGroup) $sWheres .= str_repeat('(', $StartWhereGroup); and remove $StartWhereGroup = ForceBool($StartWhereGroup, 0);
We can create multi-parenthesis as wish use AddWhere. (but it may be ugly.)

mattucf that is perfect, solution, simple and won't brake anything