Originally Posted by sinapra
after much frustration over the last couple of days posting on several forums etc i finally played around and read enough on the web to develop the code myself.
to answer your question i am using plain asp, and it is possible as i have done it. below is the code:
this was added after the db query but before the tables are drawn and data inserted.
x = CINT(FP_FieldVal(fp_rs,"Severity"))
if x <= 10 then
bgcolor = "#E42217"
elseif x => 11 and x <= 30 then
bgcolor = "orange"
elseif x => 31 and x <= 50 then
bgcolor = "yellow"
elseif x => 51 and x <= 70 then
bgcolor = "#82CAFF"
elseif x => 71 and x <= 90 then
bgcolor = "#41A317"
this was added to where the tables were drawn after the db has been queried.
Thanks for your reply though, i must say this and dbforums are the only two of the 5 forums i posted in i had a responce in.
final shot of the working site is attached