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

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

by jethro (Monsignor)
on Nov 22, 2011 at 19:48 UTC ( #939527=note: print w/ replies, xml ) Need Help??


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

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


Comment on Re^7: SQL::Abstract 'between' clause (about done)
Replies are listed 'Best First'.
Re^8: SQL::Abstract 'between' clause (about done)
by Anonymous Monk on Nov 23, 2011 at 10:41 UTC
    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://939527]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (13)
As of 2015-07-31 09:39 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 (276 votes), past polls