Frontpage 2003 - MS Access DB / web bots

[Fred]

Hello Group,

I'm having all sorts of problems trying to customize the html being create
in a asp page after using the database results wizard. Does anyone have any
suggestions for me?

Here is what I'm trying to do:

I have a MS Access table with 2 columns - category-id, category-name.
I want to return rows from this table and create hyperlinks in the format
<a href="main.asp?lookup=category-id">category-name</a>

Where I'm having my problem is modifying the page source code after the DRW
runs to create the hyperlinks from my query results. Is it easer to bypass
the DRW (and the resulting web bots) and code the ASP (vbscript) directly?

I have found some sample code on www.w3schools.com in the ADO tutorial on
how to query a database. These samples seen straing forward but I can't
connect to my database I defined in my site settings. How do I refer to the
connection to the database ( I named it 'database1') that I have setup in
the site settings?

Any suggestions would help out a lot.

Fred

 

[Bill Schroyer]

This will allow you to edit the page, but once run you
cannot use the wizard, so keep a backup copy.
http://www.frontpagewebmaster.com/m-54911/tm.htm

Bill Schroyer
(e-mail address removed)
http://www.frontpagewiz.com

 

[Fred]

Bill / Group

Thanks for the lead on the macro. I got it to work one time and it did what
I want. My only problem is that I can't consistantly run the macro. Most of
the times that I run the macro ther is no changes.

What am I missing or doing wrong?

Fred