ASP Football Support Forum

Yes, that is correct. It is not part of the ASP FootballPool application.

Attached please find two files. One contains the compiled program, UpdatePointSpreads and the other contains the c# source files for use with Visual Studio 2010.

The program requires that you modify the UpdatePointSpread.exe.config file to update the connection string with the properties describing ...

THIS PROGRAM NEEDS SOME MORE TESTING....A NEW VERSION TO BE RELEASED SHORTLY

I am working on a fully automated version that will take the information from the footballlocks website and populate the website with point spreads. I hope to have this finished within the next few days. I had a version; but there waqs a problem if you tried to update point spreads after the ...

Attached find my version of the Football Pool files updated for use with SQL Server 2012. Note as I do not use the Survivor Pool capabilities there may be some issue with the SQL Statements. However, I feel confident that the base code works. Now for the changes:

a. The connection String is found ...

Mike,
Do you have the code for SQL version of PayPal? I sure could use a copy. Thanks

Mike Hall has done a FANTASTIC job in keeping this code up and running, including the Forums. However, I think it may be time to convert to SQL Server and ASP.NET based code. I have started this work several times; but have never completed the work. Anybody else working on this conversion?

I have a "trial" version of the Football Pool for 2015/2016 Season that is hosted on the MS SQL Server 2012 database instead of Access. This conversion required some minor modifications to some of the SQL statements in the code. Please contact me at zass38@gmail.com if you are interested. Note ...

Anybody have a zip file for MySQL? GoDaddy, among other ISPs, are no longer supporting Access as the result of Microsoft closing support for earlier versions of their server software. Thanks in advance for any help in the regard.
Hans Zassenhaus

I found the cause of the issue. The database query in the GetWeeklyTiebreakerActual(week) is not correct in the weekly.asp file, starting at line 238. The current query treats the VisitorScore and the HomeScore as numberics; but the database definition is that these are text fields. thus, for the ...

I had a case this past weekend where the incorrect winner was selected, based on Tie Breaker Points. The combined points for Mondays game was 44 points. One person had TB point guess of 59 and the other a TB guess of 44 (difference of 7 points). The winner that was recorded had the TB guess of 59 ...

Issue resolved!

this is the effect if the configuration file has the USE_POINT_SPREADS flag set to true. I did not understand the effect based on the information in the configuration file, config.asp. When I set the flag to false, the expected results appeared.

My bad; but we probably need a ...

An update.... I am using this year's files and updated the database with corrections. Also, I have made the corrections to Auto-Update, per Phil and the colors highlighting. Also, I have updated the URL used to pull the scores from NFL to reflect this year's URL.

I used the Auto-Update function ...

I just updated all of the scores for the games played as of Sunday, September 7. The Results panel shows points that appear to be incorrectly added up..or is there something that I have done wrong in the configuration. See attachment.... Football Pool Results Page.jpg Also what does the asterisk ...

Works like a champ. Thanks for the update.

Works like a champ. Thanks for the update.

Auto Update also does not work if there are any games in progress. The code just hangs. I think that this not a bug but a feature to ensure that only complete games are updated.

Auto Update also does not work if there are any games in progress. The code just hangs. I think that this not a bug but a feature to ensure that only complete games are updated.

Manual data entry; ensuring that the point spread resulted in the correct picks, when using Select Favorites. Had to do this to ensure that the point spreads were being implemented correctly for the picks...but is very confusing.

I have had this issue in the past using Access databases. Generally the issue is that the program does not have the credentials to make changes to the Access database. I am also on GoDaddy, but I have made sure that I am using their Classic service and not one of the later services that do not fully ...

I am confused on the use of the point spread settings. I am using the results from http://www.footballlocks.com/nfl_point_spreads.shtml. However, if I transfer the information directly to ASP Football Pool, the picks are reversed. I have corrected the spreads to show the correct picks. However, the ...