RE: valuelist under CFMX bug?????
My testing isn't showing this. Anyone else see it? === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 9:06 AM To: CF-Talk Subject: valuelist under CFMX bug? Hi, I've been trying to use valuelist on a column containing integers. This returns a list containing integers converted to 1 decimal point numbers. In effect its manipulating the values. Anybody else had this issue? Example Table with item_id column contains one row with an entry of 1. When you valuelist the query results you get 1.0 How do I raise this with Macromedia? Adam __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: valuelist under CFMX bug?????
Damm. I'm running the query against an access db. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 26 September 2002 14:19 To: CF-Talk Subject: RE: valuelist under CFMX bug? My testing isn't showing this. Anyone else see it? === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 9:06 AM To: CF-Talk Subject: valuelist under CFMX bug? Hi, I've been trying to use valuelist on a column containing integers. This returns a list containing integers converted to 1 decimal point numbers. In effect its manipulating the values. Anybody else had this issue? Example Table with item_id column contains one row with an entry of 1. When you valuelist the query results you get 1.0 How do I raise this with Macromedia? Adam __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: valuelist under CFMX bug?????
My initial test had been against SQL Server, but I get the same results w/ Access as well. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 9:52 AM To: CF-Talk Subject: RE: valuelist under CFMX bug? Damm. I'm running the query against an access db. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 26 September 2002 14:19 To: CF-Talk Subject: RE: valuelist under CFMX bug? My testing isn't showing this. Anyone else see it? == = Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 9:06 AM To: CF-Talk Subject: valuelist under CFMX bug? Hi, I've been trying to use valuelist on a column containing integers. This returns a list containing integers converted to 1 decimal point numbers. In effect its manipulating the values. Anybody else had this issue? Example Table with item_id column contains one row with an entry of 1. When you valuelist the query results you get 1.0 How do I raise this with Macromedia? Adam __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: valuelist under CFMX bug?????
Actually this is ringing a bell with me. Think I've seen it happen once a long time ago. It was down to the datatype in the datasource. Check you've not got a mask on your ident_id field and that your using the correct datatype (I've forgotten the access name for the datatype). -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 26 September 2002 14:52 To: CF-Talk Subject: RE: valuelist under CFMX bug? Damm. I'm running the query against an access db. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 26 September 2002 14:19 To: CF-Talk Subject: RE: valuelist under CFMX bug? My testing isn't showing this. Anyone else see it? === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 9:06 AM To: CF-Talk Subject: valuelist under CFMX bug? Hi, I've been trying to use valuelist on a column containing integers. This returns a list containing integers converted to 1 decimal point numbers. In effect its manipulating the values. Anybody else had this issue? Example Table with item_id column contains one row with an entry of 1. When you valuelist the query results you get 1.0 How do I raise this with Macromedia? Adam __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists