I just double checked (finally getting back to this issue)... and my numeric columns are definately coming back as strings.
So are my dates. On 10/2/07, Rick Root <[EMAIL PROTECTED]> wrote: > On 10/2/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > > I upgraded to Coldfusion 8 over the weekend, and someone reported > > > yesterday So I did some debugging and noticed that those values are > > > now strings, and they're being sorted as strings would be sorted. > > > > What database driver are you using? > > Just the built-in JDBC driver for MS SQL Server. > > the only thing that's a little odd about my setup is that I'm not > returning the query directly... I'm returning several queries inside a > coldfusion struct.. > > <cfset retVal.GIFTS = getMatchingGiving> > <cfset retVal.USES = getUses> > <cfset retVal.FUNDS = getFunds> > <cfreturn retVal> > > Rick > > -- > Rick Root > Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at > www.opensourcecf.com > -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/Flex/message.cfm/messageid:4668 Subscription: http://www.houseoffusion.com/groups/Flex/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.37
