Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
I have a bit of code that uses the Mysql module. It is complaining on:
The error returned is:my $query = "SELECT field1,field2 FROM my_table WHERE LEFT(field3) = ' +$var'";
DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lib/perl5/site_perl/5.6.1/i386-linux/Mysql.pm line 172.
If I remove the where clause, the error disappears.edited: Sun Mar 9 14:40:39 2003 by jeffa - code tags
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Mysql module
by pfaut (Priest) on Mar 07, 2003 at 01:00 UTC | |
Re: Mysql module
by Heidegger (Hermit) on Mar 07, 2003 at 06:59 UTC | |
Re: Mysql module
by Cabrion (Friar) on Mar 07, 2003 at 01:58 UTC | |
Re: Mysql module
by Jazz (Curate) on Mar 07, 2003 at 02:26 UTC | |
by Cabrion (Friar) on Mar 07, 2003 at 02:32 UTC | |
by pfaut (Priest) on Mar 07, 2003 at 02:52 UTC | |
Re: Mysql module
by Anonymous Monk on Mar 07, 2003 at 16:27 UTC | |
by Cabrion (Friar) on Mar 12, 2003 at 12:03 UTC | |
Re: Mysql module
by Tomte (Priest) on Mar 12, 2003 at 12:12 UTC |
Back to
Seekers of Perl Wisdom