er

I have it in a try catch block.


*For anyone else wondering... I just shifted my for loop around and put a continue for inside the catch.

Well after determining that the query was correct I went through the code to find the data problem. Took a while (messy code, refine that once I get a working version) BUT I found it. Turns out I had set a line that was erasing one of the columns in my team_schedule. Making the query overlook all the rows...

Got rid of the line, ran the program once and the query worked perfectly

Thanks for the help, really appreciate it!

@Charlie - I never thought of that. Thanks for the great tip I did as you said and it says zero rows affected.

@Ionut - seasonId does have values of 0, and gameId has 1.

Thanks for the suggestions

Yeah, the query loaded data into the table once before. Everything looked good. I deleted the data because I had too many rows in another table, tried it again and nothing happened.

Pretty sure I did not change anything between.. though I must have, that or it didn't work properly to begin with.

@modi I was just setting the default value as 20120101, have not actually used the table yet.

@nkode Thanks, I had it backwards. Switched it around and it works perfectly