For some reason, when I run the below query with cfqueryparam, the bit
columns come back empty. If I remove the cfquery param, then the bit columns
have the propery 0/1 value. Any ideas?
<cfquery name="test" datasource="#dsn#">
SELECT `user`.`email_validated` AS `email_validated` FROM `user` AS `user`
WHERE `user`.`user_name` = <cfqueryparam cfsqltype="cf_sql_varchar"
maxlength="20" value="dougarthur" /> AND `user`.`user_pass` = <cfqueryparam
cfsqltype="cf_sql_varchar" maxlength="15" value="test" />
</cfquery>
<cfdump var="#test#" />
query - Top 1 of 1 Rows EMAIL_VALIDATED 1
<cfquery name="test" datasource="#dsn#">
SELECT `user`.`email_validated` AS `email_validated` FROM `user` AS `user`
WHERE `user`.`user_name` = 'dougarthur' AND `user`.`user_pass` = 'test'
</cfquery>
<cfdump var="#test#" />
query - Top 1 of 1 Rows
EMAIL_VALIDATED
1
0
This is happening on CF7, and not my CF8 instance (and not same system). Any
ideas would be greaty appreciated.
Thanks,
Doug
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
