Recent content by cfusiondeveloper

thanks for replying to my thread. The problem I'm having is not limited to anchor tags. I am always taken to the top of the page in the frame (right frame). For example, if I am half way through reading an article displayed inside a right frame and click on another link on left frame and hit the...

I'm afraid the site is not live. I'm having problems taking the user to the very exact location in the page when the back button is clicked. There must be something I could check on load. I just don't know javascript too well. I'm sorry I'm asking a lot of help here. Regards cfcoder

Found this on the O'reilly website JavaScript: The Definitive Guide, 3rd Edition which made me think the replace button had the answer to this problem. The replace() method loads and displays a URL that you specify. But invoking this method for a given URL is different than assigning that URL...

sure - but there must be some way to force the frame to scroll down to the point where it last was. I've heard the replace() function can do this but don't know how to use it, any thoughts

Hello everybody, I'm sure this problem has been discussed before in this forum but I can't seem to find any thread. I am building a site that uses frames. The site uses 3 fames, top nav, left nav and right nav. <frameset rows="140,*" frameborder="no" frameborder="2" framespacing="0"...

can somebody please help!!

Hi guys, I don't know how to put it to you, I got the spec wrong. I showed the results returned by the query to my team and it was not quite the results my manger was expecting. I'll try and explain. At the moment the query returns the following IssueUnique Issue1 Issue2 IssueCount Issue...

I have got it to return the fields I wanted it to. here is the code. Thanks ever so much for your help. SELECT TOP 5 IssueUnique, Issue1, Issue2, COUNT(*) AS IssueCount, Issue1 + '-' + Issue2 + '-' + CAST(IssueUnique AS CHAR) AS Issue FROM (SELECT JI.IssueUnique, JI.Issue1...

I've cracked it. This works: SELECT * FROM job_issues WHERE (CallSubjectUnique IN (SELECT TOP 5 CallSubjectUnique FROM (SELECT JI.CallSubjectUnique FROM jobs AS J INNER JOIN job_issues AS JI ON J.CallSubjectUnique = JI.CallSubjectUnique...

Here is the query: select * from job_issues where IssueUnique in ( select top 5 IssueUnique from ( select JI.IssueUnique from jobs as J inner join job_issues as JI on J.IssueUnique = JI.IssueUnique where JI.Issue1 > '' AND JI.Issue2 > '' and...

I'm sorry you are right there are 4 'AS' keywords and I don't know which one is throwing the error. I'm running the sql in SQL Analyser Server: Msg 156, Level 15, State 1, Line 11 Incorrect syntax near the keyword 'AS'.

as far as I can see there are only 2 AS keywords. I think its the second AS statement ) as dt2

I get an SQL Server error message Incorrect syntax near the keyword 'AS'

that does rock but I'm afraid I also want to return Issue1, Issue2 and Count At the minute it returns just the IssueUnique column IssueUnique 17 16 53 26 44 If you could also return the issue 1 and 2 names for the returned IssueUnique value that would be fantastic Regards, cfcoder

I just want to mention that each pair (Issue1, Issue2) has a UNIQUE IssueUnique value.