SQL Statement

Wrox Programmer Forums

		Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Basics
SQL Statement

ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics 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

Old

September 30th, 2003, 03:58 PM

stu9820

stu9820 is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 1,110

Thanks: 0

Thanked 3 Times in 3 Posts

Default

SQL Statement

Here is my SQL statement

strSQL = "SELECT news_title FROM zNews WHERE ((zNews.news_title)="Training News");

Before I even build the project VS.NET is saying "end of statement expected".

I want it to pull out all rows with "Training News". I have no Idea why it won't allow this. Any suggestions?

Old

September 30th, 2003, 04:30 PM

planoie

planoie is offline

Friend of Wrox

Join Date: Aug 2003

Posts: 5,407

Thanks: 0

Thanked 16 Times in 16 Posts

Default

strSQL = "SELECT news_title FROM zNews WHERE zNews.news_title='Training News'"

Peter

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with SQL Statement	forumsUID	SQL Server 2000	1	August 23rd, 2007 08:08 AM
convert a SQL Statement from MS Access to a SQL	Corey	Access	6	March 28th, 2007 12:33 PM
SQL Statement	rylemer	SQL Language	3	October 21st, 2005 09:07 PM
Sql Statement help	morpheus	Classic ASP Basics	0	March 9th, 2004 10:55 AM
sql statement	[email protected]	Beginning VB 6	2	June 23rd, 2003 04:28 PM