[Zope] using capitalize in dtml-var in sqlmethods

Marie Robichon robichon@esrf.fr
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
>    <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!!!

Marie Robichon

Web Task Force
European Synchrotron Radiation Facility
BP 220
38043 Grenoble Cedex


Tel: (33) 04 76 88 21 86
Fax: (33) 04 76 88 24 27