Forum Moderators: open

Message Too Old, No Replies

Site Map

         

stevelibby

4:45 pm on Feb 17, 2005 (gmt 0)

10+ Year Member



Hi all
I want ot create a site map using my sql database, i created a table to which would have id, category, link, and finally page title, however i want this to pick up the title tags that are in the web page...any ideas, without it being to complicated.?
Thank you in advance.

dotme

9:48 pm on Feb 17, 2005 (gmt 0)

10+ Year Member



Well, if it were me (and I'm an old fashioned ASP coder) I would write a page that uses the Microsoft XML object to iteracte through the SQL table, hit the pages, parse the HTML and return the title tag, which I would then update the SQL table with.

Not sure if that's the help you needed, but I thought I'd throw it out there :-)

carguy84

4:55 am on Feb 19, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



How about storing the title tag text in the database and making it that much more easy to update and pull out? It seems you already have the title field, any reason you can't update them to match what is currently on the site? Or is that what you're trying to do in an automated process? If that's the case, do it with a regular expression and the fileSystemObject. It will whip through in no time.

Chip-