Alright This is rank! Is this because of the JDBC driver or because of the ValueList() function?
If a column is of BIT type, and I do a ValueList() on that column, the function returns true and false for the repective values. Now, if the column is an INT type, the function returns 1 or 0 for the respective values. In my query, if i do CONVERT(INT,Active) on the BIT column, the ValueList() funtion returns 1 or 0 for the respective values. Whos fault is this? JDBC or ValueList? Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Steve Onnis Sent: Thursday, 3 July 2003 10:47 PM To: CFAussie Mailing List Subject: [cfaussie] Value list - WTF! Ok, am I going bonkers or not. MSSQL database with a bit column and default to 1. Query database and dump results, column returns the value of 1. There are 3 records. If i output the valuelist, ValueList(Queryname.Columnname) it returns false,false,true rather than 0,0,1. Whats the go with that? CFMX UD3 on WIN2K Steve --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
