What's quite a few? I have a couple of SQL tables with more than 100
columns, one with over 200 columns, and have no problems at all... and
that's
SQL 2005, Vista, CF8.
You may have a problem with available memory or disk space.
Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100
Hauppauge NY 11788
P : 631.231.6600 Ext. 119
F : 631.434.7022
http://www.austin-williams.com
Great advertising can't be either/or. It must be &.
Plug in to our blog: A&W Unplugged
http://www.austin-williams.com/unplugged
-----Original Message-----
From: A D [mailto:[email protected]]
Sent: Thursday, November 19, 2009 4:30 PM
To: cf-talk
Subject: Re: CF8, Vista, SQL 2005
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:328530
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
