help for connection.mappedResultsQuery with numeric field

[cardosodario]

hi in my table i have two field codigo numeric(11) and nome varchar(35)

select codigo, nome from vendedor where nome like 'A%' limit 2; codigo | nome --------+-------------- 49 | ANGELA 55 | ANA CAROLINA

i am use

List<Map<String, Map<String, dynamic>>> results = await connection.mappedResultsQuery( "select codigo, nome from vendedor where nome like 'A%' order by nome limit 2"); for (final row in results) { print(row["vendedor"]["codigo"]); print(row["vendedor"]["nome"]); }

i receive return

I/flutter (11230): I/flutter (11230): ADELICIA I/flutter (11230): I/flutter (11230): ALDIRA

the field codigo not show because this is numeric

how i resolv this?

thanks

dario

[jcowgar]

I'm running into the same problem as well with numeric fields. I found if I cast them to float in the SQL select, that causes it to work, but that's not correct at all.

[jcowgar]

Actually see #50

[pdqsoftware]

I'm running into the same problem as well with numeric fields. I found if I cast them to float in the SQL select, that causes it to work, but that's not correct at all.

Thanks @jcowgar. Casting to Float is not an ideal solution but it will do me for now. Paul

[andriwsluna]

cast($fieldName as DOUBLE PRECISION) works for me, until solves that issue.