Advertisement

10.11.2008 at 11:37AM PDT, ID: 23806769 | Points: 500
[x]
Attachment Details

SQL Server Time out on ASP Page

Asked by theformulaCT in MS SQL Server, Active Server Pages (ASP)

Tags: , ,

hi... i have the following sql select statement:

SELECT propertyID,Image1,PropertyRef,AgentID,SellingPrice,PropertyType,ProvinceName,PropertyLocationCity,PropertyLocationSuburb, PropertyLocationProvince, SuburbName,Townname,bedrooms,bathrooms, garages,PropertySellingHeadline FROM   propertyQuery  ORDER BY SellingPrice"

This works fine - however as soon as i add the following field to the list that im requesting i get an error:
Field Name: "PropertyDescription"
Field type: varchar (1000)

The page timesout when the query runs.

Any solutions please i've been stuck for 5 hours now!Start Free Trial
[+][-]10.11.2008 at 11:41AM PDT, ID: 22694931

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.11.2008 at 11:46AM PDT, ID: 22694943

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.11.2008 at 12:49PM PDT, ID: 22695116

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.11.2008 at 01:19PM PDT, ID: 22695205

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.11.2008 at 04:48PM PDT, ID: 22695668

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.11.2008 at 10:19PM PDT, ID: 22696421

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.12.2008 at 07:28AM PDT, ID: 22697544

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.12.2008 at 07:37AM PDT, ID: 22697582

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628