Webbot FP_FieldLink FP_FeidlVal question

  • Thread starter Thread starter newbieTW
  • Start date Start date
N

newbieTW

Hi,
I have a result page generated by DRW. All the codes/script are FP
generated. I'm trying to display column_1 but it hyper links to the
value in column_2. Is it do-able? I need to have
fp_fieldlink(fp_rs,"linkpage") and fp_fieldval(fp_rs,"category"). I'm
using FP 2002.

Here is the code in my page:

<!--webbot bot="DatabaseResultColumn"
s-columnnames="Key,MFG_Name,Release_month,Release_day,Release_year,Category,Remote_computer_name,User_name,Browser_type,Timestamp,LinkPage"
s-column="Category"
b-tableformat="TRUE"
b-hashtml="FALSE"
b-makelink="TRUE"
clientside
b-MenuFormat
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;&lt;
a href=&quot;.&quot;&gt;Category&lt;/a&gt;&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan -->
<%="<a href=""" & FP_FieldLink(fp_rs,"Category") & """>" &
FP_FieldVal(fp_rs,"Category") & "</a>"%>
<!--webbot bot="DatabaseResultColumn" endspan i-checksum="22085" -->

Thanks in advance.

Tara
 
Hi Tara,

Add the following TD manually to the Table in HTML view,

<td height="19"><a
href="<%=FP_FieldVal(fp_rs,"linkpage")%>"><%=FP_FieldVal(fp_rs,"category")%>
</a></td>

Regards,
Vijay

Disclaimer: This posting is provided "as is" with no warranties and confers
no rights

--------------------
| From: (e-mail address removed) (newbieTW)
| Newsgroups: microsoft.public.frontpage.client
| Subject: Webbot FP_FieldLink FP_FeidlVal question
| Date: 17 Mar 2004 12:21:17 -0800
|
| Hi,
| I have a result page generated by DRW. All the codes/script are FP
| generated. I'm trying to display column_1 but it hyper links to the
| value in column_2. Is it do-able? I need to have
| fp_fieldlink(fp_rs,"linkpage") and fp_fieldval(fp_rs,"category"). I'm
| using FP 2002.
|
| Here is the code in my page:
|
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="Key,MFG_Name,Release_month,Release_day,Release_year,Category,
Remote_computer_name,User_name,Browser_type,Timestamp,LinkPage"
| s-column="Category"
| b-tableformat="TRUE"
| b-hashtml="FALSE"
| b-makelink="TRUE"
| clientside
| b-MenuFormat
| preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;&lt;
| a href=&quot;.&quot;&gt;Category&lt;/a&gt;&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
| startspan -->
| <%="<a href=""" & FP_FieldLink(fp_rs,"Category") & """>" &
| FP_FieldVal(fp_rs,"Category") & "</a>"%>
| <!--webbot bot="DatabaseResultColumn" endspan i-checksum="22085" -->
|
| Thanks in advance.
|
| Tara
|
 
Hi Vijay,

Thank you. It is working now. May I ask few simple questions?
1) Why I can use the FP_FieldVal and FP_FieldLink call even thou I
don't have the <webbot.....> line?

2) Can you recommand some good sites about learning webbot? I went to
3w.org and totally lost. It doesn't have anything I saw in my page
such as s-cloumnname, s-link etc. Is webbot strictly working with
database?

3) What are these fp_fieldval and fp_fieldlink calls? Are they ASP or
ForntPage script? Can you recommand any sites that teach the syntax on
this language? Does it mean I can use these language in the HTML page
where ever I want and have it talk to database without using DRW?

Thanks,
Tara
 
Hi Tara,

Cool!

1. These are just ASP functions stored in the .inc file under the _fpclass
folder. FP uses them to generate DB related pages in ASP. The webbot is
just a comment line used by FP to recognize it while editting in FP design
mode. When browsed via a browser, the webbot is actually ignored on the
client browser.

2. webbot's are FrontPage specific components. Only in FrontPage could you
use it. We do not recommend users writing webbot tags manually, you could
use the Insert menu to insert components that are webbots.

3. They are ASP calls. They may be used in ASP pages only. ASP code can be
used to talk to a Database without using the DRW, but this requires ASP
programming skills. DRW makes life a lot easier.

There are loads of sites that train you on ASP, these are few good ones,
http://www.w3schools.com/asp/default.asp
http://www.asptutorial.info/
http://www.learnasp.com/

Regards,
Vijay

Disclaimer: This posting is provided "as is" with no warranties and confers
no rights

--------------------
| From: (e-mail address removed) (newbieTW)
| Newsgroups: microsoft.public.frontpage.client
| Subject: Re: Webbot FP_FieldLink FP_FeidlVal question
| Date: 18 Mar 2004 07:05:45 -0800

|
| Hi Vijay,
|
| Thank you. It is working now. May I ask few simple questions?
| 1) Why I can use the FP_FieldVal and FP_FieldLink call even thou I
| don't have the <webbot.....> line?
|
| 2) Can you recommand some good sites about learning webbot? I went to
| 3w.org and totally lost. It doesn't have anything I saw in my page
| such as s-cloumnname, s-link etc. Is webbot strictly working with
| database?
|
| 3) What are these fp_fieldval and fp_fieldlink calls? Are they ASP or
| ForntPage script? Can you recommand any sites that teach the syntax on
| this language? Does it mean I can use these language in the HTML page
| where ever I want and have it talk to database without using DRW?
|
| Thanks,
| Tara
|
|
| (e-mail address removed) (Vijay R Gangolli [MSFT]) wrote in message
| > Hi Tara,
| >
| > Add the following TD manually to the Table in HTML view,
| >
| > <td height="19"><a
| >
href="<%=FP_FieldVal(fp_rs,"linkpage")%>"><%=FP_FieldVal(fp_rs,"category")%>
| > </a></td>
| >
| > Regards,
| > Vijay
| >
| > Disclaimer: This posting is provided "as is" with no warranties and
confers
| > no rights
| >
| > --------------------
| > | From: (e-mail address removed) (newbieTW)
| > | Newsgroups: microsoft.public.frontpage.client
| > | Subject: Webbot FP_FieldLink FP_FeidlVal question
| > | Date: 17 Mar 2004 12:21:17 -0800
| > |
| > | Hi,
| > | I have a result page generated by DRW. All the codes/script are FP
| > | generated. I'm trying to display column_1 but it hyper links to the
| > | value in column_2. Is it do-able? I need to have
| > | fp_fieldlink(fp_rs,"linkpage") and fp_fieldval(fp_rs,"category"). I'm
| > | using FP 2002.
| > |
| > | Here is the code in my page:
| > |
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="Key,MFG_Name,Release_month,Release_day,Release_year,Category,
| > Remote_computer_name,User_name,Browser_type,Timestamp,LinkPage"
| > | s-column="Category"
| > | b-tableformat="TRUE"
| > | b-hashtml="FALSE"
| > | b-makelink="TRUE"
| > | clientside
| > | b-MenuFormat
| > | preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;&lt;
| > | a href=&quot;.&quot;&gt;Category&lt;/a&gt;&lt;font
| > | size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
| > | startspan -->
| > | <%="<a href=""" & FP_FieldLink(fp_rs,"Category") & """>" &
| > | FP_FieldVal(fp_rs,"Category") & "</a>"%>
| > | <!--webbot bot="DatabaseResultColumn" endspan i-checksum="22085" -->
| > |
| > | Thanks in advance.
| > |
| > | Tara
| > |
|
 
Back
Top