Michelle,

All the Q&A articles and index for my website are generated by TEXTMERGE code. I also use VFP code to build a site for my dad that slices and dices a membership roster database several ways. FWIW I think it's better than builing one huge string that you have to keep adding to:

\<<PGHEADER>>
scan
   \<<table.field>>
endscan
\<<PGFOOTER>>

Instead of

lcHTML = PGHEADER
scan
   lcHTML = lcHTML + transform( table.field )
endscan
lcHTML = lcHTML + PGFOOTER

At any rate generating HTML with VFP is extremely easy.

>My husband runs a website that could really use a database. Unfortunately, the server it's on doesn't allow any kind of CGI or ASP or anything. So what he wants me to do is write a VFP program that he can run on his desktop that will maintain the database and generate HTML pages. He'll then upload the HTML pages to the server.
>
>Any suggestions for the best way to do the HTML part? I was thinking of the "textmerge" command since it's just text. I've never used it before, but from poking around in the help, it looks like it will do what I need.
>
>Basically, I'll have a template of all the HTML code and I just need to fill in the parts that are variable.