I was going to do the same - I think I will also...this is worrying as value
in the database is 0 or 1 and NOT "true" or "false" (note the use of
quotes). Yes you can argue that 0 and 1 is true and false but the data held
in the DB states 0 and 1 explicitly and it should stay that way.
N
_____
From: alexander sicular [mailto:[EMAIL PROTECTED]
Sent: 11 June 2004 14:11
To: CF-Talk
Subject: Re: ValueList() Error
I have also just come across this problem only yesterday. I was using
valuelist inside a listfind like so :
listfind(valuelist(query.booleancolumn),1)
I had to change 1 to true to get it to work as expected. This only happens
with bit column from mssql2k. when dumping the query that contains the
boolean field it dumps as 0 / 1. Seems a problem with the valuelist
function. Very unsettling to say the least. Filed a bug report with mm via
their website. Lets see what happens...
gl,
alex
>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
>
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
