[Zope] using capitalize in dtml-var in sqlmethods
Tue, 10 Jun 2003 10:55:42 +0200
At 00:24 10/06/2003 -0700, Dennis Allison wrote:
>I think Dieter introduced a bit of syntatic confusion with nothing to do
>with capitalization. The problems with the column attirbut come from the
>fact that <dtml-sqlvar ... > does not have a column attribute.
><dtml-sqltest ...> does.
>Presumably you are passing into a query something as a parameter that you
>want to ensure is capitalized in the database. You have the choice of
>it before it is passed to the query or capitalizing it in the query.
>I presume you have chosen the latter course.B
>If that is the case, presumably you need to use sql that looks like
>INSERT INTO sometable VALUES(
> <dtml-sqlvar expr="project_title.capitalize()">, .... );
>I'm pretty sure this will work but have not tested it.
Yes that works a treat, thanks very much!!!
Web Task Force
European Synchrotron Radiation Facility
38043 Grenoble Cedex
Tel: (33) 04 76 88 21 86
Fax: (33) 04 76 88 24 27