Webbot FP_FieldLink FP_FeidlVal question

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
 
V

Vijay R Gangolli [MSFT]

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
|
 
N

newbieTW

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
 
V

Vijay R Gangolli [MSFT]

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
| > |
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I am trying to understand this code... 3
any ideas why I can update one table in my database but not the other? 2
Please help, FP generated code produces a "Too few parameters. Expected1" error! 7
Drop down box query no.2 1
@ my wits end 1
Problem with form validation 1
ASP displaying email link from database incorrectly 6
Database Results Error 1

Top