in reply to Re: Updating a new column entry for CGI::Session 'sessions' table
in thread Updating a new column entry for CGI::Session 'sessions' table

The $user_id is verified to be a real value and not NULL. I even tried hard-coding in my code:

$sth = $dbh->do ("UPDATE sessions SET user_id='20' WHERE id='$CGISESSID'");

Still I got the same results

  • Comment on Re: Re: Updating a new column entry for CGI::Session 'sessions' table
  • Download Code

Replies are listed 'Best First'.
Re: Re: Re: Updating a new column entry for CGI::Session 'sessions' table
by EvdB (Deacon) on Mar 25, 2004 at 14:17 UTC
    I was refering to the value that is in user_id in the database when you try to update it, not the value you are trying to insert.

    --tidiness is the memory loss of environmental mnemonics

[reply]
[d/l]
      The column was defined as NOT NULL and the default was set to 0.
[reply]

In Section Seekers of Perl Wisdom