Have you checked that the field name does NOT have a trailing Space? FoxPro and access allow spaces in field names.
[BasicInfo].[mcaidrecda ] isnt the same as [BasicInfo].[mcaidrecda] On Thu, Aug 21, 2008 at 5:39 PM, Andy Matthews <[EMAIL PROTECTED]>wrote: > That's not a bad idea. Have you tried aliasing the column to something else > then referencing the aliased column? > > > -----Original Message----- > From: Dan Crouch [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2008 4:19 PM > To: CF-Talk > Subject: Re: Flummoxed bya simple query > > I had a problem once where an CFLDAP query returned an invalid column name. > It was a similar issue where I could see it there, but I could not access > it > because it had an invalid column name. I found however that I could rename > it using a method that I found on Ben Nadel's site. While your column name > may not be invalid, perhaps you could try renaming it to something else to > see if you can access it. Worth a try maybe. > > http://www.bennadel.com/index.cfm?dax=blog:357.view > > Dan > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4