shoestring

In general, 1024x768 is good. However, if you are talking about an existing site, then it's best to have a look at google analytics (assuming the site has been using that for a while) - you can then check what resolution your visitors are using and also what the bounce …

What is the datatype of RelationshipType? Based on the name, I would expect a numeric datatype. However, you are inserting a string into it: '3'. Could that could be the problem?

You are passing in '' as a the @sortfield so the sql that is created in the stored proc has wrong order clause : "ORDER BY [dbo].[PropertyGroup]." The stored proc should check that @sortfield is something sensible before adding the order by.

I would also suggest that you store the whole date and the then just take present the month and date.

Hello everyone. I have just joined daniweb forum today. I used to be an SQL programmer for quite a while, but now I am doing mainly web design (all aspects of it). I hope to learn a thing or two about designing the user interface for web sites here. Maybe …