Re: Rounding errors storing numbers in MySQL text fields using DBI

[Robbie Armour]

That's it!  - 0.4444 then '0.4444'  fails whereas '0.4444', 0.4444 works.  I 
shall put something in my code to circumvent this.

Thanks for all your help with this.

Robbie

Once a placeholder has been tagged with a type (number in this case),
the type is remembered for the life of the statement.  As a result
'0.3333' is pasted into the SQL as if it is a number.
To test my theory, please try the following sequences in separate
runs:
  # Run 1
  $qst -> execute( "xyz" );
  $qst -> execute( 0.4444 );
  $qst -> execute( 0.3333 );
  # Run 2
  $qst->execute( '0.4444' );
  $qst->execute( 0.3333 );
--
Mac :})
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
_________________________________________________________________
Stay in touch with absent friends - get MSN Messenger 
http://www.msn.co.uk/messenger