Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | 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 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 .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #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
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are 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



All times are GMT -4. The time now is 06:33 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.