Re: DBD::mysql::st bind_param failed: Illegal parameter number

On Friday, August 10, 2012 at 03:30:16 PM, Seven Reeds wrote:
> Hi
> 
> I am on a RedHat box with perl 5.8.8.  I have just started usinf
> "bind_param" but am having an issue.


Is RedHat still shipping Perl 5.8.8?



>     $tmp = <<EOF;
> SELECT
>     UPPER(eS.machine) AS Machine,
>     UPPER(eS.netID) AS NetID,
>     DATE_FORMAT(eS.date, '%Y/%m/%d %H:%i:%S') AS Start,
>     IF (eE.date IS NULL,
>         '',
>         DATE_FORMAT(eE.date, ''%Y/%m/%d %H:%i:%S')) AS End,
                                                     ^^^^^^
...

> ideas?
> 


Unless I am missing something,  it looks like your SQL is broken.


-r