Old 06-24-2014, 07:06 PM   #1 (permalink)
Status: Junior Member
Posts: 3

Default sql is converting int to float on select

I'm using PERL to write a program, and I need to select an ID from a table. The query is selecting the ID column, which is an int, but then the value is #.00. I am trying to insert that ID into another table as the foreign key which has an int datatype. Does anyone know why this is happening?

newbeardieowner is offline   Reply With Quote



Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a class FLOAT that contains two float data members.? DeepaliC Programming 0 07-04-2013 03:06 PM
converting a char* into a float? Achool Coding 1 05-26-2013 02:00 PM
error: invalid operands of types 'float' and 'float' to binary 'operator%'? pavan Coding 0 02-21-2013 11:06 AM
how to select a highest float value from mysql with active record class codeigniter kiter1Id4 Databases 0 09-24-2011 01:11 AM
error message two few arguments to function void f(float*,float*) Whisfiefovive Programming 1 09-02-2011 03:10 AM