Can someone show me a trigger that would insert a timestamp into a column of a record everytime that record was changed? Something like a last updated trigger.
Would anyone know how I could datetime stamp a record in a database results page eveytime the record is updated. I'm using SQL server and tried to do this by adding a colum in the table I'm editing that has the formula getdate() but updates every row when I try and edit one. Any ideas would be...
How do I get a datetime stamp on a single record instead of all the records. I have a colum for this with the getdate() formula but everytime I change one record it updates for all the records.
Is there a way to redirect.response to browser history say 2 pages back? What I'm trying to accomplish is when a user decides to cancel a out of editing a record, to send him/her to start page of the record without having to pass the variable since the record has not changed so there would be no...
When i submit information into my database via a form it places spaces in any field I leave blank or if I have a 15 char limit and only put 10 it will fill up the remaining 5 with spaces. How do I stop this?
Hi I'm pretty new to FrontPage (and web design for that matter). I'm trying to create an interface for my database and it works fine (using SQL server 2k). The problem I'm having is the limitations of the wizard makes unable to edit two tables at once using a like field. In other words I can...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.