Hi,

have just starting AspDB Pro. and I ma having problem with setting color of the field names in the header of the Grid. It gives "color=4" at the bottom of the grid also even though there's no X.dbColor="4,XXX" in the whole program

This is giving me grief as I need to stay consistent with the color scheme of the rest of the site.

Any help is appreciated.

Here's tyhe Code
-------------------------
<% response.buffer=true %>
<!--ASP-db-->
<HTML>
<HEAD><title>Consultant Project Relationship Screen</title>
</HEAD>
<BODY BGCOLOR=&#34;FFFFFF&#34; TEXT=blue ALINK=&#34;red&#34; VLINK=&#34;red&#34;>
<FONT FACE=&#34;Arial,Helvetica&#34; COLOR=red size=4>

<%
response.write(&#34;<BR><CENTER>Consultant & Project Relation</CENTER></BR>&#34
%>
<HR SIZE=2>
<%
Set MyDb = Server.CreateObject(&#34;AspDB.Pro&#34
Mydb.dbColor=&#34;ffffff,000000,ffffff,000000&#34;
Mydb.dbUnit = 2
Mydb.dbReset(2)
Mydb.dbDBType = &#34;SQL&#34;
Mydb.dbOptions = &#34;DateWrap=&#39;&#34;
PI=Request(&#34;SQLName&#34
DT=Request(&#34;SQLDate&#34
response.write(&#34;<BR><H5><CENTER>Week Ending Date = &#34; & Month(DT) & &#34; / &#34; & Day(DT) & &#34; / &#34; & Year(DT) & &#34;</CENTER></H5></BR>&#34
If PI=&#34;&#34; then
PI = Session(&#34;SesSQLName&#34
DT = Session(&#34;SesSQLDate&#34
end if
if (PI <> &#34;&#34 then &#39; Is this the first time in? If so, set the session
Session(&#34;SesSQLName&#34 = PI &#39; variable so the user&#39;s entry will be remembered.
Session(&#34;SesSqlDate&#34 = DT
end if
&#39;LOCALSQL = Session(&#34;SesSQLName&#34 + &#34;%&#34; &#39; Add the wildcard character.
Mydb.dbDSN=&#34;DSN=KIMTEST;UID=sa;PWD=;&#34;
MyDb.dbGridtabletag = &#34;border=1 cellpadding=2&#34;
&#39;MyDb.dbMode = &#34;Grid&#34;
&#39;Mydb.dbNameMap = &#34;date, Entry Date,bgcolor=white;week_ending_date,Weekend Date,bgcolor=white;actual_hours,Hours,bgcolor=whit e;personname,Name,bgcolor=white;task_name,Task Name,bgcolor=white;name,Project Name,bgcolor=white;person_id, Person ID,bgcolor=white&#34;
MyDb.dbSQL = &#34;SELECT personname,name,task_name,date,actual_hours FROM view_consultant_project WHERE person_id = &#34; & Cint(PI) & &#34; AND Week_Ending_Date = &#39;&#34; & Cstr(DT) & &#34;&#39;&#34;
&#39;Mydb.dbNavigation=&#34;&#34;
Mydb.dbnavigationitem=&#34;Color&#34;
Mydb.dbGridHideDuprecFlds = &#34;personname&#34;
Mydb.dbGridColSortHideFlds = &#34;0,1,2,3,4&#34;
MyDb.AspDBPro
RECS = MyDb.dbRecordCount
%>
<% if RECS < 1 then %>
<BR><FONT SIZE=4 COLOR=red><I><B>
No records were found!<BR>
Please hit the Back button and try again!<BR></B></I></FONT>
<% end if %>
</FONT>
</BODY>
</HTML>