Snitz Forums 2000 - Not that again! "exception occurred"

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

Not that again! "exception occurred"

New Topic

Topic Locked

Printer Friendly

Author

Topic

Alfred
Senior Member

USA
1527 Posts

Posted - 01 September 2003 : 16:57:27

quote:
Error Type:
(0x80020009)
Exception occurred.
/BG/forums/Admin_Games_AddGame_handler.asp, line 69

This is a file which has worked perfectly fine for quite a while now, and suddenly gives this error.
txt version here: http://www.ggholiday.com/bg/forums/Admin_Games_AddGame_handler.txt

Alfred
The Battle Group
CREDO

laser
Advanced Member

Australia
3859 Posts

Posted - 01 September 2003 : 17:45:50

line 69 is :

strSql = strSql & "RESULT, VICTOR) VALUES (" & _

I doubt you can ever get that error on that line, how 89 maybe ??

Anyway, use all the normal debug tools - do a "Response.Write strSql", etc... and try to diagnose more. Could it be that the challenger &/or victor don't exist ?, or one of them is not on the ladder ?,etc ...

altisdesign
Junior Member

United Kingdom
357 Posts

Posted - 01 September 2003 : 17:49:05

Line 69 isn't just:
strSql = strSql & "RESULT, VICTOR) VALUES (" & _

Doesn't it apply to all this as well?


strSql = strSql & "RESULT, VICTOR) VALUES (" & _
	"'" & request.form("TYPE") & "'," & _ 
	"'" & request.form("CHALLENGER") & "'," & _
	"'" & thisChallenger("ladder_spot") & "'," & _
	"'" & request.form("DEFENDER") & "'," & _
	"'" & thisDefender("ladder_spot") & "'," & _
	"'" & request.form("SCENARIO") & "'," & _
	"'" & thisEQUIP("EQUIP") & "',"

Because they are joined up using & _ so get treated as one line... I'm not sure what the problem is, but it may help you debug...

Altis Design offers all manner of web design services to a variety of commercial and personal clients

Alfred
Senior Member

USA
1527 Posts

Posted - 01 September 2003 : 18:43:53

Going through our steps, laser...
This is the file that adds newly started games, so I took out the items which cannot be in the form yet, like result, etc.

The response.write strSql even gives the error!

quote:
Error Type:
(0x80020009)
Exception occurred.
/BG/forums/Admin_Games_AddGame_handler.asp, line 65

txt file is updated!http://www.ggholiday.com/bg/forums/Admin_Games_AddGame_handler.txt

PS.: I can't believe it, but I did some actual debugging - with success!
First I made sure to enter the A.I. as a player name in the database, and then I found a little coma which caused a "syntax error in insert into statement" (it was at the end of all fields)!

Alfred
The Battle Group
CREDO

Edited by - Alfred on 01 September 2003 19:42:31

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.34 seconds.