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

Any help you can give will be appreciated. Thank you!!!!

New inexperienced and in pain!!!! Billie (Bline)

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/


"Bline" <(E-Mail Removed)> wrote in message
news:B2A6F4F4-0D66-46EF-9E5A-(E-Mail Removed)...
>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...mereport1a.asp
>
> Any help you can give will be appreciated. Thank you!!!!
>
> New inexperienced and in pain!!!! Billie (Bline)
>

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/
>
>
> "Bline" <(E-Mail Removed)> wrote in message
> news:B2A6F4F4-0D66-46EF-9E5A-(E-Mail Removed)...
> >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...mereport1a.asp
> >
> > Any help you can give will be appreciated. Thank you!!!!
> >
> > New inexperienced and in pain!!!! Billie (Bline)
> >
>
>
>

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
_____________________________________________


"Bline" <(E-Mail Removed)> wrote in message news:149F21F5-5749-4A8D-8255-(E-Mail Removed)...
|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/
| >
| >
| > "Bline" <(E-Mail Removed)> wrote in message
| > news:B2A6F4F4-0D66-46EF-9E5A-(E-Mail Removed)...
| > >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...mereport1a.asp
| > >
| > > Any help you can give will be appreciated. Thank you!!!!
| > >
| > > New inexperienced and in pain!!!! Billie (Bline)
| > >
| >
| >
| >

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=%20<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
> _____________________________________________
>
>
> "Bline" <(E-Mail Removed)> wrote in message news:149F21F5-5749-4A8D-8255-(E-Mail Removed)...
> |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/
> | >
> | >
> | > "Bline" <(E-Mail Removed)> wrote in message
> | > news:B2A6F4F4-0D66-46EF-9E5A-(E-Mail Removed)...
> | > >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...mereport1a.asp
> | > >
> | > > Any help you can give will be appreciated. Thank you!!!!
> | > >
> | > > New inexperienced and in pain!!!! Billie (Bline)
> | > >
> | >
> | >
> | >
>
>
>

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/...h_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
_____________________________________________


"Bline" <(E-Mail Removed)> wrote in message news:68A07E7C-E4F7-4B81-82BB-(E-Mail Removed)...
| 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=%20<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
| > _____________________________________________
| >
| >
| > "Bline" <(E-Mail Removed)> wrote in message news:149F21F5-5749-4A8D-8255-(E-Mail Removed)...
| > |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/
| > | >
| > | >
| > | > "Bline" <(E-Mail Removed)> wrote in message
| > | > news:B2A6F4F4-0D66-46EF-9E5A-(E-Mail Removed)...
| > | > >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...mereport1a.asp
| > | > >
| > | > > Any help you can give will be appreciated. Thank you!!!!
| > | > >
| > | > > New inexperienced and in pain!!!! Billie (Bline)
| > | > >
| > | >
| > | >
| > | >
| >
| >
| >

PS
Or see 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
_____________________________________________


"Stefan B Rusynko" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| 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/...h_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
| _____________________________________________
|
|
| "Bline" <(E-Mail Removed)> wrote in message news:68A07E7C-E4F7-4B81-82BB-(E-Mail Removed)...
|| 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=%20<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
|| > _____________________________________________
|| >
|| >
|| > "Bline" <(E-Mail Removed)> wrote in message news:149F21F5-5749-4A8D-8255-(E-Mail Removed)...
|| > |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/
|| > | >
|| > | >
|| > | > "Bline" <(E-Mail Removed)> wrote in message
|| > | > news:B2A6F4F4-0D66-46EF-9E5A-(E-Mail Removed)...
|| > | > >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...mereport1a.asp
|| > | > >
|| > | > > Any help you can give will be appreciated. Thank you!!!!
|| > | > >
|| > | > > New inexperienced and in pain!!!! Billie (Bline)
|| > | > >
|| > | >
|| > | >
|| > | >
|| >
|| >
|| >
|
|

Thank you so much I'll get right on it.

Your very good Stefan.

Bline

"Bline" wrote:

> 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...mereport1a.asp
>
> Any help you can give will be appreciated. Thank you!!!!
>
> New inexperienced and in pain!!!! Billie (Bline)
>