Nov 05, 2013; 20:38
Justin Dennis
MySQL Connector field() Auto-Conversion to Lasso Types?
Hi all -
Cross-posted to spread the good word:
http://stackoverflow.com/questions/19802464/mysql-connector-field-auto-conversion-to-lasso-types
In Lasso 8 with MySQL connector, the field() method seemed to always return
a string type, regardless of what data was in the column. The exception
might've been BLOB columns, which might've returned a bytes type. (I don't
recall at the moment.)
In Lasso 9 I see that the field() method returns an integer type for
integer columns. Or so it seems. This is causing some issue with
conditionals where I tested for '1' instead of 1.
Is Lasso really using the MySQL data type, or is Lasso just interpreting
the results?
Is there any documentation as to what column types are cast to what Lasso
data types?
I should test this, but I am curious to see what happens if I issue a -sql
query like "SELECT 123 AS testvalue;" Would testvalue be a Lasso integer
type?
Thanks for your time and assistance.
- Justin
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>