Re: strange problem with Class::DBI

2005-08-15 Thread Alex Deucher
On 8/12/05, Tim Bunce [EMAIL PROTECTED] wrote: Google says http://qs321.pair.com/~monkads/index.pl?node_id=354212 Thanks for the pointer, however, for those that run into this in the future, the problem was that I hadn't passed: RootClass = 'DBIx::ContextualFetch' in my connect methods.

Re: strange problem with Class::DBI

2005-08-12 Thread Tim Bunce
Google says http://qs321.pair.com/~monkads/index.pl?node_id=354212 Tim. On Fri, Aug 12, 2005 at 03:25:28PM -0400, Alex Deucher wrote: I'm having problems using Class::DBI to access my database. I have a postgres database with several tables and I've implemented Class::DBI abstractions for

Re: Strange problem with

2002-10-22 Thread George Mayne
In the while statement you're missing the $website between $email2 $available_hours1. Hope this helps. George Mayne [EMAIL PROTECTED] *** REPLY SEPARATOR *** On 10/21/2002 at 8:59 PM Brad Smith wrote: Using an access database with DBI and DBD-ODBC, I am having the strangest

Re: Strange problem with

2002-10-22 Thread Michael A Chase
On Tue, 22 Oct 2002 07:50:06 -0500 George Mayne [EMAIL PROTECTED] wrote: In the while statement you're missing the $website between $email2 $available_hours1. With as many columns as you have, it would be easier and _much_ more efficient to retreive the values with $sth-bind_columns(). It

RE: Strange problem with

2002-10-21 Thread Jay Hannah
Ouch. Try this instead: my %hash_ref; while ($hash_ref = $sth-fetchrow_hashref) { print available_hours1: $$hash_ref{'available_hours1'}\n; print available_hours2: $$hash_ref{'available_hours2'}\n; print available_hours3: $$hash_ref{'available_hours3'}\n; } That should help you find

RE: Strange problem with

2002-10-21 Thread Jeff Urlwin
You forgot website in your retrieval array. Suggestion: use fetchrow_hashref, it will make this much easier to read and maintain... Regards, Jeff Using an access database with DBI and DBD-ODBC, I am having the strangest problem, and I can't seem to solve it. The table has three fields,