MOD:Topic Count (MSSQL version)

stupid SQL query language spaces I missed the darn space in red between the table field name and double quotes

------------

'Initalise the strSQL variable with an SQL statement to query the database to get the number of posts the user has made
 strSQL = "SELECT " & strDbTable & "Author.No_of_posts, " & strDbTable & "Group.Special_rank, " & strDbTable & "Author.No_of_topic " & _
 "FROM " & strDbTable & "Author " & strDBNoLock & ", " & strDbTable & "Group " & strDBNoLock & " " & _
 "WHERE " & strDbTable & "Author.Group_ID=" & strDbTable & "Group.Group_ID " & _
  "AND " & strDbTable & "Author.Author_ID=" & lngLoggedInUserID & ";"

--------------------

works like a charm ....will upload the changes in files and complete the mod :P