Displaying list of all Titles, Urls, and Meta tags

Post Reply
User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

Displaying list of all Titles, Urls, and Meta tags

Post by Thunderstone »




I'm wanting to come up with a way to generate a report that list all of the files on our site, so that we could verify that they have appropriate titles and meta tags. I can generate this information using gw, like so:

gw -d- -sh "select Url,Title,Meta from html order by Url"

However, that isn't really formatted the way I would like it. My thought is that perhaps I can come up with a vortex script (called, say, "pageinfo") that would format it the way I would like it, which would be an HTML page looking something like this:

Title Goes Here (as a link to the page)
Description: Description Goes Here
Keywords: Keywords Go Here

Title Goes Here (as a link to the page)
Description: Description Goes Here
Keywords: Keywords Go Here

Title Goes Here (as a link to the page)
Description: Description Goes Here
Keywords: Keywords Go Here

However, I don't know how to tell the Texis search to retrieve every page, rather than just the first 10 that match some search term.

Any suggestions?

Thanks,
Wally Hartshorn




User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

Displaying list of all Titles, Urls, and Meta tags

Post by Thunderstone »



To get all records, leave out the "max=10" <sql> option and leave out
the SQL "where" clause. Basically, do exactly the query you did in gw.
See http://www.thunderstone.com/vortexman/node35.html

<sql row "select Url,Title,Meta from html order by Url">
<a href="http://$Url">$Title</a><br>
Meta: $Meta
<p>
</sql>




Post Reply