[Zope] Uppercasing a string in a ZSQL method?

[Theodore Patrick]

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 )