http://qs321.pair.com?node_id=1099703


in reply to Re: Avoid embedding variables in SQL - Dancer App
in thread Avoid embedding variables in SQL - Dancer App

Thanks for your comments

Reading about this I hope not to be wrong in my conclusion that

---- WHERE products.fk_cat = categories.id_cat AND products.fk_col = collections.id_col AND collections.link_col = ? SQL my $sth = database->prepare($sql); #print Dumper $link; # is okay $sth->execute( $link ); ----
Should be okay.