Of course, if you're only using the string in one place, or if you always
want it capitalized, then you should be able to do the conversion in your
database SQL to begin with:

select upper(column_name) from table_name;

Glen


----- Original Message -----
From: "Dang Minh Phuong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 10, 2004 5:08 AM
Subject: RE: How to capitalize text ???


> It works. Thank you very much.
>
> -----Original Message-----
> From: Wouter de Vaal [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 08, 2004 11:16 PM
> To: [EMAIL PROTECTED]
> Subject: Re: How to capitalize text ???
>
> You should use XSLT for this:
>
> <xsl:variable name="uppercase">ABCDEFGHIJKLMNOPQRSTUVWXYZ</xsl:variable>
>
> <xsl:variable name="lowercase">abcdefghijklmnopqrstuvwxyz</xsl:variable>
>
> <xsl:template match="text()">
>    <xsl:value-of select="translate(.,$lowercase,$uppercase)"/>
> </xsl:template>
>
> This will translate all lowercase text in XML to uppercase.
>
> Wouter
>
> ----- Original Message -----
> From: Dang Minh Phuong
> To: '[EMAIL PROTECTED]'
> Sent: Monday, February 09, 2004 3:50 AM
> Subject: How to capitalize text ???
>
>
> Hi all,
>
> I have a text received from the DB and put in xml file. Now I want to
> capitalize that text when showing it in PDF using FOP. How can I do that
???
>
> Thanks for your help.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to