Problem: I have a MS Access database. I want to create individual web pages for each product in the table so people can use search engines find my product # and link to that page. Also, I would like to get the product name to display in the html <Title> tag.
So far, I am able to create a report which will export into individual html files/pages and display the product in the body. It displays the Report Name in the html <title> tag. So I'm close but can't bring it home. Here is the html I am currently generating:
<HTML>
<HEAD>
<METAHTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
<TITLE>MY BUSINESS NAME</TITLE>
</HEAD>
<BODY>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=28 >
<TDWIDTH=8 ALIGN=LEFT > <BR></TD><TDWIDTH=472 ALIGN=LEFT ><FONTstyle=FONT-SIZE:18pt FACE="Arial" COLOR=#000000>My Business</FONT></TD>
</TR>
</TABLE>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=14 >
<TDWIDTH=52 ALIGN=LEFT > <BR></TD><TDWIDTH=428 ALIGN=LEFT ><FONTstyle=FONT-SIZE:8pt FACE="Arial" COLOR=#000000>Call 1-800-123-4567 for current availability and price</FONT></TD>
</TR>
</TABLE>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=14 >
<TDWIDTH=80 ALIGN=LEFT > <BR></TD><TDWIDTH=44 ALIGN=LEFT ><FONTstyle=FONT-SIZE:8pt FACE="Arial" COLOR=#000000>1</FONT></TD>
<TDWIDTH=356 ALIGN=LEFT ><FONTstyle=FONT-SIZE:8pt FACE="Arial" COLOR=#000000>abc123v</FONT></TD>
</TR>
</TABLE>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=19 >
<TDWIDTH=108 ALIGN=LEFT > <BR></TD><TDWIDTH=372 ALIGN=LEFT ><FONTstyle=FONT-SIZE:12pt FACE="Arial" COLOR=#000000>visit MyBusiness.com</FONT></TD>
</TR>
</TABLE>
</BODY>
</HTML>
The highlighted "ABC123V" is a sample product name supplied by the data table. "MY BUSINESS NAME" is the Report Name. Each of the following pages are identified by a page # ie. <TITLE>MY BUSINESS NAMEPage2</TITLE> and ideally I would like it to read something like <TITLE>MY BUSINESS NAME| ABC123V</TITLE> The crawlers will find the product in the body but I was hoping to improve indexing by getting it in the title tag. All help appreciated.
So far, I am able to create a report which will export into individual html files/pages and display the product in the body. It displays the Report Name in the html <title> tag. So I'm close but can't bring it home. Here is the html I am currently generating:
<HTML>
<HEAD>
<METAHTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
<TITLE>MY BUSINESS NAME</TITLE>
</HEAD>
<BODY>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=28 >
<TDWIDTH=8 ALIGN=LEFT > <BR></TD><TDWIDTH=472 ALIGN=LEFT ><FONTstyle=FONT-SIZE:18pt FACE="Arial" COLOR=#000000>My Business</FONT></TD>
</TR>
</TABLE>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=14 >
<TDWIDTH=52 ALIGN=LEFT > <BR></TD><TDWIDTH=428 ALIGN=LEFT ><FONTstyle=FONT-SIZE:8pt FACE="Arial" COLOR=#000000>Call 1-800-123-4567 for current availability and price</FONT></TD>
</TR>
</TABLE>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=14 >
<TDWIDTH=80 ALIGN=LEFT > <BR></TD><TDWIDTH=44 ALIGN=LEFT ><FONTstyle=FONT-SIZE:8pt FACE="Arial" COLOR=#000000>1</FONT></TD>
<TDWIDTH=356 ALIGN=LEFT ><FONTstyle=FONT-SIZE:8pt FACE="Arial" COLOR=#000000>abc123v</FONT></TD>
</TR>
</TABLE>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=19 >
<TDWIDTH=108 ALIGN=LEFT > <BR></TD><TDWIDTH=372 ALIGN=LEFT ><FONTstyle=FONT-SIZE:12pt FACE="Arial" COLOR=#000000>visit MyBusiness.com</FONT></TD>
</TR>
</TABLE>
</BODY>
</HTML>
The highlighted "ABC123V" is a sample product name supplied by the data table. "MY BUSINESS NAME" is the Report Name. Each of the following pages are identified by a page # ie. <TITLE>MY BUSINESS NAMEPage2</TITLE> and ideally I would like it to read something like <TITLE>MY BUSINESS NAME| ABC123V</TITLE> The crawlers will find the product in the body but I was hoping to improve indexing by getting it in the title tag. All help appreciated.