Re: Need help in Perl DBI (SQLite) execute behaviour

[poj]

Try

$stHandle = $dbHandle->prepare( 
qq{ DELETE FROM TB_SESSIONS 
    WHERE (TB_SESSIONS.creationTime + ? ) < 
    CAST(? AS INTEGER) } );

poj

[sam_bakki]

Hi poj

Great. This works as expected. From DBI doc, I understand that DBI will do the type conversion for me from scalar automatically. Looks like in this case I need to do it manually. But why only for RHS? because LHS is doing addition, so it is converted to INTEGER automatically?

Thanks :)

[poj]

Is your database field creationTime type INTEGER ?.


You might find this statement works

DELETE FROM session WHERE creationTime < ?

if you make the parameter

(time() - SESSION_MAX_LIFE_TIME)

which I think is easier to understand

poj

[sam_bakki]

Hi poj

Thanks. Good Suggestion, I will take it. :)