Hi, guys. I'm having a slight problem trying to do a nested query in visual basic .net. I'm currently using an SQLDataReader to retrieve the data that the query should be returning. It seems, however, that the query itself is not returning anything because the DataReader gives me an error. Anyway, here is my current query:

 sqlGetScheduledEmp =
"SELECT FirstName, LastName
FROM Personnel
WHERE (SNo =
(SELECT SNo FROM PostAssignments WHERE (shiftID = '" & cboShift.Text & "' AND (postID =
(SELECT postID FROM Posts WHERE Unit = '" & txtUnit.Text & "' AND Post='" & cboAssignments.Text & "'))))"

I know the nested query itself works in SQL Server when I hard code the values. I have tried hard coding the values in .net, but I still get an error. Any suggestions would be VERY helpful, as I'm about to pull my hair out! ;)

Hi there,

Hope you're not bald by now ;)

Anyway, count your parentheses. The SQL statement uses 5 opening ( characters, and only four to close them again.

The easiest thing to test these kind of things is to put the entire SQL statement on a label on the page, right before you send the data to the database. Then paste the statement in the Query Analyzer and see if it works.....

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks, I finally figured it out last night. I had too many parentheses in there period! ;)