I am trying to understand this code...

Henry Stock · Jul 26, 2008

This is the automatically generated code from the FrontPage Sample Interface. I am trying to understand this so I can figure out where I can add
business logic, etc. to an interface. I gather that the lines in gray are generated by FrontPage.

Can this part be edited manually?

It looks like the area that specifies much of the the information about the query, the tabes used and the columns that will be shown.

What does 202 stand for?

Is i-groupsize the number of records to show per page?

What are the include files shown here?




What are the checksums all about? For example: i-checksum="35618"

This doesn't look like stuff I was expecting to see, ADO recordsets etc.



<% 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 Customers"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Sample"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&CustomerID=202&CompanyName=202&ContactName=202&ContactTitle=202&Address=202&City=202&Region=202&PostalCode=202&Country=202&Phone=202&Fax=202&"
fp_iDisplayCols=11
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>



<tr>

<td>
<%=FP_FieldVal(fp_rs,"CustomerID")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"CompanyName")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"ContactName")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"ContactTitle")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Address")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"City")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Region")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"PostalCode")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Country")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Phone")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Fax")%>
</td>

</tr>


</tbody>

Kathleen Anderson · Jul 26, 2008

Inline.

--

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

This is the automatically generated code from the FrontPage Sample
Interface. I am trying to understand this so I can figure out where I can
add
business logic, etc. to an interface. I gather that the lines in gray are
generated by FrontPage.

Can this part be edited manually?

KA: Yes. When you save the changes to the gray code, the chnages are
replicated to the maroon colored color (which you should never tough, BTW).

It looks like the area that specifies much of the the information about the
query, the tabes used and the columns that will be shown.

What does 202 stand for?

KA: It defines the field type - don't recall exactly what a 202 is, but
there is a list somewhere.

Is i-groupsize the number of records to show per page?

KA: Yes.

What are the include files shown here?




KA: These files contain the Active Server Page scripts used to implement the
server-side functionality for database features. fpdblib.inc contains the
library functions used by the database features. fpdbrgn1.inc contains the
ASP code that establishes the database connection, and constructs and
executes the query, starting a loop through all database records.
fpdbrgn2.inc contains the ASP code that finishes the query loop started by
fpdbrgn1.inc and closes the database connection.

What are the checksums all about? For example: i-checksum="35618"

KA: Not sure.

This doesn't look like stuff I was expecting to see, ADO recordsets etc.

<% if 0 then %><SCRIPT Language="JavaScript">document.write("<div style='background: yellow; color: black;'>The DatabaseResults component on this page is unable to display database content. Thepage must have a filename ending in '.asp', and the web must be hosted on aserver that supports Active Server Pages.</div>");</SCRIPT><% end if %><%fp_sQry="SELECT * FROM Customers"fp_sDefault=""fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No recordsreturned.</td></tr>"fp_sDataConn="Sample"fp_iMaxRecords=256fp_iCommandType=1fp_iPageSize=5fp_fTableFormat=Truefp_fMenuFormat=Falsefp_sMenuChoice=""fp_sMenuValue=""fp_sColTypes="&CustomerID=202&CompanyName=202&ContactName=202&ContactTitle=202&Address=202&City=202&Region=202&PostalCode=202&Country=202&Phone=202&Fax=202&"fp_iDisplayCols=11fp_fCustomQuery=FalseBOTID=0fp_iRegion=BOTID%> <tr> <td> <%=FP_FieldVal(fp_rs,"CustomerID")%> </td> <td> <%=FP_FieldVal(fp_rs,"CompanyName")%> </td> <td> <%=FP_FieldVal(fp_rs,"ContactName")%> </td> <td> <%=FP_FieldVal(fp_rs,"ContactTitle")%> </td> <td> <%=FP_FieldVal(fp_rs,"Address")%> </td> <td> <%=FP_FieldVal(fp_rs,"City")%> </td> <td> <%=FP_FieldVal(fp_rs,"Region")%> </td> <td> <%=FP_FieldVal(fp_rs,"PostalCode")%> </td> <td> <%=FP_FieldVal(fp_rs,"Country")%> </td> <td> <%=FP_FieldVal(fp_rs,"Phone")%> </td> <td> <%=FP_FieldVal(fp_rs,"Fax")%> </td> </tr>  </tbody>

Henry Stock · Jul 27, 2008

Well, if I should not manipulate the code in gray, i.e. the code generated
by the webbot, how do I control what fields are displayed and where to I
stick any business logic that may come in to the equation.?

