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