Search results for query: *

Hi All, I asked the below question in the asp.net forum but its been suggested this could be handled through IIS rather than through code. Could anyone advise please? I have a number of domain names pointing at the same website, for example: http://a.com http://www.a.com http://b.com...

Hi Jason, Thanks for the reply, I thought I may be able to do this with HTTP Redirect in IIS7 but when I set "redirect requests to this destination" I got a page not found error on the site. I'll try re-posting there and see what suggestions I get. Rick

Hello all, I have a number of domain names pointing at the same website, for example: http://a.com http://www.a.com http://b.com http://www.b.com Which is effectivly duplicate content from a search engine perspective, so what I want to do is 301 redirect all traffic to http://www.a.com, so a...

Thanks for the replies. kmcferrin - good point, I will change the port. itsp1965 - thats what I was hoping, I'm just not sure how to go about it, by interface do you mean network connection? Rick

Hi All, I have just purchased a VPS running Windows 2008 R2 Web. I have 2 IP addresses with the server, I want to use the primary for web traffic (the server is going to host one website) and I want to restrict RDP traffic to the second IP address. Can anyone set me on the right course to do...

Wow, lots of responses, thank you all! I'll have a play with the solutions and see where I end up. Thanks again. Rick

Hi all, I have a table of football results which in its most basic form contains columns for team, date and result (Win,Lose). Can anyone suggest a way to find the longest run of wins/losses for any team in the table without using a cursor? The longest run should be limited to a single team...

Thanks for this Jason, I'll have a good read through later. Rick

VS 2010, .NET 4.0, C# Hello All, I’m currently planning a new web app and intend to use entity framework for the first time. I have read a few articles that say that one ObjectContext instance should be created per HTTP request and I’m trying to find out how this can be implemented. I have...

Not to worry, I have done it on the menuitemdatabound. Rick

Using VB.NET 2.0 with VS2005 Hi All, I have a sitemap driven menu on my website, I need tio be able to dynamically add the the url of each link item, so for example the element: <siteMapNode url="Test.aspx" title="Test" description="Test" /> ...needs be have its link converted to...

Just what I needed, thanks!

Hi All, I have a asp.net code behind page (2.0 vb.net) which adds to the cache in the the format System.Web.Caching.Cache.Add("mycache",....... I want to be able to access the cache from a separate class file like so Dim c = System.Web.Caching.Cache("mycache") but get the error "Cache is a...

OK, thanks George.

Hi All, Im just just wondering which method is more efficent and the pros and cons of each of the following two: Pass-through query Select * from table1 Inner Join Openquery('links','Select * from table2') ls on table1.id = ls.id And Select * from table1 Inner Join Server.Database.dbo.table2...

Thats great. Thanks for your comments! Rick

Hi, Can anyone tell me which of the following is the best/most efficient way of performing a left outer join and what the differences are? SELECT a.a_name q.q_text FROM question q LEFT OUTER JOIN answer a ON a.q_ID = q.q_ID and a.a_valid = 1 SELECT a.a_name q.q_text FROM question q...

Oh I see. Thanks!

Hi, thanks for the comments, its good to learn how I could do things better. I didnt really understand what you meant here Could you explain with an example if you have time? Thanks!

Hi, Im using dynamic SQL because the tables (and in some cases columns) that I am inserting into are provided by the initial query. Im open to suggestions if there is a better way of doing this, this is the first time I have used cursors. Here is the rest of the SQL (no yet complete)...