Webbots - hey what?

Dennis · Apr 21, 2004

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!

Net55 · Apr 21, 2004

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>
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="Key,Name,Address,Choice" s-column="Key" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-
1">&lt;&lt;</font>Key<font
size="-1">&gt;&gt;</font>"

startspan --> said:
</td>

<td>
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="Key,Name,Address,Choice" s-column="Name" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-
1">&lt;&lt;</font>Name<font
size="-1">&gt;&gt;</font>"

startspan --> said:
</td>

<td>
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="Key,Name,Address,Choice" s-column="Address" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-
1">&lt;&lt;</font>Address<font
size="-1">&gt;&gt;</font>"

startspan --> said:
</td>

<td>
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="Key,Name,Address,Choice" s-column="Choice" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-
1">&lt;&lt;</font>Choice<font
size="-1">&gt;&gt;</font>"

startspan --> said:
</td>

</tr>
<!--webbot bot="DatabaseRegionEnd" b-
tableformat="TRUE" b-menuformat="FALSE" u-
dbrgn2="fpweb:///_fpclass/fpdbrgn2.inc" i-groupsize="5"
clientside tag="TBODY" preview="<tr><td
colspan=64 bgcolor="#FFFF00" width="100%
"><font color="#000000">This is
the end of a Database Results
region.</font></td></tr><TR><TD
VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT
TYPE=Button VALUE=" |< "><INPUT
TYPE=Button VALUE=" < "><INPUT
TYPE=Button VALUE=" > "><INPUT
TYPE=Button VALUE=" >| "> [1/5]
</NOBR><BR></td></tr>" startspan --

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

</tr>

</tbody>
</table>

</body>

</html>

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

http://www.frontpagewiz.com

Lisa Wollin \(Microsoft\) · Apr 21, 2004

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/cpyright.htm.

Connect to SQL without webbot	2	Apr 14, 2004
Discussion Web "Reply": What is the attack signature?	1	Apr 28, 2006
Database table add record form w/DD - not working	3	Dec 13, 2005
Discussion Formum	1	Jan 1, 2005
Difficult WEBBOT navigation bar question	0	Sep 21, 2004
FP2003 DIW update problem	0	Jan 13, 2005
Database Results Error	2	Nov 24, 2004
Works on local machine but not on server	1	Jun 10, 2004

Webbots - hey what?

Dennis

Net55

Lisa Wollin \(Microsoft\)

Ask a Question

Similar Threads