What's wrong with this that's causing my error:

"Microsoft VBScript compilation error '800a0401'

Expected end of statement

/test/search2.asp, line 22

if request.form("f_lastname") <> "" then
^"



sql = "SELECT * FROM names WHERE date_time <> '' " _
    if request.form("f_lastname") <> "" then
            & "and last_name = " & request.form("f_lastname")
    end if
==============

I've tried it a few different ways, but I keep getting the same error.

Thanks for the assistance!!

A few things, compare the differences:

sql = "SELECT * FROM names WHERE date_time <> '' " & _
    if request.form("f_lastname") <> "" then
       sql = sql & " and last_name = " & request.form("f_lastname")& ";"
    end if

Is the field last_name a string? I suspect so, if so you will need extra single quotes. EG:

sql = "SELECT * FROM names WHERE date_time <> '' " & _
    if request.form("f_lastname") <> "" then
       sql = sql & " and last_name = '" & request.form("f_lastname") & "';"
    end if

Wind is your friend
Matt

Thanks Matt!!

I had tried what you said before I posted but I was getting the error. Now I know why. It was as you posted that I needed the single quote. The other thing I did change from you example was to take the & _ out from sql = "SELECT * FROM names WHERE date_time <> '' " & _. It now works perfect. :)

Glad to hear - oooopss my apologies you are correct no need for the & _ sorry bout that

Wind is your friend
Matt