[Zope] Newbie date/time + MySQL problem

[Eric L. Walstad]

Jeff, Working from Monty's lead, this is what worked perfectly for me:
----------------------------------------------------------------------------
----
FirstName   LastName   BDay
Eric        Walstad    May 7th, 1966

----------------------------------------------------------------------------
----
SQL used:

select FirstName, LastName, date_format(Birthday, '%M %D, %Y') as BDay
FROM users
WHERE
FirstName = 'Eric'
and
LastName = 'Walstad'

Thanks Monty!

Eric.


// -----Original Message-----
// From: mtaylor@camelot.information-innovation.com
// [mailto:mtaylor@camelot.information-innovation.com]On Behalf Of Monty
// Taylor
// Sent: Tuesday, April 25, 2000 11:32 AM
// To: jeffr@odeon.net
// Cc: Yanko, Curtis (GSP); zope@zope.org
// Subject: Re: [Zope] Newbie date/time + MySQL problem
//
//
// You're probably right, Zope probably doesn't see the date as a date, but
// as a string. Try:
//
//   select date_format(date,'%b %e, %Y') as date from table
//
// In your SQL query. I'm sure there's a way to map that to a Zope date,
// but if you just need the string, this might be a temp. fix.
//
// Monty
//
// jeffr@odeon.net wrote:
// >
// >         Hmm, that didn't work.  I get a Zope error of:
// >
// >                 Error Type: TypeError
// >                 Error Value: not all arguments converted
// >
// >         What I think is the relevent portion of the traceback shows:
// >
// >   File /usr/local/Zope/lib/python/DocumentTemplate/DT_Var.py,
// line 313, in render
// >     (Object: date)
// >     (Info: ('date', '2000-04-25', {'null': '', 'fmt':
// 'aCommon', '': 'date'}))
// >
// >         I think the problem is the string returned from MySQL isn't a
// >         date object as far as Zope is concerned.
// >
// >         Any help is appreciated,
// >
// >         Jeff
// >
// > On Tue, 25 Apr 2000, Yanko, Curtis (GSP) wrote:
// >
// > > Just figured this one out myself a week or two ago. I use
// something like
// > > this:
// > >
// > > <dtml-var date fmt=aCommon>
// > >
// > > If you are using a Zope Date/Time object, this should work.
// > >
// > > -Curt
// > >
// > > > -----Original Message-----
// > > > From:       jeffr@odeon.net [SMTP:jeffr@odeon.net]
// > > > Sent:       Tuesday, April 25, 2000 12:02 PM
// > > > To: zope@zope.org
// > > > Subject:    [Zope] Newbie date/time + MySQL problem
// > > >
// > > >
// > > >     Greetings folks,
// > > >
// > > >     I've got a record in an SQL database that contains a date
// > > >     field (2000-02-25 for example).
// > > >
// > > >     I'm generating a table from an SQL query.  The bit
// that displays
// > > >     the date is pretty simple: <dtml-var date null="">
// > > >
// > > >     I want to format the date into something a little more readable
// > > >     (like 'Feb 25, 2000' for example).  I've been trying
// to figure out
// > > >     how to use the date-time format functions mentioned in the DTML
// > > >     guide in Appendix A.  It mentions the special variable _, which
// > > >     provides a method for constructing date time values
// from strings
// > > >     and numeric data.
// > > >
// > > >     I think my question is really a matter of syntax, as the DTML
// > > >     guide doesn't provide any examples of usage in Appendix A.
// > > >
// > > >     Would I use something like: <dtml-var _.aCommon(date)
// null=""> ?
// > > >
// > > >     Any help would be greatly appreciated,
// > > >
// > > >     Jeff
// > > >
// > > >
// > > > _______________________________________________
// > > > Zope maillist  -  Zope@zope.org
// > > > http://lists.zope.org/mailman/listinfo/zope
// > > > **   No cross posts or HTML encoding!  **
// > > > (Related lists -
// > > >  http://lists.zope.org/mailman/listinfo/zope-announce
// > > >  http://lists.zope.org/mailman/listinfo/zope-dev )
// > >
// > > _______________________________________________
// > > Zope maillist  -  Zope@zope.org
// > > http://lists.zope.org/mailman/listinfo/zope
// > > **   No cross posts or HTML encoding!  **
// > > (Related lists -
// > >  http://lists.zope.org/mailman/listinfo/zope-announce
// > >  http://lists.zope.org/mailman/listinfo/zope-dev )
// > >
// >
// > _______________________________________________
// > Zope maillist  -  Zope@zope.org
// > http://lists.zope.org/mailman/listinfo/zope
// > **   No cross posts or HTML encoding!  **
// > (Related lists -
// >  http://lists.zope.org/mailman/listinfo/zope-announce
// >  http://lists.zope.org/mailman/listinfo/zope-dev )