| Author |
 Topic  |
|
Alfred
Senior Member
USA
1527 Posts |
 Posted - 27 October 2003 : 23:15:06
|
A search for this error message returned me nothing.
This is the statement that brought it on:
quote:
strSql = "SELECT * FROM FORUM_MEMBERS WHERE M_NAME = '" & myReportGame("CHALLENGER") & "'"
set CHALLaddress = my_Conn.Execute(strSql)
What would one usually suspect as the cause of it?
|
Alfred
The Battle Group
CREDO
|
Edited by - Alfred on 28 October 2003 00:29:09 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 10:37:01
|
It is the statement that causes it.
When I comment both lines out, the error is not present. |
Alfred
The Battle Group
CREDO
|
Edited by - Alfred on 28 October 2003 10:52:10 |
 |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 11:04:02
|
This is one of those error msg that does not give the line#! quote:
Error Type:
Response object, ASP 0185 (0x8002000E)
A default property was not found for the object.
/BG/FORUMS/GAME_RESULT_HANDLER.asp
|
Alfred
The Battle Group
CREDO
|
Edited by - Alfred on 28 October 2003 11:05:48 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 14:22:52
|
That was my first suspicion as well, so I tested the return on: quote:
response.write "<br>" & myReportGame("CHALLENGER")
response.end
strSql = "SELECT * FROM FORUM_MEMBERS WHERE M_NAME = '" & myReportGame("CHALLENGER") & "'"
set CHALLaddress = my_Conn.Execute(strSql)
and it displayed the name correctly. |
Alfred
The Battle Group
CREDO
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 October 2003 : 15:17:53
|
| I know redbrad0, it shouldn't. I'm only going on the information that Alfred has given us, which is that those lines are causing the problem. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 15:30:12
|
Yes, that is what I had first: quote:
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
strSql = "SELECT M_EMAIL FROM FORUM_MEMBERS WHERE M_NAME = '" & myReportGame("CHALLENGER") & "'"
set CHALLaddress = my_Conn.Execute(strSql)
I only tested with '*' later.
Yes, redbrad - there is code above it, but it uses an earlier connection. |
Alfred
The Battle Group
CREDO
|
Edited by - Alfred on 28 October 2003 15:32:34 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 October 2003 : 15:35:21
|
| why are you creating a new connection to the database? If you have closed the connection previously, then the recordset myReportGame is no longer valid. If you have not closed it then you are attempting to reopen when it's not needed, which will cause problems. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 16:38:32
|
Yes, Nikkol, what you say here is something I had learned just recently, which is why I started out without opening a new connection.
When I got the error first (same kind as now) I thought it must be because it wants me to open a connection.
When I comment it out I get the same error. quote:
'set my_Conn = Server.CreateObject("ADODB.Connection")
'my_Conn.Open strConnString
'response.write "<br>" & myReportGame("CHALLENGER")
'response.end
strSql = "SELECT M_EMAIL FROM FORUM_MEMBERS WHERE M_NAME = '" & myReportGame("CHALLENGER") & "'"
set CHALLaddress = my_Conn.Execute(strSql)
quote:
Error Type:
Response object, ASP 0185 (0x8002000E)
A default property was not found for the object.
/BG/FORUMS/GAME_RESULT_HANDLER.asp
|
Alfred
The Battle Group
CREDO
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 October 2003 : 16:42:52
|
| why don't you post a link to a text version of the page and specify the line number that is giving the problem. it's impossible to tell what is going on without seeing what else you are doing in the code. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 October 2003 : 17:24:50
|
| on line 34 you are opening another connection to the database. there is already a connection established in inc_header and it is closed in inc_footer. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Topic |
|
Topic Locked
