Thunderstone Support Forums

Hi,

How can I query the error table to retrieve all the 404 errors from a url that was just walked? Something like:

'Select all from ERROR where url like "http://myurl/%" and error="404"'

I don't have your tsql app since this is just a Webinator install and I don't know the column names within the error.tbl file.

Any help on how I can access this information?

Thanks David

You can look in the dowalk script at the maketables and errors function to see the structure and examples of accessing the error table.

Something like:

<sql "select Url, Reason from error where Url matches 'http://myurl%' and Reason like '"returned code 404"'>
</sql>

See also "Walk database tables and fields" in the manual for a description of the fields.
http://www.thunderstone.com/texis/site/ ... and+Fields

Thanks for the help guys. I think I need a bit more hand holding.....I still unsure how could I execute the sql statements. Can I issue something from the command line or do I need to do some heavly vortex script lifting and build a script thats called via a url.

Thanks, David

You can write a simple vortex script and execute it from the command line: texis myscriptname
Or you can issue sql directly with texis
texis -d /my/database -s "select * from error"