Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re^6: SQL::Abstract 'between' clause (about done)

by Anonymous Monk
on Nov 22, 2011 at 14:52 UTC ( #939468=note: print w/replies, xml ) Need Help??

in reply to Re^5: SQL::Abstract 'between' clause (about done)
in thread SQL::Abstract 'between' clause (about done)

Thanks but isn't my code doing what your code does?
$where{$colname}{'-between'} = [$from,$to]; #my code where{completion_date}{-not_between}= ['2002-10-01', '2003-02-06'];#yo +ur code
I though $from and $to would work as they contain the right values.

Replies are listed 'Best First'.
Re^7: SQL::Abstract 'between' clause (about done)
by jethro (Monsignor) on Nov 22, 2011 at 19:48 UTC

    I'm not talking about your script. I just answered your implied question "I don't see where I can use this functionality with the two choices you mentioned to pick from" in your last post.

    After looking at your script I see that the problem is that when you call process("DATE1=20111111:20111112"), your script will execute the first 'unless' (which will put a scalar value into $where{DATE1}) and then execute the last 'if' block (which will try to put a reference into $where{DATE1}).

    The problem is evident from your script output (it prints "normal value: 20111111:20111112" and it shouldn't do that, right?). If you had put a few Data::Dumper statements into the subroutine it would have been even more conspicuous.

    So evidently Anonymous Monk was right

      Thank you so much, this clear explanation helped me a lot. Thank you!

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://939468]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2018-06-23 00:53 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (124 votes). Check out past polls.