This is REALLY clutching at straws, but here are some stupid things you might try:
SELECT Mcaidrecad FROM BASICINFO WHERE IDNo = '5183' (in case there's something about "IDNo, Mcaidrecad" it doesn't like) Or output the queryname.columnlist, and cut-and-paste from that instead of from the db definition. -----Original Message----- From: Sonny Savage [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2008 11:32 AM To: CF-Talk Subject: Re: Flummoxed bya simple query I've seen issues surrounding ColdFusion caching table structures. To fix the problem, go into CF administrator, turn off caching for that datasource, execute your query again, and turn caching back on. On Thu, Aug 21, 2008 at 11:24 AM, Tim Claremont < [EMAIL PROTECTED]> wrote: > The following queries all return the same recordcount (1161 Records): > > SELECT * > FROM BASICINFO> > SELECT * > FROM BasicInfo > > SELECT * > FROM BaSICINFO > > > > >It could be an issue with table names, since tables are actually files, > >but not for columns. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:311377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
