How do I set up framed hyperlinks on the database? SQL7 if that matters?

Thanks all.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

<%
If (FP_FieldVal(fp_rs,"Hyperlink_Option"))= "Yes" and (FP_FieldVal(fp_rs,"PromoterWebsite")) = "/promotersfaq.asp" then
response.write "<a href='"& FP_FieldVal(fp_rs,"PromoterWebSiteNotListed") &"'><img border=0 src=images/website.gif width=55 height=60></a>"
ElseIf (FP_FieldVal(fp_rs,"PromoterWebsite")) = "0" then
Response.write "Promoter doesn't have website"
ElseIf (FP_FieldVal(fp_rs,"PromoterWebsite")) = "/promotersfaq.asp" then
response.write "<a href='http://www.signingshotline.com/promotersfaq.asp'>Link YOUR website here! Just $9.99 per listing!</a>"
Else
response.write "<a href='"& FP_FieldVal(fp_rs,"PromoterWebsite") &"'><img border=0 src=images/website.gif width=55 height=60></a>"end if%>

The actual call to the promoter's website is near the end of the script.
So what do I have to do to have

Else response.write "<a href='"& FP_FieldVal(fp_rs,"PromoterWebsite") &"'><img border=0 src=images/website.gif width=55 height=60></a>"end if%>

cause FP_FieldVal(fp_rs,"PromoterWebsite") open in a frame called frame.htm all the time?

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

Remember, targeting others sites in your frameset is bad ettiquette, so check with them first

------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

Error message

Microsoft VBScript compilation error '800a0408'

Invalid character

/results_copy(1).asp, line 265

response.write "<a href='"& FP_FieldVal(fp_rs,"PromoterWebsite") &"' target="_framelink.asp"><img border=0 src=images/website.gif width=55 height=60></a>"end if
------------------------------------------------------------------------------^

BTW, I was going to tell these folks of my intentions prior to installing the frame, I just wanted to make sure I could do it first.

The ratio of people I bring to these sites that are linked to me is about 25 to 1 in their favor. I feel at this point, I need to give the user the option (and reminder) to return back to my site after they are done with the link.

Thanks,

Howard

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

I humbly follow up on the error message

Thanks

Hzarabet

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

Make sure you use ' quotes and not " quotes when within a asp string. If you use " it assumes you are breaking out of the string.

I have two frames in the page, frametop.asp which is a navbar and framemain.asp which should be where my link shows up (with the framed navbar on top of it). IN FP2000, when entering the framemain page, a browse window comes up to "hardcode" the URL for this page. Instead, I am entering <%=FP_FieldVal(fp_rs,"PromoterWebsite")%> as I do not have a URL to hard code this to.

Am I doing this correctly? I have never used frames before (Surprise!).

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

I am lost on this one.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

It looks to me in the previous examples, you're targeting a page and not a frame as in:

response.write "<a href='"& FP_FieldVal(fp_rs,"PromoterWebsite") &"' target="_framelink.asp"><img border=0 src=images/website.gif width=55 height=60></a>"

Here you are targeting a page (_framelink.asp) and not a frame (frames do not have extensions). If your frame is actually named "_framelink" then you should remove the ".asp" so that the line looks similar to :

response.write "<a href='"& FP_FieldVal(fp_rs,"PromoterWebsite") &"' target="_framelink"><img border=0 src=images/website.gif width=55 height=60></a>"

At least that's how I see it...

[This message has been edited by rdouglass (edited 05-18-2001).]

As I said, I can set up a frame page using FP2000, but how do I just set up a target page?

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

In the scenario using the example above, you would open your frames page in Normal View (in FrontPage) and right-click on the frame you want to be targeted and select properties. In this example you would rename the frame to "framelink" (without the quotes). Then you would use the HREF above (emphasis on the 'target' section):

response.write "<a href='"& FP_FieldVal(fp_rs,"PromoterWebsite") &"' target="_framelink"><img border=0 src=images/website.gif width=55 height=60></a>"

