- Original Message -
From: "Ronald J Kimball" <[EMAIL PROTECTED]>
To: "'Jonathan Mangin'" <[EMAIL PROTECTED]>;
Sent: Friday, January 06, 2006 12:35 PM
Subject: RE: Can't use mysql's curdate() as bind variable?
> Jonathan Mangin [m
Jonathan Mangin [mailto:[EMAIL PROTECTED] wrote:
>
> curdate() works if $edate is embedded directly in my
> sql statement, but not as a bind variable. $bdate works
> fine.
>
> my $bdate = $q->param('bdate') || '%';
> my $edate = $q->param('edate') || 'curdate()';
>
> my $sql = "create table $tem
curdate() is a function, not a data value.
On 1/6/06 10:18, "Jonathan Mangin" <[EMAIL PROTECTED]> wrote:
> curdate() works if $edate is embedded directly in my
> sql statement, but not as a bind variable. $bdate works
> fine.
>
> my $bdate = $q->param('bdate') || '%';
> my $edate = $q->param('e