I have a dbi statement handle:
my $confidence_query = $dbh->prepare("select confidence_str from $tabl
+e where probeset_id = ?");
When I set the value of $table and execute the query:
I get an error:
DBD::mysql::st execute failed: You have an error in your SQL syntax; c
+heck the manual that corresponds to your MySQL server version for the
+ right syntax to use near 'where probeset_id='SNP_1')
Are you allowed to have a table name as a variable? Is there a way of working around this? Thanks for your help.
ah, yes. I needed to set table prior to the prepare statement.
20071026 Janitored by Corion: Changed PRE to code tags, as per Writeup Formatting Tips