Writing a SQL statement on serveral lines [* Resolved *]

[steve_rm]

Hello

I have a SQL statement which is long. How do l write it so that it is on serveral lines.

This is what l have tried to do.

CnnStr = "SELECT student.studentID, student.FirstName, student.LastName" +
                "book.bookID, book.Title" +
         "FROM student, book" +
         "WHERE student.studentID = book.studentID";

This does not work, and anyone tell me how to do this.

Many thanks in advance,

Steve

[crptcblade]

That should work fine, except that you are missing commas and spaces in your statement. Look at the end of each line.

[steve_rm]

Hello,

Thanks for your help. I think l was thinking too much like VB. I thought with concatenation you left out the commas.

Thanks very much,

Steve

[sagey]

why are you hardcoding sql into your application?. unless there is a really good reason this is an extremely bad idea. i terms of security, performance, modularity

[hellswraith]

Want to do something even cooler? Check it out:

CnnStr = @"SELECT
student.studentID,
student.FirstName,
student.LastName,
book.bookID,
book.Title
FROM student, book
WHERE student.studentID = book.studentID";

That little @ sign is some powerful stuff...