Small syntax problemo

[bluegroper]

This works

$dbh=DBI->connect("dbi:Pg:dbname=$dataset;host=127.0.0.1;", "$username", "$password") or die $DBI::errstr;

This DOESN’T work

$temp=qq|"dbi:Pg:dbname=$dataset;host=127.0.0.1;", "$username", "$password"|;
$dbh=DBI->connect($temp) or die $DBI::errstr;

Can anybody tell me where my syntax mistake is ?
TIA's
BG

 

[mbrooks]

You are passing a $temp to a function that expects three seperate arguments.

connect( "dsn", "user", "pass" )

M. Brooks

http://mbrooks.info

 

[Kirsle]

To do it the way you were, try this:

@temp = qw|dbi:Pg:dbname=$dataset;host=127.0.0.1; $username $password|;
$dbh = DBI->connect (@temp) or die $DBI::errstr;

(with qw~~, separate array items by spaces, and they don't need quotes around the items, otherwise you can make a normal array

@temp = (
   "dbi:Pg:dbname=$dataset;host=127.0.0.1;",
   "$username",
   "$password");

 

[bluegroper]

Thx to you guys, I now understand my mistake/s.

- BG