develooper Front page | perl.beginners.cgi | Postings from December 2011

Re: problem with passing variables

Thread Previous
From:
nat
Date:
December 30, 2011 10:56
Subject:
Re: problem with passing variables
Message ID:
201112301119.39816.nat@enrgeeman.com
Mark,
	I'm kind of new with perl, but from what I see, you're using a single 
quote when defining $sql, and it should be qq for the interpolated string.  
With the single quote (q) it is a literal.   Hope this helps.


On Friday, December 30, 2011 11:17:30 AM Mark Haney wrote:
> I'm not sure if this is the right list for this, so bear with me.  If it
> isn't I'll be glad to post it on the correct one.
> 
> I've got a problem with passing variables to a SQL server inside a CGI
> script.  My code is like this:
> 
> my $begin_time = "2011-11-16 11:00:00";
> my $end_time = "2011-11-16 12:00:00";
> 
> my $dbh = DBI->connect('dbi:mysql:database=embdev', 'user', 'password');
> 
> my $sql = q/SELECT * FROM events WHERE date BETWEEN $begin_time and
> $end_time/;
> 
> my $sth = $dbh->prepare($sql);
> $sth->execute();
> 
> I'm not sure why it's not using the the variables, can someone point out
> what I'm doing wrong?
> 
> -----
> Mark Haney

-- 
nat
enrgeeman.com

Thread Previous


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About