There are two ways to solve the problem: 1. MODIFY THE METHOD AND OUTPUT TO THROUGH AND <DTML-IN> Modify the SQL METHOD: select name, upper(vid_code) <<-----THIS WILL RETURN THE vid_code in UPPERCASE from vid where ACCOUNT_TYPE='secondary' and BROADCAST_STATUS='ACTIVE' and ascii(substr(lower(name),1,1)) between 48 and 57 ORDER BY ascii(substr(lower(name),1,1)) When you view this via DTML in and <dtml-in> TAGS specify the variable as <dtml-var upper(vid_code)> We figured this out because the test output of the SQLMETHOD prints upper(vid_code). If I am incorrect on the syntax above look at the TEST output from the SQLMETHOD! It should work! 2. MODIFY THE OUTPUT VIA DTML with a FORMAT ATTRIBUTE: HELP ME OUT HERE!!! <dtml-in kdjfajdfljalfjafj> <dtml-var thevariable fmt="uppercase??"> <<< THIS IS ONE THAT I WOULD LIKE TO KNOW!! Hope this helps! Theodore E. Patrick http://www.ishophere.com - Where do you shop? -----Original Message----- From: Scott Anderson [mailto:sanderson@ttm.com] Sent: Tuesday, September 28, 1999 1:11 PM To: zope@zope.org 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 )