in reply to Re^4: DBI and JSON fields
in thread DBI and JSON fields
Separate your query from your call. See Re^3: DBI and JSON fields.
I'll replicate here because it will translate into a much better example:
my $thing_query = qq{ SELECT * FROM table WHERE idTable = ? AND some_column = ? AND another_column = ? AND name = ? };
Then:
my @ary = $dbh->selectrow_array( $thing_query, undef, $table_id, $column_data, $column_info, $name );
See how you can look at the query and immediately line up the parameters to the selectrow_array() call with the supplied list of params?
|
|---|