using queryNew() and querySetCell() functions.
In MX, it returned 0,1,0,0,0,1
----- Original Message -----
From: "Dave Phillips" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 10, 2004 12:31 PM
Subject: RE: ValueList() Error
> Steve,
>
> Theoretically, it would just add quotes around the true, false, etc.
> like this:
>
> 'True','False','False','False','True','True'
>
> However, I tested this on a BIT field in a database, and I actually
> found ValueList() returning 0's and 1's, not False's and True's. Maybe
> it depends on the type of Database you are using (I'm using SQL Server).
> What database server are you using? Any thoughts from anyone else out
> there?
>
> Dave
>
> ________________________________
>
> From: Semrau Steven Ctr SAF/IE [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 10, 2004 1:38 PM
> To: CF-Talk
> Subject: RE: ValueList() Error
>
>
> What happens if you use quotedValueList(rsExhibitorSettings.BDISPLAY)
>
> -----Original Message-----
> From: Robertson-Ravo, Neil (RX)
> [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 10, 2004 1: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
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
