I am trying to understand this code...

's Computer Specifications

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>

's Computer Specifications

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

"Henry Stock" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
> "Henry Stock" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> 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>
>

's Computer Specifications

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/resour...sandtricks.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

"Henry Stock" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Please. Help me understand this code	Viper	Microsoft Access	4	29th Jan 2007 07:59 PM
Help - Can't understand Code	=?Utf-8?B?QW5nZWxpbmU=?=	Microsoft Access Forms	8	29th Mar 2006 12:36 PM
Don't Understand Code	miracleblake	Microsoft Excel Discussion	3	8th Dec 2005 08:12 PM
Help me understand this code	Carrot	Microsoft Excel Misc	2	14th Oct 2005 06:07 AM
Code I don't Understand	Mary/Phil Stewart	Microsoft Access	4	11th Feb 2004 05:39 AM