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:311376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
