This is the 2nd? 3rd? time you've asked this question and it's off-topic for the DBI list.
What you really want is HTTP session management. You use cookies (or a per-session mangled URL) for that. There are lots of ways to roll this ball, but the one I personally use is Apache::ASP and its Session object. www.apache-asp.org there is probably a way to do this straight from CGI.pm but Apache::ASP makes it all transparent. On Sun, 7 Apr 2002, Vickydhiman wrote: ... > Hi , > Iam stuck and need urgent help. > First, tell me how do we create sessions for users > using Perl DBI on Oracle, > I dont want users coming to my site (amateur one at > that) only for my project, to enter each time their > user name and password for any queries. > Since DBI does is establishes a connection, perfomrs > the query and then disconnects. > SO how do we do it,. > wHAT Iam doing now is this: > MAke a table of all the users and their passwrds, then > check for their login, > then fetch all this info along with theri remote_addr > (cgi) to another table and then connect all the time > as a su, and fertch the info from this trable and then > login to oracle using perl dbi. > BUt this is really too long and works very slowly. > Anyway aroundu know of. > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- Orlando Andico <[EMAIL PROTECTED]> Mosaic Communications, Inc.
