Joined: 10 Nov 2002 Homepage: link Country: Pakistan Posts: 1
Posted: 11 Nov 2002 15:06:47
I am having prob in this Sql query..(related to Northwind Database Given As Sample Database In Access And Sql Server) Select All those orders(order ids) which have following product id: 1) 11 2) 42 3) 72
I am having prob in this Sql query..(related to Northwind Database Given As Sample Database In Access And Sql Server) Select All those orders(order ids) which have following product id: 1) 11 2) 42 3) 72
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> I am having prob in this Sql query..(related to Northwind Database Given As Sample Database In Access And Sql Server) Select All those orders(order ids) which have following product id: 1) 11 2) 42 3) 72 <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
The problem is not in your query. The problem is in the name of the table. It contains space (Order Details) and hence not only the above query but any query involving the above table (Order Details) will show invalid object name.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> I am having prob in this Sql query..(related to Northwind Database Given As Sample Database In Access And Sql Server) Select All those orders(order ids) which have following product id: 1) 11 2) 42 3) 72 <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
The problem is not in your query. The problem is in the name of the table. It contains space (Order Details) and hence not only the above query but any query involving the above table (Order Details) will show invalid object name.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> I am having prob in this Sql query..(related to Northwind Database Given As Sample Database In Access And Sql Server) Select All those orders(order ids) which have following product id: 1) 11 2) 42 3) 72 <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Try the query as "Order Details" as the table name.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> I am having prob in this Sql query..(related to Northwind Database Given As Sample Database In Access And Sql Server) Select All those orders(order ids) which have following product id: 1) 11 2) 42 3) 72 <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Try the query as "Order Details" as the table name.
When a graph is drawn, the focus is kept on the actual underlying competing figures that constitute the graph. Sometimes it is difficult to make assumptions just by looking at these graphs. When looking at a geographical map of data you immediately see exactly where things are happening. This article presents a .NET geographical mapping solution that will illustrate a fairly simple way of implementing these maps.
Have you, as a web developer or designer ever been on sites where the site seems more of a puzzle then a tool to find the information you where looking for? Or are you looking to improve your web design skills? Then read on!
Design & Accessibility
This e-Book will teach you how to become a truly professional developer or designer. By taking usability and accessibility issues in account when designing your websites or applications you can make the difference and avoid a lot of (user) frustration.
Inside ASP.NET is a comprehensive guide to ASP.NET development using Microsoft's .NET development framework. This book presents information on the .NET framework that is of specific interest to Internet and intranet developers, and is split into the following sections: Introducing ASP.NET, Core ASP.NET, ASP.NET and Data Access, Advanced Technologies, Advanced Web Forms, and Putting It All Together
Each chapter tackles a specific area of ASP.NET development, first by giving a detailed overview, then presenting a series of code examples and walk-throughs that illustrate various applications of ASP.NET
Posted: 11 Nov 2002 15:06:47 
