Re: error in your SQL syntax near '(DATE_FORMAT... on adding date_hierarchy = 'pub_date'

Andy Dustman wrote: > ... [snip] ... > Your original error was: "You have an error in your SQL syntax near > '(DATE_FORMAT(`polls_poll`.`pub_date`, '%Y-01-01 00:00:00') AS > DATETIME) FROM `p' at line 1" I'm going to guess that the bit before > the leading parenthesis is "CAST", and CAST() does

Re: error in your SQL syntax near '(DATE_FORMAT... on adding date_hierarchy = 'pub_date'

On 6/12/06, Matt McClure <[EMAIL PROTECTED]> wrote: > > I received in a private email: > > Hello Matthew, > > > > I'm seeing the exact same "date_hierarchy" problem and was wondering > > if you received a solution offline and/or figured it out. > > > > Seems like the problem is somewhere among my

Re: error in your SQL syntax near '(DATE_FORMAT... on adding date_hierarchy = 'pub_date'

I received in a private email: > Hello Matthew, > > I'm seeing the exact same "date_hierarchy" problem and was wondering > if you received a solution offline and/or figured it out. > > Seems like the problem is somewhere among my Python 2.3.3, MySQLdb > 1.2.1 and the MySQL 3.23.53, 'cause I've got

error in your SQL syntax near '(DATE_FORMAT... on adding date_hierarchy = 'pub_date'

Bug? Or something I'm doing wrong? In tutorial part 2, just after adding date_hierarchy = 'pub_date' to my Poll.Admin class, when I reload the /admin/polls/poll/ page, I get: ProgrammingError at /mysite/admin/polls/poll/ (1064, "You have an error in your SQL syntax near '(DATE_FORMAT