Respected Monks,

This is very basic stuff to most of you so please accept my apologies.

I have a query in an MSAccess database like so;

group_id    business_unit_name    group_name    sub_group    id    app
+lication_name

282    Corporate Services    CS Helpdesk        3658    Adobe Acrobat 
+Full
282    Corporate Services    CS Helpdesk        4120    Internet Explo
+rer
282    Corporate Services    CS Helpdesk        4197    Lotus Notes
282    Corporate Services    CS Helpdesk        4230    Microsoft Acce
+ss
282    Corporate Services    CS Helpdesk        4291    Netscape Suite
282    Corporate Services    CS Helpdesk        5023    Microsoft Offi
+ce 2003
282    Corporate Services    CS Helpdesk        5026    Falcon
282    Corporate Services    CS Helpdesk        5038    Microsoft Outl
+ook
282    Corporate Services    CS Helpdesk        5054    Placeware Plug
+in
282    Corporate Services    CS Helpdesk        5090    Volo View Expr
+ess
282    Corporate Services    CS Helpdesk        5091    Real Networks 
+Real Player
283    Corporate Services    EMD                    3658    Adobe Acro
+bat Full
283    Corporate Services    EMD                    4120    Internet E
+xplorer
283    Corporate Services    EMD                    4197    Lotus Note
+s
283    Corporate Services    EMD                    4230    Microsoft 
+Access
283    Corporate Services    EMD                    4291    Netscape S
+uite
283    Corporate Services    EMD                    4856    Hummingbir
+d Exceed 8.0 IED
283    Corporate Services    EMD                    5023    Microsoft 
+Office 2003
283    Corporate Services    EMD                    5026    Falcon
283    Corporate Services    EMD                    5038    Microsoft 
+Outlook
283    Corporate Services    EMD                    5054    Placeware 
+Plugin
283    Corporate Services    EMD                    5090    Volo View 
+Express
283    Corporate Services    EMD                    5091    Real Netwo
+rks Real Player
285    Corporate Services    Procurement        3658    Adobe Acrobat 
+Full
285    Corporate Services    Procurement        4120    Internet Explo
+rer
285    Corporate Services    Procurement        4191    Lofmap
285    Corporate Services    Procurement        4230    Microsoft Acce
+ss
[download]

Depending on which group, I need to select their asociated applications; example;

The application list for Procurement should be Adobe Acrobat Full,Internet Explorer,Lofmap and MS Access.

I have this code below, however not sure on how to proceed, or how to print out the OBBCE hash and select certain areas from that query.

use strict;
use warnings 'all';

use Win32;
use Win32::ODBC;

my $dsn = "Hydra_FE";
my $qry = "dbo_vfunction_application";


my $Hydra_db = new Win32::ODBC($dsn) || die "\nError=>\t$^E : $!\n";
print "\nError:  $^E\n" if (! $Hydra_db);

if ( $Hydra_db->Sql("SELECT * FROM $qry"))
{
   print "Cool\n";
   print $Hydra_db;
}
[download]

Thnaks and I am abit snowed on.

Blackadder