Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: MySQL Placeholder Date Problem

by runrig (Abbot)
on Nov 25, 2003 at 21:53 UTC ( [id://310072]=note: print w/replies, xml ) Need Help??


in reply to MySQL Placeholder Date Problem

You already have your answer (although we don't yet know what it was), but you can reduce your logic by doing something like this:
my @args = ($SearchPhrase); ... if ($begMonth) { ... $SQL .= " AND syslog_timestamp BETWEEN ? AND ?"; push @args, $begDate, $endDate; } ... $sth->execute(@args);

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (8)
As of 2024-03-28 17:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found