ASP Football Support Forum

I did what someone suggested before. I set up a query for each week and added code to a contact page. All I have to do now is click on the page and it pulls who hasn't turned in their picks. I then have the email message field defaulted to tell them to turn in their picks.

Nevermind. If you go to the config file under includes, it has a time zone adjustment line. That was the problem for me.

anyone notice that their games aren't locking on time? i'm hosted with somee now and i am having to change the game times by one hour to get them to lock. any ideas?

Mine works. When they pay through paypal it automatically puts the credit in the users account. I have never had an issue.

Sure. Create a query in the access database and call it whatever you want. In design mode for the query, paste the following in the sql view SELECT [Username] & " " & [Pick] AS Expr1, SidePicks.Username, SidePicks.Pick FROM SidePicks; Create another query and call it whatever you w...

nevermind. was able to figure it out.

I turned off the option to only allow a user to select a team one time. However, I would like to let the users pick the same team only twice. Anyone know how to do this?

I am hosting my own.

Any insight if there is a way to do this in access?

I've attached the queries and the two web pages that I made to use. For the queries, open your database, click get external data. import the queries from this database. I'm not sure if it will work, but give it a try. Each week, you will have to open the two queries that have "CW" in them ...

Thanks, you're the man!

Anyone else having an issue with auto update? It worked last week, but hasn't worked this week at all.

I actually set this up last year. There isn't anything really easy about it though. I use the access database version and created a couple of queries within it. One that looks at who turned in picks in a specific week and one that compares that list to the user list. Then I have an email page that p...

great post! I made one little change to your page by putting the spread next to the visiting team. I did so by moving code that you injected to right after the visitor team information.

One of the other things was that 2012 was still in my updatescores.asp, so I had to update that as well. Great work!

Anyone ever figured out how to get spreads to update like the scores??

One of the other things was that 2012 was still in my updatescores.asp, so I had to update that as well. Great work!

Anyone ever figured out how to get spreads to update like the scores??

I tried to use the score auto update last night and it did not work. any ideas?

I tried to use the score auto update last night and it did not work. any ideas?

I have my users divided into two conferences. I would like to have a standings page that shows the AFC on the left and NFC on the right with the users underneath in the order of most right. I have been able to do this on two separate pages, but can't figure out how to get it on one page. Any thought...

I'm glad to see people who are going to keep up with the site. Personally, I like the ASP version of the pool software. I don't have a lot of experience with mysql. But hopefully some of the developers here can make some enhancements.