Problems with float

2006-08-14 Thread James Smith
Interesting issue... I am extracting a price from an XML feed for insertion into our local data. The price is returned as a simple float value which I can output to screen just fine. Unfortunately when I insert the info into the database it gets a little messed up. Here are 5 inserted values

Re: Problems with float

2006-08-14 Thread Tom Chiverton
On Monday 14 August 2006 12:00, James Smith wrote: The price is returned as a simple float value which I can output to screen just fine. Unfortunately when I insert the info into the database it gets a little messed up. Are you performing any arithmetic on this value ? -- Tom Chiverton

Re: Problems with float

2006-08-14 Thread Martin Thorpe
I have had problems with floats before, where the calculations were incorrect. Wrapping everything with val(number) or evaluate(number) sorted it all out for me. It was all with calculations that the problems were caused though, returning incorrect numbers. cheers Martin Interesting

RE: Problems with float

2006-08-14 Thread James Smith
No calculations are being done, I am simply grabing the value from an XML feed and then doing an SQL insert into the DB. -- Jay -Original Message- From: Martin Thorpe [mailto:[EMAIL PROTECTED] Sent: 14 August 2006 12:45 To: CF-Talk Subject: Re: Problems with float I have had

RE: Problems with float

2006-08-14 Thread Leon Oosterwijk
Subject: RE: Problems with float No calculations are being done, I am simply grabing the value from an XML feed and then doing an SQL insert into the DB. -- Jay -Original Message- From: Martin Thorpe [mailto:[EMAIL PROTECTED] Sent: 14 August 2006 12:45 To: CF-Talk Subject: Re