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