[Zope] Uppercasing a string in a ZSQL method?

[Jim Sanford]

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 )