VB.NET

VB.NET RSS

Help with nested sql statements

Please support our VB.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

Thread Solved

•

Join Date: Jun 2007

Posts: 49

Reputation: Mr.Wobbles is an unknown quantity at this point

Solved Threads: 2

Mr.Wobbles Mr.Wobbles is offline

Offline

Light Poster

Help with nested sql statements

Feb 13th, 2008

First I will show you my sql, just in case it is some obvious syntax error on my part:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
"INSERT INTO tblResults(status, enthusiasm, communication, knowledge, interaction,
                                   organization, responsiveness, instID, comment)" & _
 "VALUES(""" & status & """, """ & enthusiasmB & """, """ & communicationB & """, """ & _
                     knowledgeB & """, """ & interactionB & """, """ & organizationB & """, """ & _
                     responsivenessB & """, (" & getFacIDB & "), """ & _
                     comment & """)"
"INSERT INTO tblResults(status, enthusiasm, communication, knowledge, interaction,
                                   organization, responsiveness, instID, comment)" & _
 "VALUES(""" & status & """, """ & enthusiasmB & """, """ & communicationB & """, """ & _
                     knowledgeB & """, """ & interactionB & """, """ & organizationB & """, """ & _
                     responsivenessB & """, (" & getFacIDB & "), """ & _
                     comment & """)"

where

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim getFacIDB As String = "SELECT instID FROM tblInstructor" & _
                                " WHERE firstName = '" & firstNameB & "'"
Dim getFacIDB As String = "SELECT instID FROM tblInstructor" & _
                                " WHERE firstName = '" & firstNameB & "'"

So if you can't tell what I am trying to do is pull the id from another table so that I have a valid faculty reference between the tables. What I am looking for is a Select statement nested inside an Insert statement.

The error I am getting is "Unspecified error" on:
dr = resultsCommandA.ExecuteNonQuery

Any help is appreciated.

Mr.Wobbles~

•