I checked, everything is exactly the same for both calls. Yes we do set NOCOUNT ON.
Yes it returns the proper columns just no data. Steve -----Original Message----- From: Leigh [mailto:[email protected]] Sent: Wednesday, November 30, 2011 3:51 PM To: cf-talk Subject: Re: Weird SQL Query happenings... > don't return the same record set. Hm.. on second thought I may have read that wrong. If the resultset you are getting back contains the correct column names just no records - then ignore my comment about NOCOUNT. It does not apply. -Leigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
