I am working with a friend on a Mod to display the last 5 posts on the forum on my frontpage (portal). Our idea was to show subject/author/date and the first few lines of text of the post in a special format. We had some problems with the simple slash mod and decided to make our own Mod and customize it to our needs.
We have coded some of the mentioned features but we seem to have made an error in the database (mysql) connection code.
Error message:
ADODB.Recordset error '800a0e7d' The connection cannot be used to execute this query. The connection is closed or not valid in this context
/snitz/lastpost.asp, line 29 line 29 reads: sql_results.open sql_query, sql_conn
set sql_conn=Server.CreateObject("ADODB.Connection")
set sql_results=Server.CreateObject("ADODB.Recordset")
'execute query and award to sql_results
sql_results.open sql_query, sql_conn
if sql_results.BOF and sql_results.EOF then
although you have told it that sql_conn is a recordset, you have not opened a database. you need a line like sql_conn.open YOURCONNECTIONSTRING
Topic Locked
Posted - 20 March 2004 : 04:05:07
