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