You searched for the word(s): userid:653134

More Search Options

RSS Available

• SQL server - OVER SQL construct not supported

  When I execute the following sql lines on my store procedure: SELECT * FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY ID DESC) AS rownum from YAD2) AS YAD2 WHERE (Category = 13) AND (OnStatus = 1) AND (rownum between 1 and (1 + 15) - 1) SELECT * FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY ID DESC) AS rownum from YD) AS YD WHERE (Category = 13) AND (OnStatus = 1) AND (rownum between 1 and (1 + 15) - 1) I get the following error: "The OVER SQL construct or statement is not supported." And finally

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Sitesbuilders on 11/15/2009

• Re: SQL server - OVER SQL construct not supported

  The interesting issue is that if I eliminate the WHERE (Category = 13) AND it's work. But I do want to get my data where category = 13.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Sitesbuilders on 11/15/2009

• Re: SQL server - OVER SQL construct not supported

  I found that the problem is not with the over(). When I use these line: SELECT * FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY ID DESC) AS rownum from YD) AS YD WHERE (Category = 13) AND (OnStatus = 1) AND (rownum between 1 and (1 + 15) - 1) The rownum return some missing records and I have no idea why. I know that Category = 13 should return 3 rows and there no rows.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Sitesbuilders on 11/15/2009

• Re: SQL server - OVER SQL construct not supported

  Thank you so much ! You solved my problem.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Sitesbuilders on 11/15/2009

• Re: Asp.net ajax - ModalPopup with a form

  My main problem is that when I write the following code: <div> <asp:Panel ID="Panel1" runat="server" CssClass="modalPopup" Style="display: none; width:233px"> Ready <div align="center"> <asp:Button ID="OkButton" runat="server" Text="OK" /> <asp:Button ID="CancelButton" runat="server" Text="Cancel" /> </div> </asp:Panel> <br /> <ajaxToolkit

  Posted to ASP.NET AJAX Control Toolkit (Forum) by Sitesbuilders on 11/8/2009

• MS SQL QUERY

  I have two tables: "Posts" with the following Columns: ForumID, Title, Details, VisitorID, CreateDate, UpdateDate, OnStatus, IPaddress, TopicCreateName, PostViews And "Messages" - PostID, Title, Details, VisitorID, CreateDate, OnStatus, IPaddress, MessageCreateName each "posts" contain messages and I would like to create an sql query that when I select all my post I will also get with each row the total number of Messages. Any Idea ?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Sitesbuilders on 11/7/2009

• Asp.net ajax - ModalPopup with a form

  I would like to create a ModalPopup with a form. When someone click on a button a ModalPopup appears with a form. Is it possible ? And how to do it ?

  Posted to ASP.NET AJAX Control Toolkit (Forum) by Sitesbuilders on 11/7/2009

• Re: Asp.net ajax - ModalPopup with a form

  I have an article and I want my users to write their comments about the article. At the bottom of the article I have a button that if someone click on it he can have a ajax modalpop with a form and he can write his comment into my database

  Posted to ASP.NET AJAX Control Toolkit (Forum) by Sitesbuilders on 11/7/2009

• How to turn HTMLEditor toobar to Hebrew ?

  I understand that the Ajax Toolkit Html Editor support multi languages, I want the toolbar and the direction of the text to be shown in Hebrew. Any Idea ?

  Posted to ASP.NET AJAX Control Toolkit (Forum) by Sitesbuilders on 10/30/2009
  Filed under: AJAX Toolkit, htmleditor

• Intelligencia.UrlRewriter on Godaddy Hosting Server

  I use Intelligencia.UrlRewriter.dll on my bin folder in order to rewrite SEO friendly urls. On my local development computer it's work fine but when I upload my code to my shared hosting plan in Godaddy I get the following Error page: The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly

  Posted to Component Discussions (Forum) by Sitesbuilders on 10/30/2009