| Author |
 Topic  |
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Alfred
Senior Member
USA
1527 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
 Posted - 28 October 2003 : 17:38:33
|
| yes, you should be able to, unless you've modified something in inc_header that closes the connection, but if you did, your regular forum pages wouldn't work. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
 |
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 17:53:05
|
That turned out ok, as you said.
The response test: quote:
response.write "<br>" & myReportGame("CHALLENGER")
response.end
shows that the Challenger name is present.
However, the error still appears when I comment it out. 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 : 18:07:39
|
okay, so leave that in and comment out the line after that where you create the recordset. do you still get the error then?
I just noticed that you have this line:
response.write Challaddress
You can't do that. You have to specify the field you want to print, like:
response.write Challaddress(0)
or
response.write Challaddress("M_NAME")
or the like. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
Edited by - Nikkol on 28 October 2003 18:10:04 |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 18:25:30
|
I can take that "response.write Challaddress" out alltogether, since it was only a test for a response.
And yes, when I comment out the 2 statement lines, it displays the response.write.
http://www.ggholiday.com/bg/forums/test.txt |
Alfred
The Battle Group
CREDO
|
Edited by - Alfred on 28 October 2003 18:26:47 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 19:22:19
|
No, we are at square one.
What I am after is the email address of the member: quote:
strSql = "SELECT M_EMAIL FROM FORUM_MEMBERS WHERE M_NAME = '" & myReportGame("CHALLENGER") & "'"
'set CHALLaddress = my_Conn.Execute(strSql)
but this select statement causes the error instead of eturning the address. |
Alfred
The Battle Group
CREDO
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 19:38:52
|
I actually commented it out, because I know that it won't return anything until the select statement works.
I also tested the strSql, and it looks ok: quote:
SELECT M_EMAIL FROM FORUM_MEMBERS WHERE M_NAME = 'sgt v'
|
Alfred
The Battle Group
CREDO
|
Edited by - Alfred on 28 October 2003 19:44:55 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 October 2003 : 19:50:25
|
quote:
Originally posted by Alfred
No, we are at square one.
What I am after is the email address of the member: quote:
strSql = "SELECT M_EMAIL FROM FORUM_MEMBERS WHERE M_NAME = '" & myReportGame("CHALLENGER") & "'"
'set CHALLaddress = my_Conn.Execute(strSql)
but this select statement causes the error instead of eturning the address.
so, having the set line commented out still gives you an error? and then if you comment out the strSql line, what happens? |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 20:11:22
|
No, with the "set" line out I get this display: quote:
Result: Default
Game #: 269
Campaign Attack
SELECT M_EMAIL FROM FORUM_MEMBERS WHERE M_NAME = 'sgt v'
Commenting out the strSql (select statement) line I get this display: quote:
Result: Default
Game #: 269
Campaign Attack
SELECT * FROM GAMES WHERE ID = 269
I suppose that reflects the last previous strSql. |
Alfred
The Battle Group
CREDO
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 October 2003 : 20:20:52
|
but do you get an error when you comment out the sql statement?
i'm heading to bed shortly, so hopefully someone else will chime in to help you. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 28 October 2003 : 20:59:13
|
No, Nikkol, I don't.
This is not urgent, but only a project for a new function I want my site to have.
SO, please - have a good night! |
Alfred
The Battle Group
CREDO
|
|
|
|
Topic |
|
Topic Locked
