Robbie Armour [EMAIL PROTECTED] wrote: > 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.
Hold on - I realize I'm being thick here, but what does that prove? The original problem was that 0.4444 ended up coming out of MySQL as 0.44, right? What is the resolution? -- Hardy Merrill Red Hat, Inc. > > 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.
