Re: stopping numification

[prev] [thread] [next] [Date index for 2005/05/24]

On Tue, May 24, 2005 at 04:46:49PM +0100, Simon Wistow wrote:
> I have a column, version, defined as varchar(255) but, when I do a 
> 
> 	MyThing->find_or_create({ name => $name, version => "$version"});
> 
> where $version is "1.0" then the value in the database is '1'.
> 
> If I do 
> 
> __PACKAGE__->add_trigger( before_set_version => 
> 	sub { my ($self, $value, $vals) = @_; ... } );
> 
> 
> then both $value and $vals->{version} are '1.0';
> 
> If I manually frig the DB to set the version to '1.0' then it's all 
> fine.

Mmm, possibly either CDBI or SQLite is trying something silly at the
quoting stage. DBI->trace(4) may be your friend here, as may be various
evil tricks padding the string or quoting it yourself. YMMV :)

        -- 
             Matt S Trout           Website: http://www.shadowcatsystems.co.uk
  Technical Director        E-mail:  mst (at) shadowcatsystems.co.uk
Shadowcat Systems Ltd.