Since it is a BIT data field, the values of the field are either True or
False, represented by a 1 or 0 respectively. If you truly want 1's or
0's returned, then change your datatype to int and that should do it.
However, if you want to keep the datatype BIT then you could do the
following routine:
<CFSET NewValueList =
replacenocase(rsExhibitorSettings.BDISPLAY,"false","0","all")>
<CFSET NewValueList =
replacenocase(rsExhibitorSettings.BDISPLAY,"true","1","all")>
or more combined:
<CFSET NewValueList =
replacenocase(replacenocase(rsExhibitorSettings.BDISPLAY,"false","0","al
l"),"true","1","all") >
HTH.
Sincerely,
Dave Phillips
National Marketing Director
Legacy for Life
615-746-3851
[EMAIL PROTECTED]
________________________________
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 12:14 PM
To: CF-Talk
Subject: ValueList() Error
OK,
We have a very strange issue with a resultset....we have the following
coming back from the DB...
bDisplay (Column Name)
0
1
0
0
0
1
As you can see the data in the column is simple 1s and zeros (bit
Datatype)......now for the problem :
If I use valuelist(rsExhibitorSettings.BDISPLAY) the values coming out
are
as follows
False, true, false, false, false, true....!??!?!
Now what the heck is up with that?!!?!?
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
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
