Hi there,

I need to publish some magazine articles to a web site. The problem is that I don't know how should I do this.

Our site will be using Access (for now) as it's DB system. I don't think that including all the content and images into a Memo field (or something like that) is the best way, as it will generate lots of work on the server.

Maybe uploading the html files and it's images is the dest thing to do. But!!!!! How do I manage this???

The idea is to have a template where the content is to be shown. Do I have to strip all the tags before BODY so I can iclude the file on the template?

As you can see I have no idea of how to do it. I have some baisc knowledge on creating a News system where al the information is on a DB field, but I really don't think this is the best option in this case.

Please any help is very apreciated. Links, tutorials etc.....

Thaks a lot

PS: I'm not a programe too. I'm using Ultradev capabilities.

Diego de Barros Franco e Souza Mello

I suggest that you first take a good look what the content of the articles is. You should build a database based on your content, not the other way. Second, mind that you see content and design as two separate things. For example if you have a simple article that contains some plain text, a table with three fields e.g. with ArticleID [autonumber], Topic [text] and Content[memo] could be enough. If you have more specific data like dates of the article it is wise to implement them too.

When you're finished with your database, take a look at your design. You're right, using templates is very import when keeping webpages consistent and they make it a lot easier to maintain your website. Now use your templates and simply drag your dynamic data into them. I assume you know how to do this, else there are quite a lot of tutorials on this site and other ASP related sites.

Note that the better your database is set up, the better and more functional your website will be! You said that you weren't a programmer. Me neither but working with Dreamweaver Ultradev for a while now, it's getting more and more important to learn raw ASP coding. But I recommend you start with the basics.

Good luck.

Hi Rein,

Thanks for your reply. My problem is that I have to include images too. I'm stuck on how to deal with this. I beleave that in a few months I'll have lots of informations uploaded, and probably Access won't be able to deal with it if the number of requests becomes as big as I hope it does.

Because all of this I'm worried to work with memo fields.

Diego de Barros Franco e Souza Mello

I recommend to use memo fields only for plain text which exceed 255 characters. I think the best way to include dynamic images is to make a text field where you're going to put the URL of the image. You can, of course, add some extra information in your database about the image for end-user or administration purposes.

In Ultradev you can make an image dynamic by selecting Insert Image and instead of choosing a file you choose a datasource, in this case, your image URL from the database.

I don't know how much visitors your expecting, but when it's getting really big you might want to think of upsizing to PHP and MySQL or even SQL server. I have a rather busy website and still it handles everything perfectly, even with many concurrent connections. Mind to optimize your ASP code, check out the tutorials from 4guysfromrolla.com

Well, good luck again!