Re^2: Using DBI to make connection to a database


good chemistry is complicated, and a little bit messy -LW
	PerlMonks

Re^2: Using DBI to make connection to a database

by Tux (Canon)

on Jul 03, 2015 at 11:51 UTC ( [id://1133076]=note: print w/replies, xml )

Need Help??

in reply to Re: Using DBI to make connection to a database
in thread Using DBI to make connection to a database

That is bad advice!

Please do not create SQL statements with fixed strings and do (remember bobby?)

I agree with the wrong quotes being used (of course). Shell quotes are not perl quotes on Windows at least.

If you want to see the statement used when something fails, use the appropriate means:

my $dbh = DBI->connect ("dbi:Pg:", $user, $pass, {
    RaiseError         => 1,
    PrintError         => 1,
    ShowErrorStatement => 1,
    }) or die $DBI::errstr;

my $sth = $dbh->prepare ("select foo from bar where boom = ?");
$sth->execute (1);
[download]

Enjoy, Have FUN! H.Merijn

Comment on Re^2: Using DBI to make connection to a database Select or Download Code

Replies are listed 'Best First'.

Re^3: Using DBI to make connection to a database
by soonix (Canon) on Jul 03, 2015 at 12:14 UTC

I did not intend to advise creating SQL with fixed strings if you have variable parts. This was just an example (and didn't contain any variables in the SQL).

q(SELECT ConfigValue FROM ConfigTable WHERE ConfigKey = 'ScreenWidth')

Plus in the "I prefer" part I used prepare anyway…

Update:

$dbh->do("SELECT ...

per se

SELECT COUNT(*) ...

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom