VB.NET

SQL Error Display Event Form

Please support our VB.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Oct 2008

Posts: 9

Reputation: hisheeraz is an unknown quantity at this point

Solved Threads: 0

hisheeraz

Offline

Newbie Poster

SQL Error Display Event Form

Oct 9th, 2008

Helo friends;

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
 
        If lbDriverName.SelectedIndex = True Then
            sql = "SELECT * FROM tblDriver WHERE dName =" & lbDriverName.SelectedItem
        Else
            sql = "SELECT * FROM tblDriver"
        End If
        If lbDriverName.SelectedIndex = True Then
            sql = "SELECT * FROM tblDriver WHERE dName =" & lbDriverName.SelectedItem
        Else
            sql = "SELECT * FROM tblDriver"
        End If

and my error is...

$<br /> <br /> Syntax error (missing operator) in query expression 'dName ='.<br /> <br />$

where dName is the column in access table.
please hlp.
thanks

•

Join Date: Jul 2007

Posts: 276

Reputation: rapture has a spectacular aura about

Solved Threads: 37

rapture

Offline

Posting Whiz in Training

Re: SQL Error Display Event Form

Oct 9th, 2008

Try

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
 
            sql = "SELECT * FROM tblDriver WHERE dName ='" & lbDriverName.SelectedItem"'"
     
            sql = "SELECT * FROM tblDriver WHERE dName ='" & lbDriverName.SelectedItem"'"

I think that should work - you have to have the whole statement surrounded by double quotes but to add the selected item I think you put it within double quotes within single quotes . . .

maybe this post helps:

http://www.daniweb.com/forums/post700733.html

Last edited by rapture; Oct 9th, 2008 at 3:54 pm. Reason: add other forum post