Formatting Data Results...proper case
in [ASP]
|
Prev: ؛؛الدلع على أصولة...بالصور؛؛
Next: pass cookie in two domains work in IE, but not working in firefox?
From: CD on 9 Apr 2008 12:33 I have a asp page pulling results from an Access DB. I have no control of the data input to the db. All the information is entered in Upper case. It contains fields like address, city, etc.. DB data: AddressColumn: 123 BILL AVENUE format to 123 Bill Avenue Is there a way to format the data on the webpage in proper case with a fucntion or routine? I am not a programmer by trade but can follow logic. TIA CD
From: Mike Brind [MVP] on 9 Apr 2008 16:07 "CD" <mcdye1(a)hotmail.REMOVETHIS.com> wrote in message news:ePmWA%23lmIHA.4076(a)TK2MSFTNGP05.phx.gbl... >I have a asp page pulling results from an Access DB. I have no control of >the data input to the db. All the information is entered in Upper case. >It contains fields like address, city, etc.. > > DB data: > AddressColumn: 123 BILL AVENUE format to 123 Bill Avenue > > Is there a way to format the data on the webpage in proper case with a > fucntion or routine? I am not a programmer by trade but can follow logic. > > TIA > CD > http://classicasp.aspfaq.com/general/how-do-i-convert-a-name-to-proper-case.html -- Mike Brind Microsoft MVP - ASP/ASP.NET
From: CD on 15 Apr 2008 07:29 THANKS....excalty what I needed. "Mike Brind [MVP]" <paxtonend(a)hotmail.com> wrote in message news:uIMIS1nmIHA.4292(a)TK2MSFTNGP04.phx.gbl... > > "CD" <mcdye1(a)hotmail.REMOVETHIS.com> wrote in message > news:ePmWA%23lmIHA.4076(a)TK2MSFTNGP05.phx.gbl... >>I have a asp page pulling results from an Access DB. I have no control of >>the data input to the db. All the information is entered in Upper case. >>It contains fields like address, city, etc.. >> >> DB data: >> AddressColumn: 123 BILL AVENUE format to 123 Bill Avenue >> >> Is there a way to format the data on the webpage in proper case with a >> fucntion or routine? I am not a programmer by trade but can follow >> logic. >> >> TIA >> CD >> > > http://classicasp.aspfaq.com/general/how-do-i-convert-a-name-to-proper-case.html > > -- > Mike Brind > Microsoft MVP - ASP/ASP.NET >
From: McKirahan on 15 Apr 2008 08:25
"CD" <mcdye1(a)hotmail.REMOVETHIS.com> wrote in message news:eK#UuvunIHA.5368(a)TK2MSFTNGP04.phx.gbl... > THANKS....excalty what I needed. > > http://classicasp.aspfaq.com/general/how-do-i-convert-a-name-to-proper-case. html "there is no universal way ... to handle proper casing correctly, 100% of the time." For example, DuPont, O'Leary, von Furstenburg, et.al. |