I saw your caveat but using tools w/o understanding them (just because they may work) does not help you learn the right way to use
them and may lead to unpredictable results.
And your approach w/ a temp table is cumbersome (plus unnecessary), and generating your multiple user problem
To simplify your app and not use the temp table:
All you are trying to do is show a report on SystemReport3.asp using criteria Week =( DT) and System = (System) from
SystemReport1.asp, and not get errors or data if the user has changed or not selected criteria from SystemReport1.asp
On page SystemReport1.asp change the action="SystemReport1.asp" to action="SystemReport3.asp", add FP validation to make the 2
fields required (see PS below) to prevent user from hitting submit w/o choosing a date and system, and remove the Move to page 2
button (not needed)
- user selects the 2 report variables Week =( DT) and System = (System) and is taken to the report by the form
On page SystemReport3.asp remove the form (is serves no purpose to the user)
At the top of the page before the <head> tag add the code to check for empty form fields (user did not come from SystemReport1.asp)
and process the results if they did come from the form
You can use Request.Form("Date") = "" or IsEmpty(Request.Form("Date"))
<%
IF Request.Form("Date") = "" AND Request.Form("System") = "" THEN
' Send them back to selection form for real values
Response.Redirect "SystemReport1.asp"
Else
' We have values from SystemReport1.asp form - get them
' Use the real form field names from SystemReport1.asp
Dt = Request.Form("Date")
System = Request.Form("System")
'ready to use variables Dt and System in ASP code below
End IF
%>
At this point valid Dt and System values should be available for your queries to build the 7 displayed tables
If using the DBRW see part 1 of
http://spiderwebwoman.com/tutorials/doubledropdown.htm
If you are using the DBR wizard and not hand coding you don't have to do any of the above
Just run the wizard as explained at
http://spiderwebwoman.com/tutorials/doubledropdown.htm modified by
http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return
Trust this helped you understand more about what you are doing and a correct way to do it
PS
When using drop downs that you want user to select add a 1st option and set your FP validation to disallow the 1st choice
In <select NAME="Date" SIZE="1">
<option value="NA" selected>Select Game Date</option>
In <select NAME="System" SIZE="1">
<option value="NA" selected>Select System</option>
Your ASP code for the dropdown options (pulled from the DB) should also write a value for each option to make sure all browsers
process it correctly
Right now you are generating
<option>Bainbridge Island</option>
and should be generating
<option value = "Bainbridge Island">Bainbridge Island</option>
If your field is System and you are using wizards then the code would be something like
<option value="<%=FP_FieldVal(fp_rs,"System")%>"><%=FP_FieldVal(fp_rs,"System")%></option>
On SystemReport1.asp you have a stray GET and <p> after </body> (probably caused by some bad code after the </body> or </html> tags
in that page
Note that wrapping a form field in a hyperlink is invalid html as in SystemReport3.asp where you have
<a href="systemreport3.asp"><select NAME="Dt" SIZE="1"><option selected value="10/29/2005">10/29/2005</option></select></a>
Also add a link on the page SystemReport3.asp somewhere for the user to do to another report (SystemReport1.asp) or navigate away
| Please remember my Caveat I am new untrained and inexperienced. Because of
| that I use things that work for me. Code similar to that I shared is working
| fine here is an example of code immediately below thse code in question that
| functions perfectly. The Response. write statements in the other code is to
| help me troubleshoot at what point the code works or doen't work.
| <%
| dim Id, HomeScore, AwayScore, SubRule, Rosters, PlayersElig, Disqualfied,
| CoachName, RefereeName, LinesmanName, UmpireName, LineJudgeName,
| RuleComments, CoachComments, OfficialsComments, CoachEval, RefereeEval,
| LinesmanEval, UmpireEval, LineJudgeEval
|
| If Request.Querystring ("HomeScore") <> "" Then
| ID = Request.Querystring ("ID")
| HomeScore = Request.Querystring ("HomeScore")
| Update "ijf.mdb", "Update GameReportTestData Set HomeScore = " & chr(39) &
| Replace (Request.QueryString("HomeScore"),"'","''") & chr(39) & " WHERE ID =
| " & ID
| Response.write HomeScore
| end if
| %>
|
|
| Now for what I am trying to accomplish (The purpose), I am attempting to
| refresh table System Temp because
|
| The two variable’s "System" and "DT" reside in a table called SystemTemp.
| They are entered from a previous page (SystemReport1) where the user is
| specifying the criteria Week =( DT) and System = (System) for the Report
| (SystemReport3.asp). Once User1 selects his/her criteria and moves to the
| Report (SystemReport3.asp) a second user User2 can come right behind him/her
| and update the SystemTemp Table withy their criteria. When Usrer1 goes to
| update Scores or other information in the report her will be directed back to
| User2's report because the SystemTemp table has bee changed by user 2.
|
| Therefore I am attempting to refresh the information in SystemTemp with
| User1's criteria as part of the update so he or she will be returned to the
| correct information.
|
| Once again I apologize for my ignorance but ask that you bear with me until
| I can learn and help someone else. I promise to be both patient and polite
| with them
|
| Thanks Again & Please help.
|
| Bline
|
|
|
| "Stefan B Rusynko" wrote:
|
| > A "polite" response is your code below is mystifying (at best) and invalid
| > - don't know where you got that code from but if you want to learn to use ASP then look at some valid sample code like at
| >
http://www.asp101.com/samples/
| >
| > And your page apparently does nothing since there is no submit button and both dropdowns only have 1 value (so there is nothing
to
| > select)
| >
| > If you just explain what you are trying to do w/ the 2 variables (DT and System) with your DB table(s) and what you want to
display
| > based on them it would be easier to assist
| >
| > If your goal is to have the results of one dropdown form field (DT using values from your DB) affect another dropdown form field
| > (System - also using values from your DB) see the tutorial at
http://spiderwebwoman.com/tutorials/doubledropdown.htm
| >
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | If you look at the page
| > |
http://www.inglemoorvikings.org/test/brian/systemreport3.asp you will se a
| > | date in a dropdown box, that's the value of "Dt" in another wozar results
| > | query. I did that to attempt another approac using tihis code
| > |
| > | <%
| > | System = Request.Form ("System")
| > | [Dt] = Request.Form ("Dt")
| > | Response.write Dt
| > | Response.write "Bllie"
| > | if Request.Form ("Dt") <> "" Then
| > | Response.write "Hartline"
| > | OpenDB "ijf.mdb", "UPDATE Systemtemp SET dt = (" & chr(39) &
| > | Replace(Request.Form("Dt") ,"'","''") & chr(39) & ") WHERE ID = 1"
| > | Response.write Dt
| > | end if
| > | if Request.Form ("System") <> "" Then
| > | OpenDB "ijf.mdb", "UPDATE Systemtemp SET System = (" & chr(39) &
| > | Replace(Request.Querystring("System"),"'","''") & chr(39) & ") WHERE ID = 1"
| > | end if
| > | %>
| > |
| > | It doesn't work either Please help... IO am really stuck and need to get
| > | this thing done. Thank you for your help in advance.
| > |
| > | Bline
| > |
| > |
| > | "Bline" wrote:
| > |
| > | > Yes it is??
| > | >
| > | > Bline
| > | >
| > | > "Bline" wrote:
| > | >
| > | > > Just my standard caviat I am new, inexperienced and untrained, I hope to
| > | > > become proficient enought to help others in the furure, but for now I need
| > | > > your help, and I am very thankfull for it. I never know where to list these
| > | > > things so if I'm wrong I am sorry.
| > | > >
| > | > > I am building an application for a Junior Football Organization and I'm
| > | > > stuck. I am using a combination of Front Page and SQL.
| > | > >
| > | > > The page I'm working on is:
| > | > >
| > | > >
http://www.inglemoorvikings.org/test/brian/systemreport3.asp
| > | > >
| > | > >
| > | > >
| > | > > I use a technique (of correcting the value of variables in database by
| > | > > passing variables as parameters to hyperlinKs then using then using that data
| > | > > in database A Selete & Update Strings. I thought I had gotten pretty
| > | > > proficient at it but now I don't thinkk so.
| > | > >
| > | > > I am attempting to add a parameter to all the links on this page to allow me
| > | > > to update a temporary table that provides the main selection for the page.
| > | > > Probably not a good technique but I'm to far along to change (but I'm
| > | > > learning).
| > | > >
| > | > > The Variable is dt its the first variable (highlighted and underlined)
| > | > > listed on the information from FP below
| > | > >
| > | > > <!--webbot bot="DatabaseResultColumn"
| > | > > s-columnnames="Dt,ID,Reporter,ReporterTelephoneNumber,ReporterEmail,System,Level,GameNumber,Date,Home,HomeScore,Awa
| > | > > y,AwayScore,SubRule,Rosters,PlayersElig,Disqualfied,CoachName,CoachEval,RefereeName,RefereeEval,Line
| > | > > smanName,LinesmanEval,LineJudgeName,LineJudgeEval,UmpireName,UmpireEval,RuleComments,CoachComments,O
| > | > > fficialsComments,ScoreDiff,ptvioltaion,Disqualifications,OffNeg,CoachNeg,RostersViol,SubViol"
| > | > > s-column="Home" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > > clientside b-MenuFormat preview="<font size="-
| > | > > 1"><<</font>Home<font size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Home")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan i-checksum="5308" --></font></td>
| > | > >
| > | > > When I attempt to use it as a parameter to the hyperlink it is not listed in
| > | > > the Add Parameter drop down box? I tried manually typing in the name and
| > | > > value on the Hyperlink Parameters box. But when I go to run the page I get an
| > | > > error that it can't be found.
| > | > >
| > | > >
| > | > > Please help???
| > | > >
| > | > >
| > | > > Bline Please make me smile
| > | > >
| >
| >
| >
