Re: Database entries into a hash or array

2006-11-16 Thread Mathew Snyder
ember 2006 4:53 PM > To: John W. Krahn > Cc: Perl Beginners > Subject: Re: Database entries into a hash or array > > Ah-hah, of course! Thanks. > > Mathew > > John W. Krahn wrote: >> Mathew Snyder wrote: >>> Figured it out. >>> >>>

RE: Database entries into a hash or array

2006-11-16 Thread Roman
Wouldn't it be better to filter the result with the sql statement? Instead of doing it in perl. -Original Message- From: Mathew Snyder [mailto:[EMAIL PROTECTED] Sent: Thursday, 16 November 2006 4:53 PM To: John W. Krahn Cc: Perl Beginners Subject: Re: Database entries into a ha

Re: Database entries into a hash or array

2006-11-15 Thread Mathew Snyder
Ah-hah, of course! Thanks. Mathew John W. Krahn wrote: > Mathew Snyder wrote: >> Figured it out. >> >> New question though. Here's my code: >> >> #!/usr/bin/perl >> use DBI; >> use strict; >> >> my $dbh = DBI->connect ( "dbi:mysql:dbname=rt3_devel;host=10.0.2.27", >> "svr", "") or die "

Re: Database entries into a hash or array

2006-11-15 Thread John W. Krahn
Mathew Snyder wrote: > Figured it out. > > New question though. Here's my code: > > #!/usr/bin/perl > use DBI; > use strict; > > my $dbh = DBI->connect ( "dbi:mysql:dbname=rt3_devel;host=10.0.2.27", > "svr", "") or die "Cannot connect to database!\n"; > > my $sth = $dbh->prepare("SELEC

Re: Database entries into a hash or array

2006-11-15 Thread Mathew Snyder
Figured it out. New question though. Here's my code: #!/usr/bin/perl use DBI; use strict; my $dbh = DBI->connect ( "dbi:mysql:dbname=rt3_devel;host=10.0.2.27", "svr", "") or die "Cannot connect to database!\n"; my $sth = $dbh->prepare("SELECT DISTINCT Content FROM ObjectCustomFieldValu