[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


returning proper case in asp query results for better display

Posted on 2006-05-29
Medium Priority
Last Modified: 2010-04-07
I have an intranet for my practice. I had several .asp pages developed so employees and docotors can see patient data in realtime. The .asp pages run various  queries that return data basically diplayed in table format.  The table is created with HTML.  The data is written cell by cell via response.write as follows:

 Do While Not rsData.EOF
  response.write "<tr>"
  response.write " <td>" & rsData("doctype") & "</td>"
  response.write " <td>" & rsData("acctno") & "</td>"
  response.write " <td>" & rsData("patln") & ", " & rsData("patfn") & "</td>"
  response.write " <td>" & rsData("dateinj") & "</td>"  etc

All data is displayed in uppercase -- I would like to find a way to see proper case -- as most data should be for the sake of my intranet. I have tried to use the "transform-text: capitalize" however this only effects the HTML / table and has no effect on the data that is rendered after the .asp query runs. I would appreciate any advice. Thank You!
Question by:drfjf
  • 3

Expert Comment

ID: 16791016
I typically write a server side ASP function called PCase that converts strings to proper case.

If you tell me which version of ASP you are using (6, .Net), I will give you an example to use.

LVL 35

Accepted Solution

mrichmon earned 1000 total points
ID: 16791215
You need to realize that you can never get 100% accurate.

However, what I use is a function in SQL server that proper cases the data as it is pulled from the server.

I started with the above and massaged to include more cases that our organization needed.  You can do the same.

Assisted Solution

ExpertAdmin earned 1000 total points
ID: 16791406
mrichmon is right. There will be cases where there is a title (Such as DVM, DDM, etc) that will end up being Dvm & Ddm. The only way I have found to handle this is with an exceptions list that must be maintained. So there isn't a simple way to create a foolproof Proper Case function.


Expert Comment

ID: 17051842
Sounds good.


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question