Re^2: Class::DBI error?

Replies are listed 'Best First'.
Re^3: Class::DBI error? by holli (Abbot) on Jun 10, 2005 at 12:26 UTC
Given that $thread is a blessed object your code `for ( $thread ) { my %data2; $data2{author} = $thread->author; $data2{date} = $thread->date; $data2{content} = $thread->content; push @d_body, \%data2; }` [download] is equivalent to `push @d_body, {}; $d_body[-1]->{$_} = $thread->$_ for ("author", "date", "content");` [download] Still I don't see why you need @d_body. I would simply use `my $d_body; $d_body->{$_} = $thread->$_ for ("author", "date", "content");` [download] and later in the code `body=> [$d_body],` [download] holli, /regexed monk/	[reply] [d/l] [select]
Re^4: Class::DBI error? by stonecolddevin (Parson) on Jun 10, 2005 at 12:30 UTC
Ahhh good thinking...wow that was simple meh.	[reply]
Re^3: Class::DBI error? by cbrandtbuffalo (Deacon) on Jun 10, 2005 at 12:06 UTC
If the body is just a single record, you should be able to load that with the same code, just without the loop. I'm guessing the 0's you are seeing are empty arrays in scalar context, which would happen if you got no records back. You might want to put in a quick check after your retrieve to make sure you are getting a record back. If no records are retrieved, $thread will be undef. Actually, you'll want code to catch this anyway and handle it nicely.	[reply]
Re^4: Class::DBI error? by stonecolddevin (Parson) on Jun 10, 2005 at 12:09 UTC
ahhh, so would you recommend wrapping it in `eval{}` and checking `$@`? UPDATE:Murr...should probably just check $thread for emptyness, right? meh.	[reply] [d/l] [select]
Re^5: Class::DBI error? by cbrandtbuffalo (Deacon) on Jun 10, 2005 at 12:14 UTC
No, I think a simple 'if' should do the trick: `if( not $thread){ # Send a message to the user in some way... print"No record found for thread number: $id"; # Get out of the structure in some way... exit; }` [download]	[reply] [d/l]
Re^6: Class::DBI error? by stonecolddevin (Parson) on Jun 10, 2005 at 12:16 UTC
Re^7: Class::DBI error? by cbrandtbuffalo (Deacon) on Jun 10, 2005 at 12:24 UTC