I'm getting this error, on the personal page MOD (my.asp):
ADODB.Recordset.1 error '80004005'
SQLState: 42000 Native Error Code: 1064 [TCX][MyODBC]You have an error in your SQL syntax near '5 FORUM_FORUM.F_SUBJECT, FORUM_TOPICS.T_STATUS, FORUM_TOPICS.T_VIEW_COUNT, FORUM' at line 1
Can you give us the entire SQL statement that it is trying to execute (the value from strSql)? It is saying your syntax is wrong and we need to see the entire thing to help you correct it.
Looks like maybe it is trying to do a TOP 5 ... statement, which will not work on mySQL. Can you post a link to a text version of my.asp?
There is a function in the code called TopSQL I believe, which changes the TOP statement to a mySQL friendly LIMIT, if you post the link to the file I mentioned above, I or someone else will help you amend it
Topic Locked
Posted - 26 June 2003 : 03:51:38
