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: > 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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
