Mailing List Archive


Back to the month index Back to the list index
Mike Black (mblack@csihq.com)
Fri, 13 Sep 1996 10:04:38 -0400 

Message-Id: <1.5.4.32.19960913140438.0094f07c@picard.csihq.com>
Date: Fri, 13 Sep 1996 10:04:38 -0400
From: Mike Black <mblack@csihq.com>
Subject: Re: [mSQL] [w3-msql] Upcasing??

At 04:41 PM 9/13/96 +1000, you wrote:
>Ok, I answered my last question by ummm, reading the manual :-)
>
>But another question, I have a form which can be used to isert into a
>database. Is there anyway of taking the text from this form and
>converting it to uppercase before it gets written?

I use:

<! msql translate $name1 'a' 'A' >
<! msql translate $name1 'b' 'B' >
<! msql translate $name1 'c' 'C' >
<! msql translate $name1 'd' 'D' >
<! msql translate $name1 'e' 'E' >
<! msql translate $name1 'f' 'F' >
<! msql translate $name1 'g' 'G' >
<! msql translate $name1 'h' 'H' >
<! msql translate $name1 'i' 'I' >
<! msql translate $name1 'j' 'J' >
<! msql translate $name1 'k' 'K' >
<! msql translate $name1 'l' 'L' >
<! msql translate $name1 'm' 'M' >
<! msql translate $name1 'n' 'N' >
<! msql translate $name1 'o' 'O' >
<! msql translate $name1 'p' 'P' >
<! msql translate $name1 'q' 'Q' >
<! msql translate $name1 'r' 'R' >
<! msql translate $name1 's' 'S' >
<! msql translate $name1 't' 'T' >
<! msql translate $name1 'u' 'U' >
<! msql translate $name1 'v' 'V' >
<! msql translate $name1 'w' 'W' >
<! msql translate $name1 'x' 'X' >
<! msql translate $name1 'y' 'Y' >
<! msql translate $name1 'z' 'Z' >

-
 /----------------------------------------------------------\
| Mike Black mblack@csihq.com 407-676-5118, x203 |
| Computer Science Innovations, Inc. 407-676-2355 FAX |
| Melbourne FL 32904-2314 http://www.csihq.com |
 \----------------------------------------------------------/

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!