<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div><br>I would use more $DBI::errstr after a prepare, an execute or a connect. Something like<br><br><br>$dbh = DBI->connect( $NZ_SOURCE , $NZ_USER , $NZ_PASSWORD ) or die $log->abort(<br>$connect_error_message . $DBI::errstr );<br><br>other than that is a very comfortable approach, even if I prefere to keep queries in separate .sql files under a sql directory so other people that don't know Perl can edit them ( after that they accept the '?' special character :)<br><br>Bye,<br><br>see you the next meeting<br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">Da:</span></b> marcos rebelo
<oleber@gmail.com><br><b><span style="font-weight: bold;">A:</span></b> milan-pm@pm.org; nl-pm@amsterdam.pm.org; perl-recipes@googlegroups.com; perl@lisbon.pm.org; Perl Begginers <beginners@perl.org><br><b><span style="font-weight: bold;">Inviato:</span></b> Mar 5 ottobre 2010, 14:11:01<br><b><span style="font-weight: bold;">Oggetto:</span></b> [Milan-pm] New note on page5notebook<br></font><br>Hi all<br><br>I did one more note at:<br><br><a href="http://perl5notebook.oleber.com/objects/smart-selects-with-dynamic-response-to-undefiend-method-calls" target="_blank">http://perl5notebook.oleber.com/objects/smart-selects-with-dynamic-response-to-undefiend-method-calls</a><br><br>One example of the use of AUTOLOAD, to do some SQL dinamically.<br><br>Comments are well come<br><br>Best Regards<br>Marcos Rebelo<br><br>-- <br>Marcos Rebelo<br><a href="http://oleber.freehostia.com" target="_blank">http://oleber.freehostia.com</a><br>Milan Perl Mongers
leader <a href="http://milan.pm.org" target="_blank">http://milan.pm.org</a><br>Webmaster of <a href="http://perl5notebook.oleber.com" target="_blank">http://perl5notebook.oleber.com</a><br>_______________________________________________<br>Milan-pm mailing list<br><a ymailto="mailto:Milan-pm@pm.org" href="mailto:Milan-pm@pm.org">Milan-pm@pm.org</a><br><a href="http://mail.pm.org/mailman/listinfo/milan-pm" target="_blank">http://mail.pm.org/mailman/listinfo/milan-pm</a><br></div></div>
</div><br>
</body></html>