I am getting an error when using <cfqueryparam> and MySQL 4.0.13. Whenever I specify the <cfqueryparam> type to CF_SQL_BIT I get the following error:
Unknown Types value The value I am passing is just 1, and it is hard-coded. If I change the type to CF_SQL_INTEGER it works just fine. Interestingly, this works fine on CF5, but gives the above error when using CFMX. Again, this only happens on MySQL and not on any other db platform. I'm not sure if it specific to the MySQL version mentioned above or what. Has anyone seen this error before? I guess my workaround is just to specify CF_SQL_INTEGER or CF_SQL_NUMERIC, but that is sort of a lame workaround. Any ideas? Cedric ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
