Hi<BR><BR>I have an RS that i&#039;ve created thus:<BR><BR> SQL = "{call sp_get_Future_Films_News}";<BR> var rsN = cn.Execute(SQL);<BR><BR>Here&#039;s the sproc:<BR><BR>CREATE PROCEDURE [sp_get_Future_Films_News] <BR><BR>AS<BR><BR>SELECT T1.Id, T1.Title, T1.Trail, T1.Body, T1.Date, T3.FF_ID<BR>FROM news T1 INNER JOIN (Future_Films_X_News T2 INNER JOIN Future_Films T3 ON T2.FF_ID = T3.FF_ID) ON T1.ID = T2.NEWS_ID<BR>WHERE T3.ACTIVE = 1<BR>ORDER BY T1.Date DESC<BR><BR>Problem is when I apply the following filter:<BR><BR> rsN.Filter = "FF_ID = " + ffID; // ffID relates to the id column of the Future_Films table in the sproc above.<BR><BR>The date (only the date!) column goes blank - all the fields in that column appear to be empty. It&#039;s fine again if you remove the filter<BR><BR>What the feck is going on?<BR><BR>Cheers,<BR><BR>Matt<BR><BR>