[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 
>capitalizing
>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!!!


Marie Robichon

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

http://www.esrf.fr

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