Frontpage 2003 Database form

  • Thread starter Thread starter tt_chatter
  • Start date Start date
T

tt_chatter

Im having a problem with posting links on a frontpage database. If I
type out a link into a formfield example:(http://www.bob.com) the
outcome results in a text not a link. I know forms like VB use a code
<a href=" "> </a></p> But I want to be able to just have users type
in the link and have it show on the form results page as a link. I
cant figure this out and its starting to get annoying. Thanks for what
ever help i can get.
 
Are you using hand written server side code or the DBRW for your DB and result pages?
- if using the DBRW the DB field should be set as a hyperlink field
- if hand coding your ASP just wrap the field result in a hyperlink tag

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Im having a problem with posting links on a frontpage database. If I
| type out a link into a formfield example:(http://www.bob.com) the
| outcome results in a text not a link. I know forms like VB use a code
| <a href=" "> </a></p> But I want to be able to just have users type
| in the link and have it show on the form results page as a link. I
| cant figure this out and its starting to get annoying. Thanks for what
| ever help i can get.
|
 
In Design View, right-click on the field, choose Database Column Value
Properties, check Display as Hyperlink and click OK.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.
 
I am using the DB from frontpage and the results page. The thing is
that i dont want the entire area to be one link. If I make the field
as a hyperlink every thing they type will be one big hyperlink that
wont work. I want them to be able to type in what ever text they want
and a hyper link and actually work on the results page. Right now i
have a set up where they click a button to insert the link html and
they fill in the information. <a href=" "> </a></p> This is not user
friendly. I also am using a script that allows the fields to be
formated.< %=Replace(FP_Field(fp_rs,"Resolution"), VbCr, "<br>")%> Is
there something that i can add to this to allow links? Again i dont
want to make the entire field a link.
 
I am using the DB from frontpage and the results page. The thing is
that i dont want the entire area to be one link. If I make the field
as a hyperlink every thing they type will be one big hyperlink that
wont work. I want them to be able to type in what ever text they want
and a hyper link and actually work on the results page. Right now i
have a set up where they click a button to insert the link html and
they fill in the information. <a href=" "> </a></p> This is not user
friendly. I also am using a script that allows the fields to be
formated.< %=Replace(FP_Field(fp_rs,"Resolution"), VbCr, "<br>")%> Is
there something that i can add to this to allow links? Again i dont
want to make the entire field a link.
 
Using two form fields. if the field containing the URL is called infolink,
and the field containing the text is called test, do this (courtesy of
Stefan in another thread):

In the cell displaying the DBRW fields:

<a href="<%=FP_Field(fp_rs,"infolink")%>"><%=FP_FieldVal(fp_rs,"test")%></a>


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
 
Using twoformfields. if the field containing the URL is called infolink,
and the field containing the text is called test, do this (courtesy of
Stefan in another thread):

In the cell displaying the DBRW fields:

<a href="<%=FP_Field(fp_rs,"infolink")%>"><%=FP_FieldVal(fp_rs,"test")%></a>

--

~ Kathleen Anderson
Microsoft MVP -FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others






- Show quoted text -
Click to expand...

I was thinking about that, using 2 fields, but the guy im doing the
site for doesn't want that. He wants people to be able to say what
ever they want in the field and if they want to put in a link they
can. The link has to show up as a link. Is there any way to do that.
 
Using twoformfields. if the field containing the URL is called infolink,
and the field containing the text is called test, do this (courtesy of
Stefan in another thread):

In the cell displaying the DBRW fields:

<a href="<%=FP_Field(fp_rs,"infolink")%>"><%=FP_FieldVal(fp_rs,"test")%></a>

--

~ Kathleen Anderson
Microsoft MVP -FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others






- Show quoted text -
Click to expand...

I was thinking about that, using 2 fields, but the guy im doing the
site for doesn't want that. He wants people to be able to say what
ever they want in the field and if they want to put in a link they
can. The link has to show up as a link. Is there any way to do that.
 
Would require hand coded ASP to evaluate the field and to determine if the data contains what looks like a link (then write the data
to the DB including a link tag around the apparent link)
- not something that can be done w/ the DBRW

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| On May 17, 3:02 pm, "Kathleen Anderson [MVP - FrontPage]"
| > Using twoformfields. if the field containing the URL is called infolink,
| > and the field containing the text is called test, do this (courtesy of
| > Stefan in another thread):
| >
| > In the cell displaying the DBRW fields:
| >
| > <a href="<%=FP_Field(fp_rs,"infolink")%>"><%=FP_FieldVal(fp_rs,"test")%></a>
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP -FrontPage
| > Spider Web Woman Designs
| > web:http://www.spiderwebwoman.com/resources/
| > Please reply to the newsgroup for the benefit of others
| >
| >
| > | >
| >
| >
| > >I am using the DB fromfrontpageand the results page. The thing is
| > > that i dont want the entire area to be one link. If I make the field
| > > as a hyperlink every thing they type will be one big hyperlink that
| > > wont work. I want them to be able to type in what ever text they want
| > > and a hyper link and actually work on the results page. Right now i
| > > have a set up where they click a button to insert the link html and
| > > they fill in the information. <a href=" "> </a></p> This is not user
| > > friendly. I also am using a script that allows the fields to be
| > > formated.< %=Replace(FP_Field(fp_rs,"Resolution"), VbCr, "<br>")%> Is
| > > there something that i can add to this to allow links? Again i dont
| > > want to make the entire field a link.- Hide quoted text -
| >
| > - Show quoted text -
|
| I was thinking about that, using 2 fields, but the guy im doing the
| site for doesn't want that. He wants people to be able to say what
| ever they want in the field and if they want to put in a link they
| can. The link has to show up as a link. Is there any way to do that.
|
 
Back
Top