Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Experience with additional tables and timpstamp ?

Quote Reply
Experience with additional tables and timpstamp ?
Hi all,
i have added some further tables to LSQL for additional infos, pics and some other stuff.
While adding them to db_nav.html ist very easy to mange them, in most of my tables i use the field LinkID to hold the ID of the row in table Links.
Evrything is fine so far, but if i change only a row in one of this tables, i have no change for the timestamp for that row in the Links table.
So i have to build with build all. Cause i build a lot of additional static detailed pages (for every link till 6) there is a lot of to do for the machine.
One way is to change a dummy field in the links table very time i change a field for that ID in another table, but a better way should be to change the timestamp in the links table automatically.

Has someone done this before?

At the moment i try to find the right places where LSQL does change that thing, as i remember to 1.x we had an extra table to hold changed IDs,
now the timestamp does this.

Robert
Subject Author Views Date
Thread Experience with additional tables and timpstamp ? Robert 2065 Feb 1, 2003, 9:28 PM
Post Re: [Robert] Experience with additional tables and timpstamp ?
Robert 1981 Feb 1, 2003, 9:36 PM
Thread Re: [Robert] Experience with additional tables and timpstamp ?
pugdog 1995 Feb 2, 2003, 11:15 AM
Post Re: [pugdog] Experience with additional tables and timpstamp ?
Robert 1961 Feb 2, 2003, 1:58 PM