# Asp Syntax error

**URL:** https://forum.kirupa.com/t/asp-syntax-error/51605
**Category:** Uncategorized
**Created:** [May 14, 2004, 5:45pm UTC](https://forum.kirupa.com/t/asp-syntax-error/51605 "2004-05-14T17:45:59Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![imagined](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@imagined](https://forum.kirupa.com/u/imagined)
#### Post date: [May 14, 2004, 5:45pm UTC](https://forum.kirupa.com/t/asp-syntax-error/51605/1 "2004-05-14T17:45:59Z")

</div>

eRROR:  
Error Type:  
Microsoft JET Database Engine (0x80040E14)  
Syntax error (missing operator) in query expression ‘Server\_ID =’.  
/inventory/servers/serverItem.asp, line 39

This is the code  
%\>  
Dim blnNew  
’ detect whether the user is adding a new item or editing an existing one  
Select Case Request.QueryString(“Action”)  
Case “AddNew”  
blnNew = True  
Case “Edit”  
blnNew = False  
End Select

If blnNew Then  
Response.Write \_  
“\<CENTER\>\<H1\>UISD SERVRE\<BR\>Add New Product\</H1\>\</CENTER\>” & \_  
"\<P\>Please add the following information for the item you selected. "  
Else  
Response.Write \_  
“\<CENTER\>\<H1\>UISD SERVERS\<BR\>Edit Selected server\</H1\>\</CENTER\>” & \_  
"\<P\>Please edit the information for this product currently selected. "  
Dim rsItem  
Set rsItem = Server.CreateObject(“ADODB.Recordset”)  
strSQL = "SELECT \* FROM servers WHERE Server\_ID = " & Request(“servers”) & “;”  
rsItem.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic, adCmdText  
End If

%\>

I am able to save to the table, but error shows when I try to edit

HELP!

Thanks