heloo everyone am facing a problem in deleting a record from a table where the record had been posted for more than 7 days . the codes below are some tries that i have done but it didnot work , it give "type mismatch"
while not rs.eof sql1=" delete from post where date < = (select * from post where ("& date() &" - date) >= 7)" Set rs = cn.Execute(sql1) rs.movenext wend
and
while not rs.eof
sql1=" delete from post where ("& date() &" - date) >= 7)" Set rs = cn.Execute(sql1)
Topic Locked
Posted - 15 March 2005 : 15:00:52
