convert mod 2 sql

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Now that i've succeeded converting my forum to use sqlserver 2000, I wonder how easy/difficult it is to convert mods. 
Do I have to create new stored procedures, or is it much simpler than that?
I'm starting with the news mod I use and would like to see one example of how to convert a sql statement, or any info that could help me on the way. 

Here's part of the code and old sql statements..I have no idea where to start. 

<%
'Create  DSN Less connection to Access Database
'Create DBConnection Object
Set DBConnection = Server.CreateObject("adodb.connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.Mappath("xx.mdb")
DBConnection.Open DSN
'Set amount of post to be displayed.
numnews = 9
'Set forum number to list news from
frmnum = 23
'The message will be truncated at the first space after this number of characters
intTruncate = 100000
'Count the Records 
   SQLcount = "Select * From tblTopic Where Forum_ID ="&frmnum&" and Priority <1"
      Set RS = DBConnection.Execute(SQLcount)

 Select Case RS.eof
      Case False
        tempRSCount = RS.getrows
        Set RS = Nothing
        count = Cdbl(UBound(tempRSCount, 2)) + 1

     Case True
      count = "0"
 End Select
     Set RS = Nothing

       IF count > 0 Then
       IF count > numnews Then
       count = numnews
       Else
    End IF

      while not count = 0
      count = count - 1

  SQL = "Select * From tblTopic Where Forum_ID ="&frmnum&" and Priority <1 ORDER BY Topic_ID DESC"
      Set RS = DBConnection.Execute(SQL)

Edited by Badaboem