I am trying to understand this code... [FrontPage]

Prev: Photos
Next: Problem using Firefox browser

From: Henry Stock on 26 Jul 2008 11:50

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>

From: Kathleen Anderson on 26 Jul 2008 12:39

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" <henry(a)henry-stock.com> wrote in message
news:eALtJdz7IHA.5596(a)TK2MSFTNGP02.phx.gbl...
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>

From: Henry Stock on 27 Jul 2008 14:15

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" <kanderson(a)remove.mvps.org> wrote in message
news:OPv3p4z7IHA.3384(a)TK2MSFTNGP04.phx.gbl...
> 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" <henry(a)henry-stock.com> wrote in message
> news:eALtJdz7IHA.5596(a)TK2MSFTNGP02.phx.gbl...
> 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>
>

From: Kathleen Anderson on 27 Jul 2008 15:59

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

"Henry Stock" <henry(a)henry-stock.com> wrote in message
news:OHYr5SB8IHA.3652(a)TK2MSFTNGP04.phx.gbl...
> 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?
>

|
Pages: 1
Prev: Photos
Next: Problem using Firefox browser