Bizzarre Error

I have a FromSQL query I’m trying to run:
my $tix = new RT::Tickets(RT::SystemUser);
$tix->FromSQL('Queue = “CustomerCare” AND ((LastUpdated > ’ . $date[0] . ’ AND
LastUpdated < ’ . $date[$#date] . ') OR (LastUpdated = ’ . $date[0] . ’ OR
LastUpdate = ’ . $date[$#date] . ‘))’);

I’m editing this in vim so when I land on a parenthesis the matching
closing/opening parenthesis is highlighted. As far as I can tell, all
parentheses are paired up. However, when I run the script, I get the following
error:
[error]: Query error in <<Queue = “CustomerCare” AND ((LastUpdated > 2007-05-01
AND LastUpdated < 2007-05-31) OR (LastUpdated = 2007-05-01 OR LastUpdate =
2007-05-31))>>:
Error near ->05<- expecting a CLOSE_PAREN in Queue = “CustomerCare” AND
((LastUpdated > 2007-05-01 AND LastUpdated < 2007-05-31) OR (LastUpdated =
2007-05-01 OR LastUpdate = 2007-05-31))
(/usr/local/rt-3.6.1/lib/RT/Tickets_Overlay_SQL.pm:487)

What’s “Error near ->05<-” supposed to mean? There’s 4 of them in the query.

Mathew
Keep up with me and what I’m up to: http://theillien.blogspot.com

In keeping with my habit of solving my problem after asking about it, I’ve done
so. I didn’t place the proper quotes where they needed to be.

Mathew
Keep up with me and what I’m up to: http://theillien.blogspot.com

Mathew Snyder wrote: