> i know many programmers believe that 'select *' is the devils tool but > that will be the answer to my issue i believe as then it will return > the actual case in the db. thats what i am currently finding > anyway!!! Yes, it makes sense that 'select *' would use the column info from the database. However, in some cases that seems like a steep price to pay just to get the correct column case. It may not matter if you are selecting 5 int columns out 6 total. But what about larger tables, or those with columns containing a large amount of data like clob fields?
Rather than using 'select *', what about using cfdbinfo to get the column names from the db, and using that instead? Granted it is another query, but you may want to compare the two options. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299588 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
