Home Forums SQL Server 2008 SQL Server Newbies sql command RE: sql command

  • May 9, 2014 at 10:15 am

    #1712260

    mkkb917 (5/9/2014)

    ZoneSearch is a variable and it contain a zone name selected form the combo box items

    here it is "City"

    don't you have to put singe quotes in there too, besides the missing equals sign?

    '"SELECT IP_Addr FROM IPPOOL WHERE ZoneName = 'Miami' AND UserName IS NULL"

    Dim adapterloadIP As New SqlDataAdapter("SELECT IP_Addr FROM IPPOOL WHERE ZoneName = '" & ZoneSearch & "' AND UserName IS NULL", con)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!