HELP!! Syntax error (missing operator) in query expression

[sb7272]

Hello,

I'd be really really grateful if someone could help me solve this problem.

I get this following error msg:

Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'EmployeeID ='.

Relating to this code:

set RSEmp = conn.Execute("Select * from tblEmpDir where EmployeeID =" _
& Request.QueryString("EmployeeID&quot)
end if


My entire code is as follows:

<%@ Language=VBScript %>
<%
strConnect= &quot;Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\Inetpub\

http://wwwroot\_vti_script\IntrepidDB.mdb;&quot;

Set Conn = Server.CreateObject(&quot;ADODB.Connection&quot
'Open the connection
Conn.Open strConnect

if NOT isempty(Request.Form(&quot;Update&quot) then
conn.Execute &quot;update tblEmpDir set &quot; _
& &quot;Name = '&quot; & Request.Form(&quot;Name&quot & &quot;', &quot; _
& &quot;EmailAddress = '&quot; & Request.Form(&quot;EmailAddress&quot & &quot;', &quot; _
& &quot;PhoneNumber = '&quot; & Request.Form(&quot;PhoneNumber&quot & &quot;', &quot; _
& &quot;Department = '&quot; & Request.Form(&quot;Department&quot & &quot;' where &quot; _
& &quot;EmployeeID = &quot; & Request.Form(&quot;EmployeeID&quot
response.redirect &quot;./manage_data_menu.asp&quot;
else

set RSEmp = conn.Execute(&quot;Select * from tblEmpDir where EmployeeID =&quot; _
& Request.QueryString(&quot;EmployeeID&quot)
end if
%>

Id be eternally grateful if someone could solve this for me

Thanks

Sara

 

[FengShui1998]

Sara,

Do any of your values have a single quote in them. If so, you need to replace them with two single quotes.

also....

Is employeeID a text field or numeric. There are no single quotes surrounding Request.Form(&quot;EmployeeID&quot

fengshui_1998

 

[Microbe]

It means your querystring isn't being passed.

The best way to trouble shoot this thing is break your connectiion object up into its components.

Add on error resume next before the open statment.

Then response,write(&quot;StrSQL = &quot; & (your SQLstatement))

Are you sure it isn't supposed to be request.form(&quot;&quot? Just try request(&quot;EmplyeeID&quot and see the result.

Or display your querys tring on the page.

You get the idea? You need to see what is in the SQL statement


Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

Me? I can't even spell ASP!