ValueList() Error

Can I change the background of the blog?

Hello Guest

• Login
• Register…
• Start blog

• Who, Where, When
• What can I do?
• What to Read?

• Polls
• Avatars
• Interests

• Cities and Countries
• Random blog
• Users search

• Search
• Games
• Tests
• QAIX

• Сообщества
• Talxy Chat
• Horoscope
• Online

Зарегистрируйся!

QAIX > ColdFusion > ValueList() Error 11 June 2004 16:32:48

Recent blog posts:

PS3 firmware update adds full…
Eric Lempel, Sony's Director of PlayStation Network Operations, has posted on the official PlayStation 3…

Nintendo makes $6 profit on…
According to Macquarie Securities analyst David Gibson, Nintendo makes $6 USD operating profit on each…

Maintenance in winter
Skin for winter very easy to do, if does not supplement the moisture in time, like persimmons, flat and…

'Jasper' Xbox 360s finally…
'Jasper' Xbox 360s finally available According to a flooding of posts over at xbox-scene, it appears…

How to transfer Napster music…
Music purchased from Napster is under DRM protection, which stops customers from playing the downloaded…

The song my brother taught me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother taught me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

Blackfriday&Cybermonday…
:-D Today is Thanks giving; Blackfriday&Cybermonday is very close to us now. And…

Harvest your surprise on…
Harvest your surprise on Thanksgiving Day – more discount at Nidesoft…

They have birthday today:

xiongchong

henna diah

все >>

Forums:

topic feeds

• QAIX all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous

Discuss:

cfhttp method="PUT"
Has anyone used this? I'm looking for an example of how to use CFHTTP's PUT method. There are none in…

RE: TinyMCE
Change the font-size in the css file you are using (default, advanced or simple) for the body style…

Test....test... Quiet today...
Hello... Testing.. -- Yves Arsenault "This year, or this month, or, more likely, this very day…

Browser Session spawn
Application: An application where you can administer a number of companies and their users. The…

April Fool's
http://en.wikipedia.org/wiki/April_1%2C_2005 Cheers, Erika…

Recent forum topics:

Support for ensuring invariants…
Hi all, I occasionally find myself annoyed at having to do something like this (I use Perl5 vernacular…

how to write literals of some…
Hello, I'm wondering how to write anonymous value literals of some Perl 6 basic types, and I didn't…

Protecting a mod perl 1.3 site…
Hello, I am working on a site that has a modperl (mod_perl 1.3, perl 5.8) handler doing some…

Recent forum comments:

RE: Mod_Rewrite install
it simply rocks, and given solution actually works for me.

RE: How to efficiently get a random…
"Laphan" <please@dont.spam.com> wrote in message…

RE: How to efficiently get a random…
On 21 Sep, 11:48, "Laphan" <ple...@dont.spam.com> wrote: Ask this over on…

RE: How to efficiently get a random…
Laphan wrote: I have nothing to add to this: http://www.aspfaq.com/show.asp?id=2132…

RE: How to use Multiple database…
On Sep 10, 2:41am, balakrishnan.din...@gmail.com wrote: Perhaps try something like this: Dim…

RE: how to write literals of some…
On 2008-Dec-3, at 10:18 am, TSa wrote: That's what I would expect. A reasonable default would be for…

RE: how to write literals of some…
HaloO, Darren Duncan wrote: First I have a question to the example of the behavior of a string in a…

RE: how to write literals of some…
TSa wrote: I like that approach. Go the same way as Bool and Order value literals. Don't know why I…

RE: how to write literals of some…
HaloO, mark.a.biggar@comcast.net wrote: I doubt that this works. I assume that there are…

RE: how to write literals of some…
HaloO, Darren Duncan wrote: Here we could get away with defining two new enums, e.g. Bit::High and…

Moderators:

Administrator
Protorioris


ValueList() Error
Neil Robertson-Ravo 11 June 2004 16:32:48
	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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:166163 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
		Add comment


Dave Phillips 10 June 2004 21:30:43 [ permanent link ]
	Neil, 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 Dave-gdPYa5BjR4uHqm2bo9WLigC/G2K4zDHf@public.gmane.org ________________________________ From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson-Ravo-OVe770fkhX4xS3q+KiyLeA@public.gmane.org] 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 ________________________________ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:166186 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
		Add comment


