RE: $dbh->quote and LIKE

2000-03-30 Thread Gerald Richter
Hi, > > i know this is not a direct EmbPerl question, but most of you > fellow EmbPerl guys probably use DBI for database connectivity > and might have an idea, is there a "cleaner" solution to do > this thing: > > --- 8< --- > > $keyword=$dbh->quote($fdat{what}); > $keyword=~s/^\'//; > $keyword=~

RE: Session Management

2000-03-30 Thread Gerald Richter
Hi, > > >I suggest tring DBIFileStore first because it less complicated. If this > >works then we can try again DBIStore > > FileStore just works. :) > > Oracle wasn't committing updates, so DBIStore wasn't getting a look in. > AutoCommit was on, but obviously not effective. > > I'll be discussing

$dbh->quote and LIKE

2000-03-30 Thread indrek siitan
Hi, i know this is not a direct EmbPerl question, but most of you fellow EmbPerl guys probably use DBI for database connectivity and might have an idea, is there a "cleaner" solution to do this thing: --- 8< --- $keyword=$dbh->quote($fdat{what}); $keyword=~s/^\'//; $keyword=~s/\'$//; $sth=$db

RE: Session Management

2000-03-30 Thread Philip Plane
Hi, >I suggest tring DBIFileStore first because it less complicated. If this >works then we can try again DBIStore FileStore just works. :) Oracle wasn't committing updates, so DBIStore wasn't getting a look in. AutoCommit was on, but obviously not effective. I'll be discussing this with our

RE: Session Management

2000-03-30 Thread Philip Plane
Hi, >Does it really create a new record for each update? It should only create a >new record for a new user. So as long as you just testing with on browser, >there should only be one record. I am using one browser for testing. How about this for an idea, the DB is not comitting? Maybe the multi

RE: Session Management

2000-03-30 Thread Gerald Richter
> > I've checked the database, and the cookie info gets written to > the DB. I notice > it creates a new record each time a change occurs. Does it really create a new record for each update? It should only create a new record for a new user. So as long as you just testing with on browser, there s

RE: Session Management

2000-03-30 Thread Philip Plane
Hi, >I don't have much ideas now anymore. Everythings seems to be really good. >The only thing I can imagine, is that you see different session. Are you >really sure that the session id you see in the log is the same for every >page? > >The other possibility may be that the data goes never to the

RE: Session Management

2000-03-30 Thread Gerald Richter
> >That look very good. If the %udat is tied to the right object > and the cookie > >is the same, then I don't see any reason why is shouldn't work. > Have tried > >to print out all elements of %udat? Are there other values in it? > > [9515]SRC: Line 2: [$foreach $blah (keys(%udat)) $] > [9515]CMD