Community Server

Hey Mike,

Last year you helped me setup the football pool with 2 schedule databases. one full database for stats and a dulled down DB for games played(skipping Thursday games). I have been able to find the steps to set that up.

BUT...

When you were helping with the NHLpool you wrote some new code which gave the admin checkboxes to includes games he wanted, and only had 1 schedule DB. This was a better way of doing it. I'm sure a lot of people would love this in the NFL pool too.

However I cant find the instructions anywhere from when we set that up.

you have that?

Thanks

 started going through the code in the NHLpool and finding the differences in reference to the include in pool stuff

Made the 3 edits in the common.asp file

Made a bunch of changes in updateschedule.asp and weeklyentry.asp

added the column to the schedule DB

Looks good going into update schedule as admin(cosmetic issue bottom bar doesnt go all the way across to meet new column)

selected all games for week2 except the thursday and the 1 friday and submit

get the following error:

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression '#7:30:00 pm# IncludeInPool = false'.

/drizzt09/NFLpool/updateSchedule.asp, line 81

--------------------------------------------------------

This is line 81: call DbConn.Execute(sql)

******************************************************

When going to weekly pool entry form as a user i gt the following error:

Microsoft VBScript runtime error '800a0009'

Subscript out of range: 'UBound(...)'

/drizzt09/NFLpool/weeklyEntry.asp, line 1087

---------------------------------------------------------------------

This is line 1087: tbTitle = "Total points in the <strong>" & games(UBound(games)).visitorName & " at " & games(UBound(games)).homeName & "</strong> game"

 I'll have to look into that, I recall that we got bit a few times with the NHL pool but basically you just have to check every call that pulls data out of the Schedule table to make sure you're getting what the games you want.

 ok i resolved the updatescores and updateschedules

Just the weeklyEntry.asp thats not working. any ideas?

*************************************************************

Microsoft VBScript runtime error '800a0009'

Subscript out of range: 'UBound(...)'

/drizzt09/NFLpool/weeklyEntry.asp, line 1087

*************************************************************

Used examdif to check the difference

NHL:

        'Get the tiebreaker game (total goals scored).
        dim tbTitle, tbStr
        tbTitle = "Total goals scored"

NFL:

        'Get the tiebreaker game (the last scheduled game of the week).
        dim tbTitle, tbStr
        tbTitle = "Total points in the <strong>" & games(UBound(games)).visitorName & " at " & games(UBound(games)).homeName & "</strong> game"

i used examdiff and went through everything and got this solved