Asp Forum - Webbots - hey what? - microsoft.public.frontpage.programming

Dennis

4/21/2004 2:39:00 PM

All,

In looking at the code Microsoft generates when I ask FP to put a link to my
Access DB onto my web page, I see a lot of Webbot stuff rather than the
JScript, VBScript and ASP I was expecting. Thus far, in my reading, I
haven't come across discussions and/or references to webbot technology with
respect to FP + Access. Can someone give me a thumbnail orientation here
and maybe some links/references that I can read to better understand this
stuff?

Many thanks!

--
Dennis Gallagher
Monroe, WA, USA

2 Answers

Net55

4/21/2004 4:40:00 PM

webots allow you to edit the FrontPage asp through wizards.
It is not neccessary for code to be there, but if you
remove it and want to edit the page you will need to edit
the code in html or code view.

Here is what a db looks like with webbot and under this
without:
------------------
<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 2</title>
</head>

<body>

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>Key</b></th>
<th ALIGN="LEFT"><b>Name</b></th>
<th
ALIGN="LEFT"><b>Address</b></th>
<th ALIGN="LEFT"><b>Choice</b></th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color:
black;'>The Database Results component on this page is
unable to display database content. The page must have a
filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Results"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=4 align=""LEFT""
width=""100%"">No records returned.</td></tr>"
fp_sDataConn="database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Key=3&Name=202&Address=203&Choice=2&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Key")%><%=FP_FieldVal(fp_rs,"Name")%><%=FP_FieldVal(fp_rs,"Address")%><%=FP_FieldVal(fp_rs,"Choice")%>
</tbody>
</table>

</body>

</html>

------------------------------

With out webbot

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 2</title>
</head>

<body>

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>Key</b></th>
<th ALIGN="LEFT"><b>Name</b></th>
<th
ALIGN="LEFT"><b>Address</b></th>
<th ALIGN="LEFT"><b>Choice</b></th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color:
black;'>The Database Results component on this page is
unable to display database content. The page must have a
filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Results"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=4 align=""LEFT""
width=""100%"">No records returned.</td></tr>"
fp_sDataConn="database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Key=3&Name=202&Address=203&Choice=2&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Key")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Address")%
></td>
<td>
<%=FP_FieldVal(fp_rs,"Choice")%
></td>
</tr>

</tbody>
</table>

</body>

</html>

Here is a Macro that will do this for you:
http://www.frontpagewebmaster.com/m-54...

http://www.frontp...

>-----Original Message-----
>All,
>
>In looking at the code Microsoft generates when I ask FP
to put a link to my
>Access DB onto my web page, I see a lot of Webbot stuff
rather than the
>JScript, VBScript and ASP I was expecting. Thus far, in
my reading, I
>haven't come across discussions and/or references to
webbot technology with
>respect to FP + Access. Can someone give me a thumbnail
orientation here
>and maybe some links/references that I can read to better
understand this
>stuff?
>
>Many thanks!
>
>--
>Dennis Gallagher
>Monroe, WA, USA
>
>
>.
>

Lisa Wollin \(MS\)

4/21/2004 7:46:00 PM

Hi, Dennis,

Webbots are generally used with the FrontPage Server Extensions. FrontPage
inserts them for features like databases, form processing, email processing,
hit counters, etc. Anytime you insert a FrontPage Web component, FrontPage
will insert Webbot code. Some of this code is used on the client side, and
FrontPage will remove it when you publish the page; in this case the Server
Extensions are not involved. Other code requires server-side processing
(like ASP) and the Server Extensions will convert to HTML when someone
accesses the page from the Internet.

In your case, the webbot code is necessary for the Server Extensions to
properly convert the code to HTML.

In versions earlier than FP 2003, released last October, all database
processing was accomplished through webbot code. However, in FP 2003, you
could choose to use either ASP or ASP.NET code for database processing.

Hope this helps.

--
Lisa Wollin
Programmer Writer
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included code samples are subject to the terms specified at
http://www.microsoft.com/info/cp....
"Dennis" <junk@galron.com> wrote in message
news:uM1%23T46JEHA.228@TK2MSFTNGP10.phx.gbl...
> All,
>
> In looking at the code Microsoft generates when I ask FP to put a link to
my
> Access DB onto my web page, I see a lot of Webbot stuff rather than the
> JScript, VBScript and ASP I was expecting. Thus far, in my reading, I
> haven't come across discussions and/or references to webbot technology
with
> respect to FP + Access. Can someone give me a thumbnail orientation here
> and maybe some links/references that I can read to better understand this
> stuff?
>
> Many thanks!
>
> --
> Dennis Gallagher
> Monroe, WA, USA
>
>

microsoft.public.frontpage.programming

Webbots - hey what?

Dennis

Net55

Lisa Wollin \(MS\)

x Login to ForumsZone