|
Blue Forest http://www.lslnet.com at 8:28 on August 25, 2006
 I have this (week ranked) in which mistakes. . Which, if the friend gets advice please
"Rs=server.createobject% set (" adodb.recordset ")
Rs.open "SELECT * FROM MusicList where datepart (ww, date) =datepart (ww, getdate ()) order by hits desc" conn,1,1
Sgl database. . I have this (week ranked) in which mistakes. . Which, if the friend gets advice please |
| Datepart (ww, date) =datepart (ww, getdate ()) bargain |
| Suggest anything wrong? Date first test with it into [date] |
Inquiries should be this week's data |
|
