Re: [Zope] Need to use a 'date' data type in sqltest

2000-06-20 Thread Dieter Maurer

Jones, David H writes:
 > I need to include a test of a date in a DTML variable referenced in a sqltest tag in 
 >ZSQL.  From reading documentation and testing, it does not appear that the 'date' 
 >data type is supported.
As fas as I know, SQL databases vary greatly in the representation
of times and dates.

If your database accepts string representations for date fields,
you could use an "dtml-var" (rather than "dtml-sqltest") with
an appropriate "fmt" argument.


Dieter

___
Zope maillist  -  [EMAIL PROTECTED]
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 )




Re: [Zope] Need to use a 'date' data type in sqltest

2000-06-19 Thread Marcel Preda

Subject: [Zope] Need to use a 'date' data type in sqltest


> I need to include a test of a date in a DTML variable referenced in a sqltest
tag in ZSQL.  From reading documentation and testing, it does not appear that
the 'date' data type is supported.
>
> Can anyone confirm/infirm this and suggest a solution/workaround?

I suppose that Zope supports every Python's type.

Maybe this will help you:










PM


___
Zope maillist  -  [EMAIL PROTECTED]
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] Need to use a 'date' data type in sqltest

2000-06-19 Thread Jones, David H

I need to include a test of a date in a DTML variable referenced in a sqltest tag in 
ZSQL.  From reading documentation and testing, it does not appear that the 'date' data 
type is supported.

Can anyone confirm/infirm this and suggest a solution/workaround?


Regards,

David H. Jones
Boeing Phantom Works,
Mathematics and Computing Technology
425-865-6924
425-865-2964 (FAX)
[EMAIL PROTECTED]

___
Zope maillist  -  [EMAIL PROTECTED]
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 )