I am using the ValueList Function to create a list of ID from a query.

<cfset lst = ValueList( qry.ID ) />

All the ID numbers in the RDBMS are whole integers, but what I am
getting back is this:

1001.0, 1002.0, 1003.0, 1004.0

But when I use <cfoutput> to display the results of the query I get this:

<cfoutput query="qry">
#ID#,
</cfoutout>

1001, 1002, 1003, 1004,

Is there something wrong with the ValuList Function?
How can I fix this?

Troy

--
Troy Simpson
   Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to