Guest User

Untitled

a guest
Feb 26th, 2018
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. my $user = '';
  2. my $pass = '.';
  3. my $connection = "dbi:Sybase:server=;database=Adventure";
  4. my $dbh_SQL = DBI->connect($connection, $user, $pass) or die 'Cannot connect';
  5. my $query_cust_main = "
  6. SELECT BusinessEntityID,
  7. Title,
  8. FirstName,
  9. LastName,
  10. Suffix,
  11. JobTitle
  12.  
  13. FROM HumanResources.vEmployee
  14. order by JobTitle";
  15.  
  16. my $query_cust_sth = $dbh_SQL->prepare($query_cust_main);
  17. $query_cust_sth->execute();
  18. my $all_cust = $dbh_SQL->selectall_arrayref($query_cust_main, {Slice => {}});
  19.  
  20. foreach my $data (@$all_cust){
  21. print $data->{BusinessEntityID}." ".$data->{FirstName}." ".$data->{LastName}." ".$data->{JobTitle}."n";
  22. }
Add Comment
Please, Sign In to add comment