HTX and IDC
[ Home ] [ Access - Start Here ] [ Excel In Depth ] [ MS Office ] [ Visio Info ] [ Creating Web Pages ] [ Technical References ] [ Viruses ] [ Points of View ] [ Gadgets ] [ Just Links ] [ Monash ]

   Search this site or the web       powered by FreeFind
 
  Site search Web search

Participate in Ananda's Discussions
Post a message

Monitor page
for changes
    
   it's private  

by ChangeDetection

Up

Paired IDC and HTX files

Basically, the IDC provides data retrieval details and the HTX supplies the formatting. Again, like the Static HTML option, a table of Customers is displayed even though the original Access form was for one customer. IDC and HTX only work with Microsoft IIS (Internet Information Server) or PWS (Personal Web Server) running on Windows NT Server or Windows '95/'98.

The HTX file contains <% %> placeholders for the fields, but is otherwise, standard HTML.

CUSTOMERS.IDC

Datasource:NWIND
Template:Customers_1.htx
SQLStatement:SELECT * FROM [Customers]
Password:
Username:

CUSTOMERS.HTX

<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
<TITLE>Customers</TITLE>
</HEAD>
<BODY>
<TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0 RULES=none><FONT FACE="MS Sans Serif" COLOR=#000000><CAPTION><B>Customers</B></CAPTION>

<THEAD>
<TR>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>CustomerID</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>CompanyName</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>ContactName</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>ContactTitle</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>Address</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>City</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>Region</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>PostalCode</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>Country</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>Phone</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="MS Sans Serif" COLOR=#000000>Fax</FONT></TH>

</TR>
</THEAD>
<TBODY>
<%BeginDetail%>
<TR VALIGN=TOP>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%CustomerID%><BR></FONT></TD>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%CompanyName%><BR></FONT></TD>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%ContactName%><BR></FONT></TD>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%ContactTitle%><BR></FONT></TD>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%Address%><BR></FONT></TD>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%City%><BR></FONT></TD>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%Region%><BR></FONT></TD>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%PostalCode%><BR></FONT></TD>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%Country%><BR></FONT></TD>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%Phone%><BR></FONT></TD>
<TD BORDERCOLOR=#808080 ><FONT SIZE=1 FACE="MS Sans Serif" COLOR=#800000><%Fax%><BR></FONT></TD>

</TR>
<%EndDetail%>
</TBODY>
<TFOOT></TFOOT>
</TABLE>
</BODY>
</HTML>