Can javascript format text based on db results? [Archive]

dito

04-10-2004, 10:09 PM

Is there a way with javascript?
I have a frontpage .asp page that returns the results of a query. Is it possible to have javascript do some dynamic formatting of the data? i.e. if the date is older than today, color the text red, or if the field contains a specified value, make it bold...?

PErickson87

04-10-2004, 10:29 PM

dito could you paste the asp code so we all know the variables?

dito

04-10-2004, 11:11 PM

Here's a frontpage test that I'm experimenting with. I'd like the javascript about 1/2 way down this page to change the color of the text in the EXPIRES data when the value equals today. The data in the field is in the format MM/DD/YYYY.
Thanks

<html>

<head>
</head>

<body>

<table width="100%" border="1">
<thead>
<tr>
<td>ITEM</td>
<td>PRODUCT</td>
<td>NOTES</td>
<td>EXPIRES</td>
</tr>
</thead>
<tbody>

<%
fp_sQry="SELECT * FROM T_FloorNotes"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=4 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Tester_Scheduler"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ITEM"
fp_sMenuValue="ITEM"
fp_iDisplayCols=4
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<%
if EXPIRES = New Date() then
clr = "FF0000"
Else
clr = "000000"
End if
%>



<tr>
<td><%=FP_FieldVal(fp_rs,"ITEM")%>
</td>
<td><%=FP_FieldVal(fp_rs,"PRODUCT")%>
</td>
<td><%=FP_FieldVal(fp_rs,"NOTES")%>
</td>
<td><%=clr%>'><%=FP_FieldVal(fp_rs,"EXPIRES")%>
</td>
</tr>


</tbody>
</table>

</body>

</html>

PErickson87

04-11-2004, 12:00 AM

I'm not entirely sure how to encorporate the JavaScript with the rest of the coding... but here's the code to put today's date into that format for anyone who does know:

<script>
var time=new Date();
var lmonth=time.getMonth()+1;
if (lmonth < 10) {lmonth='0'+lmonth;}
var date=time.getDate();
if (date < 10) {date='0'+date;}
var year=time.getYear();

today=lmonth+'/'+date+'/'+year;
</script>

I would imagine it would have to be written like:

var expireDate="<%=FP_FieldVal(fp_rs,"EXPIRES")%>";
if (expireDate == today) {
document.write('<%=FP_FieldVal(fp_rs,"EXPIRES")%>');
}
else {
document.write('<%=FP_FieldVal(fp_rs,"EXPIRES")%>');
}

Something like that. Good luck.