PS
Or see
http://spiderwebwoman.com/tutorials/doubledropdown.htm
| Your use of "mixed" names for the recordsets is the problem (calling rs and fp_rs is not the same)
| The error is referring to "rs" on GameReport1a.asp and means someplace you are trying to use rs and in your code I see
| FP_FieldHTML(fp_rs,...) - remnants from the DBRW
| Use one method for all your recordset calls
|
| Start by deleting your input field and hyperlink starting with:
| <input name="T1" size="55" value=" After clicking submit you must click the button below" style="font-weight:
| 700"><br></font><font face="Arial" size="1" color="#FF0000"><b><br>
| <a href="GameReport2a.asp?Dt=
| and ending probably with
| =<%=FP_FieldHTML(fp_rs,"Dt")%>&Lvl=<%=FP_FieldHTML(fp_rs,"Lvl")%>" ......
|
| The same applies on GameReport2a.asp - delete
| <input name="T1" size="54" value=" After clicking submit you must click the button below" style="font-weight:
| 700"></font><b><font face="Arial" size="1" color="#FF0000"><br>
| <a href="GameReport3.asp">
| <img border="0" id="img1" src="button2A.jpg" height="32" width="160" alt="Click to Complete Form"
| onmouseover="FP_swapImg(1,0,/*id*/'img1',/*url*/'button2B.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img1',/*url*/'button2A.jpg')"
| onmousedown="FP_swapImg(1,0,/*id*/'img1',/*url*/'button2C.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img1',/*url*/'button2B.jpg')"
| fp-style="fp-btn: Border Bottom 1" fp-title="Click to Complete Form"></a></font></b>
|
| All that is nonsense and unneeded since you have the form action set to send to GameReport2a.asp on GameReport1a.asp which will
send
| the 2 fields (Dt and Level - notice that is Level - Not Lvl) as form field results, and on GameReport2a.asp the action is set to
| GameReport3a.asp
|
| Since the form is sending the data (not your invalid hyperlink input field) the receiving page would NOT look for Querystring as
in
| Dt = Request.Querystring ("Dt")
| Lvl = Request.Querystring ("Lvl")
| It would look for form results using
| Dt = Request.Form("Dt")
| Lvl = Request.Form("Level")
|
| Now If I select a date on GameReport1a.asp It shows as a string on GameReport2a.asp
| That means the field DT is text or the code does not recognize it at as a date
| So make sure it is a date using
| Dt = Cdate(Dt)
|
| And you can not use character delimiters (chr(39)) for dates as in:
| "UPDATE temp SET dt = (" & chr(39) & Replace(Request.Querystring("Dt"),"'","''") & chr(39) & ") WHERE ID = 1"
| You need Date delimiters as in
| "UPDATE temp SET dt = #" & Dt & "#) WHERE ID = 1"
|
| PS
| I originally in another post referred you to a link to do the whole thing in the DBRW w/o any tmp table variables and you do not
| need to pass any variables by hyperlinks - don't just "create" homespun code and hope it will work
|
| Recommend you delete all you have done on those 2 pages and redo it the correct way (w/o your tmp steps) using the simple
guidelines
| at
http://spiderwebwoman.com/tutorials/picklist_with_dropdown.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
| _____________________________________________
|
|
|| Thanks Stefan you are being very helpful. I hope you know I am tring to
|| follow your original advise, so bear with me so I learn correctly.
|| In response to your questions:
||
|| how you are passing the Date (Dt) and Level (Lvl) values from the sending page
|| (from a form or in a query as hyperlink parameters)
||
|| I am passing the variables by Hyperlink here is the code from the sending
|| page (passing the variables)
|| <a
|| href="GameReport2a.asp?Dt=<%=FP_FieldHTML(fp_rs,"Dt")%>&Lvl=<%=FP_FieldHTML(fp_rs,"Lvl")%>">
||
|| how (are) you are reading those variables on the receiving page
||
|| Following is the code from the receiving page
||
|| <%
||
|| Dt = Request.Querystring ("Dt")
|| Lvl = Request.Querystring ("Lvl")
|| If Request.Querystring ("Dt") <> "" then
|| Update "ijf.mdb", "UPDATE temp SET dt = (" & chr(39) &
|| Replace(Request.Querystring("Dt"),"'","''") & chr(39) & ") WHERE ID = 1"
|| end if
|| if Request.querystring ("lvl") <> "" Then
|| Update "ijf.mdb", "UPDATE temp SET lev = (" & chr(39) &
|| Replace(Request.querystring("Lvl"),"'","''") & chr(39) & ") WHERE ID = 1"
|| end if
|| %>
||
|| When I open the sending page
|| I get the following message:
||
|| Microsoft VBScript runtime error '800a000d'
|| Type mismatch: 'rs'
|| C:\WEBSITES\INGLEMOORVIKINGS202\INGLEMOORVIKINGS.ORG\TEST\BRIAN\../../_fpclass/fpdblib.inc, line 48
||
|| This message actually replaces and becomes the Hyperlink if I click it I go
|| to the receiving page and get the following URL in the address box
||
||
http://www.inglemoorvikings.org/test/brian/GameReport2a.asp?Dt= <font%20face=
||
|| To check what you are getting at the receiving end add this code right after
|| you "get" the Dt value
||
|| I posted the code and you DT = is written on the receiving page.
|| I assume this means it looks for Dt and can’t either find or understand it.
||
|| Both Lvl and Dt are Text
||
|| Any ideas, suggestions.
||
|| Please help
|| Billie (Bline)
||
|| "Stefan B Rusynko" wrote:
||
|| > Post a code snippet of
|| > - how you are passing the Date (Dt) and Level (Lvl) values from the sending page
|| > (from a form or in a query as hyperlink parameters)
|| > - how you are reading those variables on the receiving page
|| >
|| > Most likely you are somehow passing or receiving Dt as a string and it needs to be a Date
|| > To check what you are getting at the receiving end add this code right after you "get" the Dt value
|| >
|| > <% Response.write "Dt = " & Dt & " is a: " & TypeName(Dt) & "<br>" %>
|| >
|| > If you are getting it as a valid date string you can convert it to a date data type using
|| > Dt = Cdate(Dt)
|| >
|| >
|| > --
|| >
|| > _____________________________________________
|| > 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
|| > _____________________________________________
|| >
|| >
|| > |I changed Date to Dt and Level to Lvl
|| > | <%=Dt_FieldHTML(fp_rs,"Dt")%>
|| > | <%=FP_FieldHTML(fp_rs,"Lvl")%>
|| > |
|| > | Still getting
|| > | Microsoft VBScript runtime error '800a000d'
|| > |
|| > | Type mismatch: 'rs'
|| > |
|| > | C:\WEBSITES\INGLEMOORVIKINGS202\INGLEMOORVIKINGS.ORG\TEST\BRIAN\../../_fpclass/fpdblib.inc, line 48
|| > |
|| > | Any ideas?
|| > |
|| > | Bline
|| > |
|| > |
|| > |
|| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
|| > |
|| > | > Is "Date" actually the name of a field in your database? It's a reserved
|| > | > word. Change it to something else.
|| > | >
|| > | > --
|| > | > ~ Kathleen Anderson
|| > | > Microsoft MVP - FrontPage
|| > | > Spider Web Woman Designs
|| > | > web:
http://www.spiderwebwoman.com/resources/
|| > | >
|| > | >
|| > | > || > | > >I posted a request and got a reply (Thanks You Ms Anderson) but I haven't
|| > | > > been able to get it to work. I am attempting a different approach.
|| > | > >
|| > | > > What I am attempting to do is pass two variables as Parameters to
|| > | > > Hyperlinks. Here's where I am at. The values I want to pass are selected
|| > | > > by
|| > | > > the user from a drop down boxes that has been prepared & presented by the
|| > | > > FP
|| > | > > DB Resullts Wizard. The names and values of the variables are:
|| > | > > Name = Date <%=FP_FieldLink(fp_rs,"Date")%>
|| > | > > Name = Level <%=FP_FieldLink(fp_rs,"Level")%>
|| > | > >
|| > | > > I obtained and copied the values directly by right clicking on the
|| > | > > dropdown
|| > | > > boxes and going to the Hyperlink Parameters for the values of the boxes.
|| > | > >
|| > | > > I have placed the name and values into the Hyperlink Parameters input or
|| > | > > selection box. The path is right to go to the next page.
|| > | > >
|| > | > > When I open my page the interactive button fpor my hyperlink is replaced
|| > | > > with the following error message:
|| > | > >
|| > | > > Microsoft VBScript runtime error '800a000d'
|| > | > >
|| > | > > Type mismatch: 'rs'
|| > | > >
|| > | > > C:\WEBSITES\INGLEMOORVIKINGS202\INGLEMOORVIKINGS.ORG\TEST\BRIAN\../../_fpclass/fpdblib.inc,
|| > | > > line 48
|| > | > >
|| > | > > The page in question is
|| > | > >
http://www.inglemoorvikings.org/test/brian/gamereport1a.asp
|| > | > >
|| > | > > Any help you can give will be appreciated. Thank you!!!!
|| > | > >
|| > | > > New inexperienced and in pain!!!! Billie (Bline)
|| > | > >
|| > | >
|| > | >
|| > | >
|| >
|| >
|| >
|
|