Semrau Steven Ctr SAF/IE 10 June 2004 21:37:32 [ permanent link ]
	What happens if you use quotedValueList(rsExhibitorSettings.BDISPLAY) -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson-Ravo-OVe770fkhX4xS3q+KiyLeA@public.gmane.org] 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 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 _____ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:166188 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
		Add comment


Dave Phillips 10 June 2004 22:31:41 [ permanent link ]
	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:Steven.Semrau-ccvjzJVizCxb/TDb+2HEFA@public.gmane.org] 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:Neil.Robertson-Ravo-OVe770fkhX4xS3q+KiyLeA@public.gmane.org] 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:166206 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
		Add comment


Charlie Griefer 10 June 2004 22:45:50 [ permanent link ]
	I tried it (too lazy to use an actual database so i set up the query results using queryNew() and querySetCell() functions. In MX, it returned 0,1,0,0,0,1 ----- Original Message ----- From: "Dave Phillips" <dave-AwLEnFgSn8eHqm2bo9WLigC/G2K4zDHf@public.gmane.org> To: "CF-Talk" <cf-talk-2K/2x8RPSj9p9z4BATjFtQC/G2K4zDHf@public.gmane.org> 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:Steven.Semrau-ccvjzJVizCxb/TDb+2HEFA@public.gmane.org]> 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:Neil.Robertson-Ravo-OVe770fkhX4xS3q+KiyLeA@public.gmane.org]> 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)> 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?!!?!?> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:166214 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
		Add comment


Neil Robertson-Ravo 11 June 2004 11:46:05 [ permanent link ]
	Hi Dave, 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:dave-AwLEnFgSn8eHqm2bo9WLigC/G2K4zDHf@public.gmane.org] 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:Steven.Semrau-ccvjzJVizCxb/TDb+2HEFA@public.gmane.org] 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:Neil.Robertson-Ravo-OVe770fkhX4xS3q+KiyLeA@public.gmane.org] 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 _____ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:166260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
		Add comment


Alexander Sicular 11 June 2004 16:10:47 [ permanent link ]
	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)> 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?!!?!?> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:166274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
		Add comment


Neil Robertson-Ravo 11 June 2004 16:18:11 [ permanent link ]
	Thanks, 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:as867-WLbs8XpHrcb2fBVCVOL8/A@public.gmane.org] 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)> 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?!!?!?> _____ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:166279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
		Add comment


Neil Robertson-Ravo 11 June 2004 16:29:53 [ permanent link ]
	I have the gripe that its not happening on one server.....SQL2K, CFMX 6.1 etc...i.e. the same settings all around _____ From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson-Ravo-OVe770fkhX4xS3q+KiyLeA@public.gmane.org] Sent: 11 June 2004 14:18 To: CF-Talk Subject: RE: ValueList() Error Thanks, 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:as867-WLbs8XpHrcb2fBVCVOL8/A@public.gmane.org] 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)> 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?!!?!?> _____ _____ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:166285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
		Add comment


Neil Robertson-Ravo 11 June 2004 16:32:48 [ permanent link ]
	I have the gripe that its not happening on one server.....SQL2K, CFMX 6.1 etc...i.e. the same settings all around _____ From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson-Ravo-OVe770fkhX4xS3q+KiyLeA@public.gmane.org] Sent: 11 June 2004 14:18 To: CF-Talk Subject: RE: ValueList() Error Thanks, 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:as867-WLbs8XpHrcb2fBVCVOL8/A@public.gmane.org] 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... 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:166288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
		Add comment

QAIX > ColdFusion > ValueList() Error 11 June 2004 16:32:48

	see also: [Clustering/JBoss] - Problem with… [Security & JAAS/JBoss] - Problems… [O'Reilly JBoss 3.0/4.0 Workbook] - I…		пройди тесты:		see also: How to convert DVD video YouTube iTunes… Free Download - Clone2Go Free Audio… What is podcasting?

Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:

If you would like to report an abuse of our service, such as a spam message, please .




Get comments by e-mail Add to favourites

Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

ValueList() Error

Add new comment