[Zope] Uppercasing a string in a ZSQL method?

Scott Anderson sanderson@ttm.com
Tue, 28 Sep 1999 15:23:44 -0400


Actually, I'm trying to solve the problem for inserts, not selects, but
thanks anyways.

Regards,
-scott

tpatrick@IndigoNetworks.com wrote:
> 
> 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 )