[jifty-devel] Database Help

[Wolfgang Kinkeldei]

Hallo,

On 29.09.2006 um 01:17 Scott T. Hildreth wrote:

> I was testing the Jifty::DBI examples,
>
> ############################################################
>
> use strict;
> use warnings;
>
> use Jifty::DBI::Handle;
> use TestTable;

[...]

> when the the load_by_cols executes I get the Oracle error,
>
>    ORA-00942: table or view does not exist
>
> couldn't execute the query 'SELECT  * FROM testtables WHERE qnum = ?'

The table name is guessed from the last part of the Model's class  
name by building a plural of the last part. This is done in  
Jifty::DBI::Record by the sub "_guess_table_name".

Jifty::Manual::Cookbook suggests to build a sub "_guess_table_name"  
in YourApp::Record (or in YourApp::TestTable to let this just work  
for this class) to override the default behaviour.


Regards,

Wolfgang Kinkeldei

-- 

' /\_/\ ' .print[split??,"".(($/=q|Cms)+-03467:;<=|)=~tr!C-z -B! -z!)x
'( o.o )' .$/]->[hex]foreach split qr<>,qq+1ecd039ad65b025b8063475b+||
' > ^ < ' .q<!-- Wolfgang Kinkeldei - mailto:wolfgang at kinkeldei.de -->