Re^4: Help on fetchrow

OK, could you give example of that on this code?

my $sth = $dbh->prepare("select * from mytable where user_name = ? ") 
+or
                                                or &die("Can't select:
+ ",$DBI::errstr); 
   $sth->execute($user) die "Execute failed: ", $DBI::errstr;
[download]

How could you redirect any errors here to a special page or a sub routine to print a better error to the users?

Comment on Re^4: Help on fetchrow_hashref! Download Code

Replies are listed 'Best First'.
Re^5: Help on fetchrow_hashref! by Corion (Patriarch) on Nov 09, 2010 at 20:29 UTC
What part exactly do you have problems with? If you don't want to die, don't call that routine.	[reply]
Re^6: Help on fetchrow_hashref! by Anonymous Monk on Nov 09, 2010 at 20:41 UTC
I am just trying to have a way if something goes wrong to redirect to another place instead of having SQL information on the screen when something happens like database not been able to connect or something else.	[reply]
Re^7: Help on fetchrow_hashref! by Corion (Patriarch) on Nov 09, 2010 at 20:48 UTC
If you don't want to print information, don't print it. If you are working within a web framework (which I assume from your passing mention of "redirect"), then learn about how to issue a redirect in your environment. This has little to do with your chosen topic of "Help on fetchrow_hashref", but maybe you want to tell us more about your environment so we can more accurately help you? Again, if you don't want something done, don't do it.	[reply]