J
Jeff
I run the website for the Oneill High School Lacrosse Team.
http://www.oneilllax.org I have built this from scratch and am
learning as I go. Currently, the visitor clicks the link to view the
player statistics (www.oneilllax.org/selectplayerforquery.asp) and is
presented with a form. The drop down box presents the visitor with
the players names, but the option value that is passed via the form is
actually db field of Player_PK. This variable is passed to the
following page via a Post from the form.
On the second page (www.oneilllax.org/playerstatisticsquery.asp) the
visitor is presented with serveral tables that result from the various
queries using the Player_PK variable that was passed to this page.
This code was not hand written - but was generated using the Insert-
fp_sQry="SELECT * FROM Player WHERE (Player_PK = :
layer_PK:"
This works great and selects the records from the current year
database. I used it all last year without any issues. If you hit
these links currently, there are no results, as we are just getting
into season and no games have been played yet.
Here is where I want to expand and make the site better. I want to be
able to give the visitor (ie college scouts) the ability to look at
the previous year stats. So, I somehow needs to pass this Player_PK
variable to a new page. Within this new page, I will use the Insert-
Player_PK variable will be passed to the page, the query will be run
against the 2006 database, and last years stats will be displayed.
Of course, the problem is that I dont know how to pass the variable
and then recapture it within FP (specifically within the database
results properties wizard from design view)
I have been googling for a week and have tried various combinations of
hidden variable, sesson variable, request.form, response.write and
much more.
Looking and hoping for assistance.
Jeff
http://www.oneilllax.org I have built this from scratch and am
learning as I go. Currently, the visitor clicks the link to view the
player statistics (www.oneilllax.org/selectplayerforquery.asp) and is
presented with a form. The drop down box presents the visitor with
the players names, but the option value that is passed via the form is
actually db field of Player_PK. This variable is passed to the
following page via a Post from the form.
On the second page (www.oneilllax.org/playerstatisticsquery.asp) the
visitor is presented with serveral tables that result from the various
queries using the Player_PK variable that was passed to this page.
This code was not hand written - but was generated using the Insert-
the variable passed to this page is:
fp_sQry="SELECT * FROM Player WHERE (Player_PK = :
layer_PK:"This works great and selects the records from the current year
database. I used it all last year without any issues. If you hit
these links currently, there are no results, as we are just getting
into season and no games have been played yet.
Here is where I want to expand and make the site better. I want to be
able to give the visitor (ie college scouts) the ability to look at
the previous year stats. So, I somehow needs to pass this Player_PK
variable to a new page. Within this new page, I will use the Insert-
connector to connect to last year's database. If all works well, the
Player_PK variable will be passed to the page, the query will be run
against the 2006 database, and last years stats will be displayed.
Of course, the problem is that I dont know how to pass the variable
and then recapture it within FP (specifically within the database
results properties wizard from design view)
I have been googling for a week and have tried various combinations of
hidden variable, sesson variable, request.form, response.write and
much more.
Looking and hoping for assistance.
Jeff