Query error.tbl

[davidtg]

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

[John]

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>

[mark]

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

[davidtg]

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

[mark]

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"