ASP and SQL Error - expected end of statement

[vistor]

Hi,

my query is below.


If Request("query_type&quot = "name" Then
sqlQ = sqlQ & " WHERE Employee.last_name = " Request("txtlast_name"

ElseIf Request("query_type&quot = "location" Then
sqlQ = sqlQ & " WHERE Employee.location_id = " & CInt(Request("txtquery&quot) & " ORDER BY Employee.last_name, Employee.first_name"

ElseIf Request("query_type&quot = "dept" Then
sqlQ = sqlQ & " WHERE Employee.department_id = " & CInt(Request("txtquery&quot) & " ORDER BY Employee.last_name, Employee.first_name"
End If

The location and dept return data from the db just fine. The name does not. When the user inputs a name on the form, this error is generated:

Expected end of statement

sqlQ = sqlQ & " WHERE Employee.last_name = " Request("txtlast_name&quot
---------------------------------------------^

below is the code from the input on the form, :

<input type=&quot;hidden&quot; name=&quot;query_type&quot; value=&quot;name&quot;>
<input type=&quot;text&quot; name=&quot;txtlast_name&quot; size=&quot;20&quot; value= &quot;&quot; tabindex=&quot;1&quot;>


Any idea on why the last name wont search?

 

[durug]

First of all a bracket is missing(after &quot;txtlast_name&quot; ). Probably you didn't copied on the thread. but the problem is because you having the criteria after a string you should put it between single quotes like this

If Request(&quot;query_type&quot = &quot;name&quot; Then
sqlQ = sqlQ & &quot; WHERE Employee.last_name = '&quot; Request(&quot;txtlast_name&quot & &quot;'&quot;

Regards,
Durug

 

[vistor]

Durug,

Still getting error mwssage:
sqlQ = sqlQ & &quot; WHERE Employee.last_name = '&quot; Request(&quot;txtlast_name&quot & &quot;'&quot;
----------------------------------------------^
Let me see if I read your quote sequence correct:
WHERE Employee.last_name = single quote double quote
Request(&quot;txtlast_name&quot & double quote single quote double quote


CDWD

 

[durug]

I'm really dreaming
sqlQ = sqlQ & &quot; WHERE Employee.last_name = '&quot; & Request(&quot;txtlast_name&quot & &quot;'&quot;

Sorry. It should work now
Durug

 

[durug]

The corect sequence
WHERE Employee.last_name = single quote double quote &
Request(&quot;txtlast_name&quot & double quote single quote double quote

 

[vistor]

Durug,

Thank you so much, it is working fine now.