Status: sleeping Command: AWAITING COMMAND Blocked By: 0 Got a bit further -
The table Im using has quite a few colums. I can do 'select top 33 *' but not 'select top 34 *' Could there be some limit to the amount of data SQL can return? >In the trace does the statement complete? >If you look at sysprocesses is that spid still running? >Are there any object locks that would affect the query? > >~Brad > >I ran a trace and the query statement showed up straight away in the >trace but CF page just keeps waiting. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4