LOGIN
User Name
Password
Remember me


> Not a member yet?
> Forgot your password?
Main menu
Preferred site
Get Firefox!
Forum Message
City:North York CA
Personal Data:Male, born: March 09 1968
HomePage or other cool site:http://https://worldofwarships.com/
Membership18years 264days ago.
Last Login7years 224days ago.
Last Move7years 212days ago.
dcr66 is currently Offline!Send a mail to dcr66

Message header
Area/Game:Wooden Ships & Iron Men
1Topic:Bugs and Improvements
Subject:Joining league not working - get SQL statement
Posted by: dcr66 - 14years 297days ago.
Message text
Here is the SQL statement I see:

Why don't you give me the IP of server and I'll try connecting to it using my SQL 2008 Management Studio? Maybe I can try to debug it for you!

5232282 -- SELECT Title=Case T.GameType WHEN 'BM' THEN (SELECT Title From Scenari SD WHERE SD.ScenarioID=T.ScenarioID) WHEN 'WS' THEN (SELECT Title From Scenari SD WHERE SD.ScenarioID=T.ScenarioID) ELSE ' End, T.GameType, T.SubType, T.BoardType, T.Options, T.IDTorneo AS ID,T.TotalGamesPerPlayer,T.TotalGames,T.TotalEndedGames,T.TotalDeletedGames,T.Started,T.DataFine,T.Status,T.Turning,T.IDVincitore,T.ScenarioID,T.AutoMoveTimeOut,T.Creator,D.GameName,D.TypeDescr,T.GamePlayers,T.TotalPlayers,T.Subscribed,T.ChallengePlayersList,T.ShortDescription,T.Password,T.DataCreazione,T.Comments FROM Tornei T,GamesDescr D Where T.GameType=D.GameType AND T.SubType=D.SubType AND T.BoardType=D.BoardType AND T.IDTorneo=1
5232282 -- NOTHING
5232282 -- INSERT INTO TorneiSubscribers (IDTorneo, UserID, TotalGames, TotalEndedGames, TotalDeletedGames, Placement, Score, SubScore, Events) VALUES (1,'dcr66',14, 0, 0, 0, 0, 0, NULL)
5232282 -- UPDATE Tornei SET Subscribed = 2 WHERE IDTorneo=1

Response object error 'ASP 0156 : 80004005'

Header Error

/beta/includes/databaseFunctions.asp, line 462

The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.
Messages thread
Posting elapsed timePosted bySubject

14years 297days dcr66 Joining league not working - get SQL statement
14years 297days Nick Re: Joining league not working - get SQL statement
Page generated in: 18.75 milliseconds.