Found it - "functions return string=true;" was set in the connection
string. Now to see if the removal of this causes problems elsewhere :)
Barry Zubel wrote:
> I'm having trouble getting the Mysql Data connector to elicit the
> correct type on calculated fields.
> For example, I have an SQL statement that returns a DATEDIFF on two
> columns. Logically, the return type is a SIGNED INT (and I cast it as
> such in the SQL statement)
> However, the Connector insists on returning the column as a STRING
> datatype, which then means that integrated sorting in a DataGrid sorts
> semantically, and not numerically.
> Any idea how I can coerce a particular datatype with the connector?