How do I list all the pages ?

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

How do I list all the pages ?

Post by Thunderstone »



Hey Everyone,

How do I list all the pages indexed on a site ?. Is it possible ? If it
does work, does it come out alphabetically ?

Please respond via E-mail.

Best Regards,

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

How do I list all the pages ?

Post by Thunderstone »




gw -dDBNAME -sc "select Url from html"

Will list the Urls

gw -dDBNAME -sc "select Url from html order by Url"

Will list them alphabetically.

See: http://www.thunderstone.com/gwman/node15.html for a list of
Webinator Database fields accessible via Texis SQL.

See the Texis manual for an explanation of SQL in general.

Happy Walking,

Thunderstone


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

How do I list all the pages ?

Post by Thunderstone »



Thunderstone - EPI wrote:

Bart, I am going to ask A REALLY DUMB QUESTION. How do I find out the
database name ?. I can see the tables and files in the /db directory
but where is the database named at ? Is it possible to use qwebinator
with an Oracle database ?.

Best Regards,

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

How do I list all the pages ?

Post by Thunderstone »




The directory with the tables and files ("/db" in your example) IS the
name of the database.