Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

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.


Comment on Re^6: SQL::Abstract 'between' clause (about done)
Download Code
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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (14)
As of 2015-07-01 17:34 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 (14 votes), past polls