asked on

returning proper case in asp query results for better display

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!

ExpertAdmin

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.

M@

ASKER CERTIFIED SOLUTION

mrichmon

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

ExpertAdmin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ExpertAdmin

Sounds good.

M@