Hi,

I have a database with a column which I have a number to represent some text (this is to keep the database small). Eg. 1 = "Monday", 2 = "Tuesday" etc. When the database is displayed in the browser, how can I display Monday, Tuesday etc instead of 1,2 etc.

Thanks in advance for any advice.

Jamie

add this code where you want to display the Date and replace the name of your fields and recordsets where required.

<%

Select Case yourrecordsetname("fieldname"

Case 1

Response.write("Monday"

Case 2

Response.write("Tuesday"

Case 3

Response.write("Wednesday"

Case 4

Response.write("Thursday"

Case 5

Response.write("Friday"

Case 6

Response.write("Saturday"

Case 7

Response.write("Sunday"

End select
%>

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

or maybe...

<pre id=code><font face=courier size=2 id=code>
&lt;%= WeekdayName(varDay,,2)
%&gt;
</font id=code></pre id=code>


varDay will be your numeric value...

Edited by - leed on 15 Jul 2003 11:31:53

hmmm...one of the two solutions you have looks a tad tidier than the other.....(go with leed!)



Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

Hi leed,

Please can you expand on your solution. I am not too sure how this would be implemented.