If you were using Oracle, I could tell you how to write
a trigger to insert a record into an audit table each
time someone did an update, delete etc...
SQL Server must have triggers as well...
I assume that is what you were referring to.
Quoting "Mukka, Srikanth" <[EMAIL PROTECTED]>:
> Hi Geeta,
>
> One more question from my side.
> Once the table data is displayed, how do we keep track
of the changes made
> to the data like insert,update and delete of data by
user.
>
> Hope you understand my question.
> Srikanth
>
> -----Original Message-----
> From: Geeta Ramani [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 13, 2000 7:18 AM
> To: [EMAIL PROTECTED]
> Subject: Re: displaying all the tables in my webpage
>
>
> Sumit:
>
> Ok, how about this: Say your initial web page with all
the table names in
> it
> is
> called allNames.jsp. Clicking on the hyperlink causes
a servlet to go into
> action, which in turn sets a session variable with all
the data of that
> particular table in it. Once this is done redirect to
> allNames.jsp?newWindow=true, which as the name
indicates, is simply
> allNames.jsp
> except a new "child" window is also created (with
Javascript of course).
> The
> content of childWindow will be say tableData.jsp which
simply reads the
> data
> from the session variable and displays it.
>
> Hope this is clear??
> Geeta
>
> sumit deogharia wrote:
>
> > Hi Geeta
> >
> > I quite agree with u , it is a straight-forward
problem... now what
> is
> > giving me trouble is clicking on the hyperlink and
opening a new window;
> do
> > i write window.open() and pass the url holding the
servlet .... here is
> > where I'm getting confused
> >
> > Sumit
> >
> > On Fri, 13 Oct 2000 09:16:07 -0400, A mailing list
for discussion about
> Sun
> > Microsystem's Java
> > Servlet API Technology. wrote:
> >
> > > Hi Sumit:
> > >
> > > On the face of it, this seems like a fairly
straightforward problem.
> Is
> > there
> > > some particular aspect that is giving you
trouble?
> > > Apologies in advance if I have misunderstood your
question.
> > >
> > > Regards,
> > > Geeta
> > >
> > > sumit deogharia wrote:
> > >
> > > > Hi
> > > >
> > > > I am writing a servlet that will take in
the names of all the
> > tables
> > > > created in SQL server and display them as a
hyperlink on the web
> page
> > > > created by the servlet. When I should click on
the hyperlink it
> should
> > open
> > > > a new window which will display all the data
from the table.
> > > > Can u help me in this regard
> > > >
> > > > Thanks in advance
> > > >
> > > > Sumit
> > > >
> > > >
_______________________________________________________
> > > > Say Bye to Slow Internet!
> > > > http://www.home.com/xinbox/signup.html
> > > >
> > > >
> >
>
________________________________________________________
___________________
> > > > To unsubscribe, send email to
[EMAIL PROTECTED] and include in
> the
> > body
> > > > of the message "signoff SERVLET-INTEREST".
> > > >
> > > > Archives:
>
http://archives.java.sun.com/archives/servlet-interest.h
tml
> > > > Resources:
>
http://java.sun.com/products/servlet/external-resources.
html
> > > > LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html
> > >
> > >
> >
>
________________________________________________________
___________________
> > > To unsubscribe, send email to
[EMAIL PROTECTED] and include in the
> > body
> > > of the message "signoff SERVLET-INTEREST".
> > >
> > > Archives:
http://archives.java.sun.com/archives/servlet-interest.h
tml
> > > Resources:
>
http://java.sun.com/products/servlet/external-resources.
html
> > > LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html
> >
> >
_______________________________________________________
> > Say Bye to Slow Internet!
> > http://www.home.com/xinbox/signup.html
> >
> >
>
________________________________________________________
___________________
> > To unsubscribe, send email to [EMAIL PROTECTED]
and include in the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives:
http://archives.java.sun.com/archives/servlet-interest.h
tml
> > Resources:
http://java.sun.com/products/servlet/external-resources.
html
> > LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html
>
>
________________________________________________________
___________________
> To unsubscribe, send email to [EMAIL PROTECTED]
and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives:
http://archives.java.sun.com/archives/servlet-interest.h
tml
> Resources:
http://java.sun.com/products/servlet/external-resources.
html
> LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html
>
>
________________________________________________________
___________________
> To unsubscribe, send email to [EMAIL PROTECTED]
and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives:
http://archives.java.sun.com/archives/servlet-interest.h
tml
> Resources:
http://java.sun.com/products/servlet/external-resources.
html
> LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html
>
Andrew Dingfelder
Computing As You Like It
108 Blanchard St., Raleigh NC 27603
[EMAIL PROTECTED]
Phone (919) 828-9824
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
