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]
