[Zope] Newbie date/time + MySQL problem

[jeffr@odeon.net]

	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 )
>