From: Michael Dykman
Date: July 12 2010 1:20am
Subject: Re: Mysql 4 to 5
List-Archive: http://lists.mysql.com/mysql/222145
Message-Id: <AANLkTikeBm9qr0rpXbj7oNyZTd3YG6pmVVHyOnloz9g2@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

One problem you might be having is the column named 'call'..  It's a
keyword, so perhaps you might get away with backticking it?    ie.
`call`

Also, you shouldn't need that final semi-colon inside your statement
string..  I have had preparedstatement interfaces give me grief about
that.

As I recall, DBI doesn't attempt to validate the statement until execute ti=
me.

 $statemente =3D 'SELECT * FROM notes WHERE call =3D ? ORDER BY id;';
       $sth =3D $dbh->prepare($statemente) or die print "Couldn't
prepare statement:$DBI::errstr; stopped";
       $sth->execute($trackedcall) or die print "Couldn't execute
statement: $DBI::errstr; stopped";

 - md

On Sun, Jul 11, 2010 at 7:50 PM, Grant Peel <gpeel@stripped> wrote:
> Hi all,
>
> I recently migrated a script called perldesk from mysql 4 to mysql 5.
>
> When I envoke the script from the web, I am now getting an error. I suspe=
ct its a version syntax thing.
>
> Here is what I see:
>
> Couldn't execute statement: You have an error in your SQL syntax; check t=
he manual that corresponds to your MySQL server version for the right synta=
x to use near 'call =3D '1307' ORDER BY id' at line 1; stoppedContent-type:=
 text/html
>
>
> =A0 =A0 =A0PerlDesk: Script Error
>
> =A0 =A0 =A0Perldesk was unable to launch due to the following errors:
>
> =A0 =A0 =A01 at include/staff_subs.cgi line 1401.
>
>
> line 1401 is the third line below:
>
>
> =A0 =A0 =A0 =A0$statemente =3D 'SELECT * FROM notes WHERE call =3D ? ORDE=
R BY id;';
> =A0 =A0 =A0 =A0$sth =3D $dbh->prepare($statemente) or die print "Couldn't=
 prepare statement:$DBI::errstr; stopped";
> =A0 =A0 =A0 =A0$sth->execute($trackedcall) or die print "Couldn't execute=
 statement: $DBI::errstr; stopped";
>
> Any help on how to fix this would be appreciated,
>
> -G



--=20
=A0- michael dykman
=A0- mdykman@stripped

=A0May the Source be with you.