Reputation: 1 Apprentice
- Active Members
- Active Posts:
- 107 (0.16 per day)
- 31-January 12
- Profile Views:
- Last Active:
- Apr 13 2012 01:12 PM
- Dream Kudos:
Posts I've Made
Posted 8 Apr 2012er
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.
Posted 8 Apr 2012Well 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!
Posted 7 Apr 2012@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
Posted 7 Apr 2012Yeah, 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.
Posted 2 Apr 2012@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
- Member Title:
- D.I.C Head
- Age Unknown
- Birthday Unknown
meowbits hasn't added any friends yet.