Let's say I have an insert data form and that insertion will control
insertions to multiple tables. Where do I call that code? In response to
the submit button before posting or a part a post form?

Kathleen Anderson said:
Inline.

--

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

This is the automatically generated code from the FrontPage Sample
Interface. I am trying to understand this so I can figure out where I can
add
business logic, etc. to an interface. I gather that the lines in gray
are generated by FrontPage.

Can this part be edited manually?

KA: Yes. When you save the changes to the gray code, the chnages are
replicated to the maroon colored color (which you should never tough,
BTW).

It looks like the area that specifies much of the the information about
the query, the tabes used and the columns that will be shown.

What does 202 stand for?

KA: It defines the field type - don't recall exactly what a 202 is, but
there is a list somewhere.

Is i-groupsize the number of records to show per page?

KA: Yes.

What are the include files shown here?




KA: These files contain the Active Server Page scripts used to implement
the server-side functionality for database features. fpdblib.inc contains
the library functions used by the database features. fpdbrgn1.inc contains
the ASP code that establishes the database connection, and constructs and
executes the query, starting a loop through all database records.
fpdbrgn2.inc contains the ASP code that finishes the query loop started by
fpdbrgn1.inc and closes the database connection.

What are the checksums all about? For example: i-checksum="35618"

KA: Not sure.

This doesn't look like stuff I was expecting to see, ADO recordsets etc.

<%
if 0 then %><SCRIPT Language="JavaScript">document.write("<div
style='background: yellow; color: black;'>The DatabaseResults component on
this page is unable to display database content. Thepage must have a
filename ending in '.asp', and the web must be hosted on aserver that
supports Active Server Pages.</div>");</SCRIPT><% end if
%><%fp_sQry="SELECT * FROM Customers"fp_sDefault=""fp_sNoRecords="<tr><td
colspan=11 align=""LEFT"" width=""100%"">No
recordsreturned.</td></tr>"fp_sDataConn="Sample"fp_iMaxRecords=256fp_iCommandType=1fp_iPageSize=5fp_fTableFormat=Truefp_fMenuFormat=Falsefp_sMenuChoice=""fp_sMenuValue=""fp_sColTypes="&CustomerID=202&CompanyName=202&ContactName=202&ContactTitle=202&Address=202&City=202&Region=202&PostalCode=202&Country=202&Phone=202&Fax=202&"fp_iDisplayCols=11fp_fCustomQuery=FalseBOTID=0fp_iRegion=BOTID%> <tr> <td> <%=FP_FieldVal(fp_rs,"CustomerID")%> </td> <td>
<%=FP_FieldVal(fp_rs,"CompanyName")%> </td> <td>
<%=FP_FieldVal(fp_rs,"ContactName")%> </td> <td>
<%=FP_FieldVal(fp_rs,"ContactTitle")%> </td> <td>
<%=FP_FieldVal(fp_rs,"Address")%> </td> <td> <%=FP_FieldVal(fp_rs,"City")%> </td> <td> <%=FP_FieldVal(fp_rs,"Region")%> </td> <td> <%=FP_FieldVal(fp_rs,"PostalCode")%> </td> <td>
<%=FP_FieldVal(fp_rs,"Country")%> </td> <td> <%=FP_FieldVal(fp_rs,"Phone")%> </td> <td> <%=FP_FieldVal(fp_rs,"Fax")%> </td> </tr>  </tbody>

Kathleen Anderson · Jul 27, 2008

Hi Henry:
You CAN touch the gray code - it's the maroon code you shouldn't touch. You
can control what fields are displayed when you run the Database Wizard. You
can add logic by modifying the SQL statement. This page:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp has a lot of
resources and tutorials if you want to modify the code generated by the
Wizard.

--

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

any ideas why I can update one table in my database but not the other?	2	Sep 22, 2006
@ my wits end	1	Sep 12, 2006
Please help, FP generated code produces a "Too few parameters. Expected1" error!	7	Jun 6, 2005
Database Results Error	1	Sep 9, 2004
DataBase results Error continued	1	Sep 10, 2004
Problem with form validation	1	Jul 19, 2004
DRW manual code	4	Jul 13, 2005
Drop down box query no.2	1	Dec 11, 2004

I am trying to understand this code...

Henry Stock

Kathleen Anderson

Henry Stock

Kathleen Anderson

Ask a Question

Similar Threads