954,595 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Help migrating static html tables to database

Hi, I'm a newb so go easy on me ok :)
I have a blog directory site that I built in static html a few years ago never expecting it to take off, but it has, and now I really need to move all of the info to a database cos updating it is killing me.
Here's and example of a page that I want to migrate:
http://www.dogswithblogs.com.au/theblogs7.htm
Its pretty important that the tables be sortable as they are now, and the pages be laid out the same way.
I have no idea where to start, so any assistance would be gratefully appreciated.
Thanks
Greg

haboota
Newbie Poster
4 posts since Mar 2010
Reputation Points: 10
Solved Threads: 0
 

What you need to do is strip out the values from your HTML and insert the data into a DB table. Then use classic ASP to read the data back from the DB.

It would be easier to use c# / VB.NET to do this as it'll do most of the re-ordering for you with a gridcontrol but if you are going to use classic ASP then you will have to code this yourself using the querystring and passing through the "order by" value to your SQL.

WebspoonUK
Newbie Poster
22 posts since Mar 2010
Reputation Points: 10
Solved Threads: 2
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: