search

davibe / Phonegap-SQLitePlugin

A phonegap plugin to open and use sqlite databases on iOS.
191 stars 90 forks source link

Float numbers not returning with select statement #9

Open padzilla opened 12 years ago

padzilla commented 12 years ago

I have a float type of column that was only returning the integer portion of the value stored in my DB. I had to change this in PGSQLitePlugin.m: case SQLITE_FLOAT: columnValue = [NSNumber numberWithFloat: sqlite3_column_int(statement, i)]; columnName = [NSString stringWithFormat:@"%s", sqlite3_column_name(statement, i)]; [entry setObject:columnValue forKey:columnName];
break; to this to get the float: case SQLITE_FLOAT: columnValue = [NSNumber numberWithFloat: sqlite3_column_double(statement, i)]; columnName = [NSString stringWithFormat:@"%s", sqlite3_column_name(statement, i)]; [entry setObject:columnValue forKey:columnName];
break;

davibe commented 12 years ago

Great !! If you send a pull request i will merge it as soon as i get home.

Davide Bertola (from iPhone)

Il giorno 04/mar/2012, alle ore 03:52, padzilla reply@reply.github.com ha scritto:

I have a float type of column that was only returning the integer portion of the value stored in my DB. I had to change this in PGSQLitePlugin.m: case SQLITE_FLOAT: columnValue = [NSNumber numberWithFloat: sqlite3_column_int(statement, i)]; columnName = [NSString stringWithFormat:@"%s", sqlite3_column_name(statement, i)]; [entry setObject:columnValue forKey:columnName]; break; to this to get the float: case SQLITE_FLOAT: columnValue = [NSNumber numberWithFloat: sqlite3_column_double(statement, i)]; columnName = [NSString stringWithFormat:@"%s", sqlite3_column_name(statement, i)]; [entry setObject:columnValue forKey:columnName]; break;

Reply to this email directly or view it on GitHub: https://github.com/davibe/Phonegap-SQLitePlugin/issues/9