Is each server using the same database? - as it could be because one database is returning 1/0 and the other true/false for bit fields AFAIK (and I could well be wrong!) the valuelist() function just takes whatever is in the column and it doesn't try and interpret the column types.
If both servers are calling on the same database that kinda blows my theory!! - but you could just get around the problem by using "if columnvalue" instead of "if columnvalue EQ 1" HTH Alex -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 10 March 2005 12:38 To: CF-Talk Subject: Wierd ValueList() Issue OK, I have a query which is bringing back a column containing BIT values. On one server when I perform a ValueList() on the column to evaluate its value to the actual (1,0) value it will work fine but on another the same function and same query will not work as ValueList() seems to be converting the 1 and 0s into the words TRUE and FALSE. i.e. this pseudo works on one server but not other: if columnvalue EQ 1 as the offending server is treating columnvalue a TRUE even though the query contains 1? It really doesn't make sense. Any ideas? Both servers are running the same version of CF / Patches and the same JVM. N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198170 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
