Hi ALessandra, You can use in two ways: <dtml-var DIS06_UTENTE lower> and <dtml-var DIS06_UTENTE upper> or <dtml-var "_.string.upper(DIS06_UTENTE)"> and <dtml-var "_.string.lower(DIS06_UTENTE)"> So when you call the zsm to insert the input data you can use like this: <dtml-call "zsm_insert_DIS06(DIS06_UTENTE=_.string.lower(DIS06_UTENTE_form))"> Where the DIS06_UTENTE_form is the data inputed on the form. Cya -- Ze Octavio -- Hiperlógica <http://hiper.com.br> Automação de web-sites | Web-site automation São Paulo | Brasil | Fone: +55-11-8168067 Alessandra Pessolano wrote:
I have a Zsql Method with argument (for example) "DIS06_UTENTE" and the query template is the following;
select * from DIS06 where <dtml-sqltest DIS06_UTENTE type=string>
I want to insert my input data with the small letters and read it in the query template with the capital letters. What can I do? Thanks in advance for Your help
_______________________________________________ Zope maillist - Zope@zope.org 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 )