Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 18th, 2006, 11:14 AM
Authorized User
 
Join Date: Aug 2006
Location: , , .
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.”


  #2 (permalink)  
Old September 18th, 2006, 02:16 PM
Authorized User
 
Join Date: Jan 2006
Location: , , .
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

WERE should be WHERE.

I didn't have a problem getting this example to work.
  #3 (permalink)  
Old 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
Send a message via MSN to DanM
Default

Ditto.
The error message turns up because WERE is not a SQL keyword. VWD is expecting WHERE.

Dan
  #4 (permalink)  
Old June 12th, 2007, 10:23 PM
Registered User
 
Join Date: Jun 2007
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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


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





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.