It is possible with some databases to have permission to INSERT and UPDATE but not SELECT.

It would help us diagnose the problem if you'd show some code that's giving you the problem.

Thanks! Here is the code in question.

$rowCheckQuery = qq{SELECT color_id FROM color WHERE color=?};
              foreach my $color (@color){

                      # trim whitespace
                      $color =~ s/^\s+|\s+$//gm;
                      # print "Color is - ", $color, " -\n\n";

                      my $sth = $dbh->prepare($rowCheckQuery);
                      $sth->execute($color);

                      while(my $color_test = $sth->fetchrow_arrayref) 
+{
                              push @color_test, $color_test;
                      }

              }
[download]

Also I double checked the user I am using for the script and it has global select permissions. I can select on other tables in the same db.... just very oddly not two of my tables. This might be more of a mysql issue. I'm not sure.

Thanks again.

And what behavior do you see from this?

Note that fetchrow_arrayref always returns the same array reference (see the DBI documentation). That means if you want to store all the rows (as you appear to be attempting), you have to copy the array.

while(my $color_test = $sth->fetchrow_arrayref) {
    push @color_test, [ @{$color_test} ];
}
[download]

In addition to comments already made, you also want to prepare your statement outside of the loop. You are effectively negating the performance benefit of running the prepare command.

--MidLifeXis

Thanks all,

I posted the solution last night but it's worth reposting.

After some reading on the mysql boards I realized several people were having the same issue. All were using active perl and all were using the mysqlPP driver. I switched to using the mysql driver and the issue vanished.

Thanks again!