Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:653134
More Search Options
RSS Available
Matching Posts
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
Page 1 of 11 (102 items) 1
2
3
4
5
Next >
...
Last »
ASP.NET:
Moving your ASP.NET Application to Windows Azure – Part II
Silverlight:
HVP – Core Scaffolding and Updated News
Channel 9:
TWC9: 2009 - The Year in Review
ASP.NET:
Tip#100: Did you know… How to view ASP.NET trace information?
ASP.NET:
Passing anonymous objects to MVC views and accessing them using dynamic
Channel 9:
Channel 9 Live at PDC09: Coding 4 Fun
Channel 9:
Channel 9 Live at PDC09: Stephen Toub
WindowsClient:
Mouse Gestures for Internet Explorer
Channel 9:
Controlling concurrency in Rx
Channel 9:
Dev Tools Ecosystem Summit Videos Available
WindowsClient:
Using Cerebrata's Cloud Storage Studio To Download IIS logs from Multiple Instances of Windows Azure
TechNet Edge:
TechNet Radio: Office 2007 Setup and Configuration (Part 1)
Channel 10:
How-To: Listen to Your Zune Pass Music on Your WinMo Phone
Channel 10:
Share Your Screen with SharedView
Channel 10:
Get Microsoft Tinker Game For Free
Channel 10:
LG eXpo WinMo 6.5 Unboxing Video
Channel 9:
ADFS 2.0 RC is Here!
Channel 10:
Bing Reference Updated with New Sidebar Features
Channel 10:
Look Behind SurfaceScapes
ASP.NET:
Moving your ASP.NET Application to Windows Azure – Part I
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online