Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

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

by sam_bakki (Pilgrim)
on Jul 13, 2013 at 12:49 UTC ( #1044147=note: print w/ replies, xml ) Need Help??


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

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 :)



Thanks & Regards,
Bakkiaraj M
My Perl Gtk2 technology demo project - http://code.google.com/p/saaral-soft-search-spider/ , contributions are welcome.


Comment on Re^2: Need help in Perl DBI (SQLite) execute behaviour
Download Code
Replies are listed 'Best First'.
Re^3: Need help in Perl DBI (SQLite) execute behaviour
by poj (Priest) on Jul 13, 2013 at 15:42 UTC
    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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1044147]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (12)
As of 2015-07-31 07:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (275 votes), past polls