On 06/16/2009 03:13:33 PM, Sherrard Burton wrote:
> one of the primary principles of debugging is to break the problem
> down
> into the simplest test case possible that still fails. besides
> helping
> you to better focus in on where the problem might be, you'd be amazed
> how many times you will find your syntactical or logical error when
> stripping away all but what is necessary for failure.
Oh, I hope very much you understand that is exactly what I was trying
to do. I am sure that 80% of the time when I sit down to ask for help
from a forum or mail list, I do solve the problem in the process of
formulating the question, simplifying and developing a test case, etc.
and end up never posting the question. This was one of the other
20%...
I am also painfully aware that my complaint was on the order of "hey, I
just started C programming and look, the C library is broken!"
> %# $m->out("sql: '$sql'<br />\n");
> % $db->do($sql);
>
>
> that way, the first thing that you do when you have a problem is to
> print out exactly what string is being passed.
Okay, I thought simply using the h2 line was enough, but I'll think
about this one.
> also, how are you checking for db errors? i didn't see any of the
> familiar options in your connect statement
>
> % my $db = DBI->connect("DBI:SQLite:$db_file", {
> % RaiseError => 1,
> % PrintError => 0,
> % ShowErrorStatement => 1,
> % } );
>
> nor any active error checking and printing after attempted statement
> execution.
>
> % my $rows = $dbh->do($statement) or die $dbh->errstr;
AFAICT SQLite is sending errors to stderr because they do end up in the
apache log, just in this case there were none.
I'm reading thru the CPAN DBI docs right now. I think I will try and
set up some kind of seperate log using ->trace.
Since I decided to reorganize the comps (for the better, in any case) I
have not been able to reproduce the problem, but I still do not know
why it happened. I can say I did try to narrow this down as much as
possible and check all the strings and return values...oh did I mention
this is my first mason project?? ;)
Sincerly, MK
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Mason-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mason-users
