Gw to query last entry

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

Gw to query last entry

Post by Thunderstone »



Is there a way to get the last url entered into a database
using GW?




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

Gw to query last entry

Post by Thunderstone »




That's a somewhat vague question. I'll assume you are using version 2.1.

To get the last Url added to the html table:
texis -s -d db -l 1 "select Url from html order by id desc"

To get the last Url issued to the gw command:
texis -s -d db -l 1 "select String from options where Name='URL' order by id desc"

See http://www.thunderstone.com/gw2man/node15.html for a description
of Webinator tables and http://www.thunderstone.com/texisman/node42.html
for more fun with SQL queries.


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

Gw to query last entry

Post by Thunderstone »

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

Gw to query last entry

Post by Thunderstone »





Thanks for catching that. It will be amended soon.

Thunderstone


Post Reply