ASP Code - Tracking football squares (10x10 matrix)

Discussion in 'ASP General' started by binger, Jan 28, 2004.

  1. binger

    binger Guest

    Okay,
    Superbowl is only a few days away, but I thought it would be cool to
    set up an online registration for a football squares pool.

    My thoughts are to have people go into anywhere on the 10x10 matrix
    and put their name in.
    If someone already has put their name in a square, then the text input
    box is now static (i.e. cant be overwritten)...

    Only problem - I'm not sure how to do this. I'd plan on using an
    access database with ASP...but was wondering if anyone has quick
    thoughts (or maybe actual working code)...on how to do this???

    Would the database be best served with 100 rows of data (1 for each
    square), or 1 row with 100 columns of data...??? thoughts?
    Thanks!
    Go Pats...
    binger, Jan 28, 2004
    #1
    1. Advertising

  2. I named my dog Bunger so when I say your name I had to reply!!

    I would never make a 100 columns in your table for this kind of app. If
    the position matters just record a value from 1 to 100 for each person.
    As you output the columns/rows just use box 1 as the upper left and 10
    is upper right. Box 11 would just be the start of the 2nd row and
    continue this pattern using a loop.

    Access and ASP would be ok for this one. You would simply record the
    name and position. 2 columns of data. Very simple.

    I do admit I don't even know what a football squares pool is so maybe
    there is more to this app than I know :)

    Shawn Jackson
    Owner and Creator
    http://www.actionjackson.com
    http://www.devdex.com


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    ActionJackson, Jan 28, 2004
    #2
    1. Advertising

  3. binger

    binger Guest

    ActionJackson <> wrote in message news:<>...
    > I named my dog Bunger so when I say your name I had to reply!!
    >
    > I would never make a 100 columns in your table for this kind of app. If
    > the position matters just record a value from 1 to 100 for each person.
    > As you output the columns/rows just use box 1 as the upper left and 10
    > is upper right. Box 11 would just be the start of the 2nd row and
    > continue this pattern using a loop.
    >
    > Access and ASP would be ok for this one. You would simply record the
    > name and position. 2 columns of data. Very simple.
    >
    > I do admit I don't even know what a football squares pool is so maybe
    > there is more to this app than I know :)
    >
    > Shawn Jackson
    > Owner and Creator
    > http://www.actionjackson.com
    > http://www.devdex.com
    >
    >
    > *** Sent via Developersdex http://www.developersdex.com ***
    > Don't just participate in USENET...get rewarded for it!


    ....some people do call me Bunger for run...
    as for a football square pool : think of this:
    Start with a 10 x 10 matrix. Have people fill their names in all of
    the 100 cells. Then, randomly place the numbers 0 thru 9 across the
    horizontal access, then do the same down the vertical axis.
    For the football pool, the horizontal axis represents team 1, and the
    horizontal axis represents team 2. At the end of each quarter played,
    you would look at the "ones digit" for each team, and find out where
    this numeric combination meets in the squares. I.e. if team 1 had 17
    points, and team 2 had 14 points, you would find the intersection of
    team 1(7) and team 2(4) and whoevers name was there would win $$ for
    that quarter...

    Therefore, I was looking for a routine where people could visually see
    a 10X10 matrix on the screen, each cell with an input box to put their
    name it. As soon as someone would select a square (and input it),
    that cell becomes 'fixed', and only the un-selected squares remaining
    are available for text input...

    Hope that makes sense...any further ideas???
    Thanks,
    bUnger...
    binger, Jan 28, 2004
    #3
  4. binger

    Roland Hall Guest

    "binger" wrote:
    : ActionJackson wrote:
    : > I would never make a 100 columns in your table for this kind of app. If
    : > the position matters just record a value from 1 to 100 for each person.
    : > As you output the columns/rows just use box 1 as the upper left and 10
    : > is upper right. Box 11 would just be the start of the 2nd row and
    : > continue this pattern using a loop.
    : >
    : > Access and ASP would be ok for this one. You would simply record the
    : > name and position. 2 columns of data. Very simple.
    :
    : Therefore, I was looking for a routine where people could visually see
    : a 10X10 matrix on the screen, each cell with an input box to put their
    : name it. As soon as someone would select a square (and input it),
    : that cell becomes 'fixed', and only the un-selected squares remaining
    : are available for text input...

    http://www.partysoftware.com/Football_Squares.html
    Roland Hall, Jan 28, 2004
    #4
  5. binger

    Jeff Cochran Guest

    On 27 Jan 2004 19:10:48 -0800, (binger)
    wrote:

    >Superbowl is only a few days away, but I thought it would be cool to
    >set up an online registration for a football squares pool.


    Assuming you're doing this in the Bahamas of course... :)

    >My thoughts are to have people go into anywhere on the 10x10 matrix
    >and put their name in.
    >If someone already has put their name in a square, then the text input
    >box is now static (i.e. cant be overwritten)...


    Better, just print the names and empty squares get a "Click here to
    select this square" link.

    >Only problem - I'm not sure how to do this. I'd plan on using an
    >access database with ASP...but was wondering if anyone has quick
    >thoughts (or maybe actual working code)...on how to do this???


    Did you Google for any? The code really wouldn't be hard, but you'll
    have to learn quick.

    >Would the database be best served with 100 rows of data (1 for each
    >square), or 1 row with 100 columns of data...??? thoughts?


    Always less columns than rows. Especially since you could have as
    little as a single column for this.

    Jeff
    Jeff Cochran, Jan 28, 2004
    #5
  6. binger

    binger Guest

    Peter - awesome help...i took what you sent and this rocked!!!!!
    thanks again for the recommendations...

    .....go patriots...


    2004 FOOTBALL SQUARES POOL&nbsp; <BR>
    <font color="#FF0000">
    PATRIOTS SCORE ACROSS THE TOP<BR>
    </font><font color="#0000FF">
    PANTHERS SCORE DOWN THE SIDE</font>
    <p align="center">$50 FOR 2 SQUARES !!!!
    </p>
    <ul>
    <li>
    <p align="left">OFFICIAL NUMBERS WILL BE DRAWN PRIOR TO KICKOFF
    THIS SUNDAY</li>
    <li>
    <p align="left">ONCE YOU SUBMIT YOUR SQUARE - YOU CAN NOT UNDO
    YOUR
    SELECTION - SO BE SURE OF YOUR PICKS...</li>
    <li>
    <p align="left">PATRIOTS WILL KICK ASS</li>
    </ul>
    <form method="POST" action="update.asp" >
    <div align="center">
    <center>
    <table border="1" height="400" width="400">
    <%
    do while Not rs.eof
    response.write("<tr>")
    for i = 1 to 10
    response.write("<td>")
    Response.Write "<input name=""square" & RS("ID") & """ type=""text""
    maxlength=""50"" size=""7"" value=""" & RS("name") & """"
    If Len(RS("name")) > 0 Then
    Response.Write " readonly"
    End If
    Response.Write ">"
    RS.MoveNext()
    response.write("<td>")
    next
    response.write("</tr>")
    rownumber=rownumber+1
    loop

    %>

    </table>

    </center>
    </div>
    <p align="center"><input type="submit" value="Submit"
    name="B1"><input type="reset" value="Reset" name="B2"></p>
    </form>
    <p align="center">
    <img height="94" alt="Patriots.com Home" src="brown800_home.jpg"
    width="152" border="0">&nbsp;
    VS.&nbsp;<img border="0" src="header-sp.gif">
    <p align="center"><a href="http://www.patriots.com/SuperBowl/XXXVIII/"
    target="_top"><img height="250" src="img93_000827.jpg" width="250"
    border="0"></a></p>

    </body>

    </html>
    binger, Jan 29, 2004
    #6
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sam Hwang

    Football platform?

    Sam Hwang, May 4, 2005, in forum: Java
    Replies:
    0
    Views:
    375
    Sam Hwang
    May 4, 2005
  2. jocknerd
    Replies:
    4
    Views:
    255
    Gabriel Genellina
    May 2, 2007
  3. Bert

    AFL (Australian Football League)

    Bert, Jul 11, 2008, in forum: C Programming
    Replies:
    17
    Views:
    469
    31349 83652
    Jul 29, 2008
  4. Sam Davies

    American Football/Rugby Ball

    Sam Davies, Apr 2, 2004, in forum: Javascript
    Replies:
    1
    Views:
    115
    Brian Genisio
    Apr 2, 2004
  5. Sam Davies

    American Football/Rugby Ball

    Sam Davies, Apr 3, 2004, in forum: Javascript
    Replies:
    1
    Views:
    158
    Brian Genisio
    Apr 5, 2004
Loading...

Share This Page