Yes this the strangest thing, I am on SQL Server 2000 and its happening on 4
out of 5 servers - the settings on all are the same?!
N
_____
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: 10 June 2004 20:32
To: CF-Talk
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]
