Select Code to Download

Select or download this

$sessionid = $logquery->fetchrow_array;
$sessionid = '0' if not defined $sessionid;
$sessionid++;

Select or download this

#!/usr/bin/perl
# timeline.pl
...
undef $sessionid;
undef $timeid;
undef $logquery;

Select or download this

D:\timeline>timeline.pl
8 2001-05-10 10:32:55.280

...

D:\timeline>timeline.pl
10 2001-05-10 10:33:00.867

Select or download this

 
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL 
+Server]Vio
lation of PRIMARY KEY constraint 'pk_session'. Cannot insert duplicate
+ key in ob
...
sessions'. (SQL-23000)
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been 
+terminated
. (SQL-01000)(DBD: st_execute/SQLExecute err=-1)

Select or download this

create table sessions (
session_id    varchar (10),
session_date    datetime,
file_archive    varchar (25),
constraint pk_session primary key (session_id))