Data Access Pages question

[gb2299]

Hi,
Not sure if I am in the right forum?!?
I am asking on behalf of a colleague who is writing an application using Data Access Pages.
2 Questions...

1. He has written a Call logging system which is accessed thru a web browser. What he is trying to do now is write a piece of code which will change the colour of the call displayed if it is outstanding longer than 2 hours.
Have you any examples?

2. Do you know of any good books with working examples.

Thanks
Graham

 

[Bastien]

it is a simple test against the time...roughly like below
<%
if datediff(now(),inputdate)>(2 hours) then
response.write &quot;<font color = red>&quot;
else
response.write &quot;<font color = black>&quot;
endif

call_details</font>&quot;
%>

you will need to check the syntax on the datediff statement but this should help et you there... Bastien

There are many ways to skin this cat,
but it still tastes like chicken