Maybe so as it is certainly more efficient and makes for easier to maintain code.
But your response still does not answer the original question. Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Friday, December 07, 2007 10:04 AM To: SQL Subject: RE: SELECT * returning zero records You really should and need to replace the SELECT * with the proper field names, or write a UDF to grab the field names from the database and automatically use them in your statements. -----Original Message----- From: Susan Kelly [mailto:[EMAIL PROTECTED] Sent: Friday, December 07, 2007 9:53 AM To: SQL Subject: Re: SELECT * returning zero records I tried adding the alias. I still get zero records returned. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3011 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
