LOGIN
User Name
Password
Remember me


> Not a member yet?
> Forgot your password?
Main menu
Preferred site
Anno mille
Forum Message
City:North York CA
Personal Data:Male, born: March 09 1968
HomePage or other cool site:http://https://worldofwarships.com/
Membership19years 220days ago.
Last Login8years 181days ago.
Last Move8years 169days 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 - 15years 254days 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

15years 254days dcr66 Joining league not working - get SQL statement
15years 254days Nick Re: Joining league not working - get SQL statement
Page generated in: 15.625 milliseconds.