ASP Code - Tracking football squares (10x10 matrix)

[binger]

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...

[ActionJackson]

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!

[binger]

ActionJackson <ac****@actionj ackson.com> wrote in message news:<O6******* *******@TK2MSFT NGP09.phx.gbl>. ..

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...

[Roland Hall]

"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

[Peter Foti]

"binger" <ma************ *****@yahoo.com > wrote in message
news:69******** *************** ***@posting.goo gle.com...

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...

As this is just a small application with very little need for expandability,
the FASTEST way to do it might be to start by creating your grid as static
HTML. That is, create an HTML table (enclosed in a form), which has 11 rows
and 11 columns (don't forget, you need an extra row to hold the numbers
along the top of the grid, and an extra column to hold the numbers along the
left side of the grid). Your database should contain 100 rows of data
because you will need an ID column (which will be used to to identify the
items in the form) and a text column to store the name (which should be
empty to begin with). Your page should get all of the records from the
database into a recordset (ordered by the ID field). This example assumes
your ID field is numbered sequentially from 1 to 100 (that's important).
Then, for each table cell, you will write your input. If the length of the
name field for the corresponding record in the database is greater than
zero, make the field readonly. For example:

<td><%
Response.Write "<input name=""square" & RS("ID") & """ type=""text""
maxlength=""50" " size=""12"" value=""" & RS("PersonName" ) & """"
If Len(RS("PersonN ame")) > 0 Then
Response.Write " readonly"
End If
Response.Write ">"
RS.MoveNext()
%></td>

After the grid, include a submit button to post the form to a 2nd page for
processing and updating the database, and then redirect back to the original
grid page when done. If there will only be 1 computer accessing this page,
then you don't need to do any "validation ", but if multiple computers may be
used to access and update this grid, then you'll need to check that the name
value is still empty in the database before updating (otherwise, Tom and
Dick might both load the grid at the same time and both enter values into a
field... Tom submits and he sees his value is added to the grid... then Dick
submits and overwrites Tom's entry... smells like foul play).

This is a quick and dirty approach, but I hope this helps get you going in
the right direction. :)
Regards,
Peter Foti

[Jeff Cochran]

On 27 Jan 2004 19:10:48 -0800, ma************* ****@yahoo.com (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

[binger]

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">OF FICIAL NUMBERS WILL BE DRAWN PRIOR TO KICKOFF
THIS SUNDAY</li>
<li>
<p align="left">ON CE YOU SUBMIT YOUR SQUARE - YOU CAN NOT UNDO
YOUR
SELECTION - SO BE SURE OF YOUR PICKS...</li>
<li>
<p align="left">PA TRIOTS 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=rownu mber+1
loop

%>

</table>

</center>
</div>
<p align="center"> <input type="submit" value="Submit"
name="B1"><inpu t type="reset" value="Reset" name="B2"></p>
</form>
<p align="center">
<img height="94" alt="Patriots.c om Home" src="brown800_h ome.jpg"
width="152" border="0">&nbs p;
VS.&nbsp;<img border="0" src="header-sp.gif">
<p align="center"> <a href="http://www.patriots.co m/SuperBowl/XXXVIII/"
target="_top">< img height="250" src="img93_0008 27.jpg" width="250"
border="0"></a></p>

</body>

</html>