NOTE: Please notice the "_" (underscore) added to the beginning of the frame name.

It shouldn't matter what frame the link originated in. That should load any URL in PromoterWebsite field into the frame"_framelink". This should also work from other pages going to that page and targeting the frame.

I can set up a basic frame page:
header/main/"total page". Click on /totalpage and the frame page opens.

But I am missing the point how to incorporate this with my database variable.
For example...we're calling the main target 'framelink'. This is where my link should wind up (with my navbar frame above it as a header). But where in my asp is the "total page" being called? Where is my frame with the navbar being called? I think I am missing a very simple concept that I will not believe when I figure it out!

Thanks again

I believe I do not have a proper frameset page.

I can set up a frameset page with two frames and name for the "total" page.

One frame is a header with my navbar and the main frame being where I want my link to appear. I tried to have <%=FP_FieldVal(fp_rs,"PromoterWebsite")%> as my link in main frame. Calling the "total" frameset framelink.asp. I thought I could insert /framelink.asp into my asp statement. The header frame did work, but the main frame where I wanted the link to show up just gave me a 404 error.

I am sure this must be easy and I am doing something......dumb.

Thanks

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

ie

normally specify <frame> headpage.asp mainframe.asp</frame>

Instead do : <frame> headpage.asp <%=Request.querystring("PageName")%></frame>

Now when you click on a link :

framespage.asp?Page=Pagename.asp

pagenname.asp sill be loaded in the main frame.

------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

Here is my frameset per your recommendation:

<frameset rows="64,*">
<frame name="header" scrolling="no" noresize target="main" src="frameheader.asp">
<frame name="main" src="<%=Request.querystring(FP_FieldVal(fp_rs,"PromoterWebsite"))%>">
<noframes>
<body>

<p>This page uses frames, but your browser doesn't support them.

</body>
</noframes>
</frameset>

FYI, aside from src="<%=Request.querystring(FP_FieldVal(fp_rs,"PromoterWebsite"))%>"> I also tried src="<%=Request.querystring(fp_rs,"PromoterWebsite")%>"> and
src="<%=Request.querystring ("PromoterWebsite")%>">

In all cases it's the same thing. The header portion is fine, but the variable in the main section gives me a 404 error!

Thanks again all.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

<%=Request.querystring("URL")%>

You would use the database code in the link that you use to send the user to the frames page.

<a href='framesindex.asp?URL=<%=FP_FieldVal(fp_rs,"PromoterWebsite") %>'>Link text</a>

This will open framesindex.asp and (if you check the code) should have the URL as the code for <frame name="main" .... etc

------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

Here is my frameset again:

<frameset framespacing="0" border="0" rows="51,*" frameborder="0">
<frame name="header" scrolling="no" noresize target="main" src="frameheader.asp">
<frame name="main" src=<%=Request.querystring("main")%>>
<noframes>
<body>

<p>This page uses frames, but your browser doesn't support them.

</body>
</noframes>
</frameset>

OK...now here is the corresponding portion of my asp on my results page. One problem is using <%%> with <%%>:

response.write "<a href='http://www.signingshotline.com/framelink.asp?main=<%=FP_FieldVal(fp_rs,'PromoterWebsite')%>'><img border=0 src=images/website.gif width=55 height=60></a>"end if%>

AHHHHHHHH!!!!

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

Like so :

response.write "<a href='http://www.signingshotline.com/framelink.asp?main="& FP_FieldVal(fp_rs,'PromoterWebsite')&"'><img border=0 src=images/website.gif width=55 height=60></a>"end if%>

------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

Here is the framed page:

http://www.signingshotline.com/framelink.asp?main=http://www.tristarproductions.com

As this main frame isn't hard coded, I guess it's ASP to the rescue.

Thanks

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

...src="frameheader.asp?main=<%=Request.querystring("main")%">">...

Now in the header page, make the "remove frame" link value <%=Request.querystring("main")%>

So now the hyperlink will lead to the same page as the main content. Make sure it targets _top

------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada