This should work. (It works for me.) <dtml-sqlvar "_.upper(sNewAcctNo)" type=string> Jim Sanford Accelerated Technology jsanford@atinucleus.com -----Original Message----- From: Scott Anderson <sanderson@ttm.com> To: zope@zope.org <zope@zope.org> Date: Tuesday, September 28, 1999 1:21 PM Subject: [Zope] Uppercasing a string in a ZSQL method? I've tried the following to change a string to upper case in a ZSQL method: <dtml-sqlvar sNewAcctNo type=string upper> (doesn't work; sqlvar doesn't define 'upper') <dtml-let sNewAcctNo="_.upper(sNewAcctNo)"> (doesn't work; exceptions.AttributeError) <dtml-let sNewAcctNo="string.upper(sNewAcctNo)"> (doesn't work; exceptions.NameError) <dtml-let sNewAcctNo="upper(sNewAcctNo)"> (doesn't work; exceptions.NameError) What am I missing? Thanks in advance, -scott _______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope (To receive general Zope announcements, see: http://www.zope.org/mailman/listinfo/zope-announce For developer-specific issues, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )