I have a problem with one of the field types set up in my Database and
wondered if anyone can help me to define it within my model properly.
The error I get is as follows:
Caught exception in ReCharge::Controller::Contracts->url_create
"DBIx::Class::ResultSet::create(): Error executing 'INSERT INTO
contracts (amount, contract, end_date, start_date) VALUES ('1000',
'Test', '12/31/07 23:59:59', '01/01/07 00:00:00')': Server message
number=257 severity=16 state=1 line=1 server=DBSERVER text=Implicit
conversion from datatype 'VARCHAR' to 'MONEY' is not allowed. Use the
CONVERT function to run this query."
The database is Sybase and this field is of type "MONEY" (as you can
see), I think just inserting as a normal integer (i.e. without the
quotes in the SQL) is all that is required.
I have searched all over for information on how to specify the data
type, but have found it quite confusing!
Thanks in advance for any assistance,
Jonathan.
_______________________________________________
List: [email protected]
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
