X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSchema%2FLoader%2FDBI.pm;h=e242655a2a392c4c3b6e408c29b74744f80e591b;hb=3bad938aefd5c8724b3a4c54f6d42f4e877bb001;hp=baf137292cb01ad970f39d95a32db306234ae7a1;hpb=eea428f2924e07c7103fa01a31a3b8e1ebc15401;p=dbsrgits%2FDBIx-Class-Schema-Loader.git diff --git a/lib/DBIx/Class/Schema/Loader/DBI.pm b/lib/DBIx/Class/Schema/Loader/DBI.pm index baf1372..e242655 100644 --- a/lib/DBIx/Class/Schema/Loader/DBI.pm +++ b/lib/DBIx/Class/Schema/Loader/DBI.pm @@ -326,10 +326,10 @@ sub _table_comment { my $comments_table = $self->table_comments_table; - my ($comment) = try { $self->dbh->selectrow_array(<<"EOF", {}, $table->name) }; + my ($comment) = try { $self->dbh->selectrow_array(<<"EOF") }; SELECT comment_text FROM $comments_table -WHERE table_name = ? +WHERE table_name = @{[ $self->dbh->quote($table->name) ]} EOF return $comment; @@ -340,11 +340,11 @@ sub _column_comment { my $comments_table = $self->column_comments_table; - my ($comment) = try { $self->dbh->selectrow_array(<<"EOF", {}, $table->name, $column_name) }; + my ($comment) = try { $self->dbh->selectrow_array(<<"EOF") }; SELECT comment_text FROM $comments_table -WHERE table_name = ? -AND column_name = ? +WHERE table_name = @{[ $self->dbh->quote($table->name) ]} +AND column_name = @{[ $self->dbh->quote($column_name) ]} EOF return $comment;