SQL Error Display Event Form

Expand Post »

Helo friends;

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

Similar Threads

Populating & Retrieving Data in a listbox : ASP.NET (w/ VB.NET) in ASP.NET
Updated : Simple ASP.Net Login Page in ASP.NET
JSP: Cascading option box problems ... in JSP
Warning: mysql_num_rows(): in PHP
Login used to work in ASP.NET

hisheeraz

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Oct 2008

Permalink

Oct 9th, 2008

Re: SQL Error Display Event Form

Try

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

rapture

Reputation Points: 155

Solved Threads: 41

Posting Whiz in Training

Offline

294 posts
since Jul 2007

Permalink

Oct 9th, 2008

Re: SQL Error Display Event Form

thanks...solved with missing & sing in ur sql expression.

Last edited by hisheeraz; Oct 9th, 2008 at 4:27 pm.

hisheeraz

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Oct 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Smart phone emulator

Next Thread in VB.NET Forum Timeline: Guessing Game

DaniWeb Message

Cancel Changes

User Name
Password