|
 |
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8  | This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 by Chris Hart, John Kauffman, David Sussman, Chris Ullman; ISBN: 9780764588501 |
|
Welcome to the p2p.wrox.com Forums.
You are currently viewing the BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
|
 |
|
|

September 18th, 2006, 11:14 AM
|
Authorized User
|
|
Join Date: Aug 2006
Location: , , .
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Chapter 10, Try it out Page 365, C#, line 7
Chapter 10, Try it out Page 365, C#, line 7
SQL statement that is recommended to use:
SELECT PlayerID, FirstName, LastName, Position, PictureURL, DateJoined, DateLeft
FROM Players
WERE PlayerID = @PlayerID
When adding “WERE PlayerID = @PlayerID” to the SQL statement and clicking next the check box for “Create methods to send update directly to the database” is disabled “grayed out”. If you remove the “WERE PlayerID = @PlayerID” from the SQL statement the check box for “Create methods to send update directly to the database” is enabled.
If you click on the “Query Builder..” button in the “Enter SQL statement” dialog you will get this message “Unable to parse query text.”
|

September 18th, 2006, 02:16 PM
|
Authorized User
|
|
Join Date: Jan 2006
Location: , , .
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
WERE should be WHERE.
I didn't have a problem getting this example to work.
|

September 25th, 2006, 12:11 PM
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Banbury, , United Kingdom.
Posts: 105
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Ditto.
The error message turns up because WERE is not a SQL keyword. VWD is expecting WHERE.
Dan
|

June 12th, 2007, 10:23 PM
|
Registered User
|
|
Join Date: Jun 2007
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I have been trying to execute the following query in table adapter in the Microsoft Visual Studio. I am accessing a Microsoft Access Database.
But I keep getting the SQL Syntax Error: Unable to Parse Query Text
SELECT COUNT(*)
FROM
(SELECT DISTINCT[P A].[Last Name]
FROM [P A]
WHERE ([P A].[Month] = @Month) AND ([P A].[Code] = @code));
I am not sure how to handle this error. Please advice
Thanks
|
Thread Tools |
Search this Thread |
|
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
Similar Threads
|
Thread |
Thread Starter |
Forum |
Replies |
Last Post |
Chapter 11, Favorites Viewer pp 347-365 |
corncrake |
BOOK: Beginning Visual Basic 2005 ISBN: 978-0-7645-7401-6 |
1 |
June 24th, 2008 05:13 AM |
Errata - Chapter 10, Page 377, C# |
RobC |
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 |
5 |
October 3rd, 2006 02:26 AM |
Errata - Chapter 10, Page 378, C# |
RobC |
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 |
0 |
August 31st, 2006 09:56 AM |
Errata - Chapter 10, Page 376, C# |
RobC |
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 |
0 |
August 31st, 2006 09:07 AM |
Ex 10, Chapter 5, page 253 |
Nick Y |
BOOK: Ivor Horton's Beginning Visual C++ 2005 |
1 |
June 16th, 2006 01:14 AM |
|
 |