I get this error no matter what key field I use. Fields have no Null values and are unique. However ASP page for editing will not appear.
Error number -2147217900
Error description [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
URL /ASPRunner/Employees_edit.asp
SQL query select BirthDate,EmployeeID ,LastName ,FirstName ,Title ,TitleOfCourtesy ,BirthDate ,HireDate ,Address ,City ,Region ,PostalCode ,Country ,HomePhone ,Extension ,Photo ,Notes ,ReportsTo ,PhotoPath from [dbo].[Employees] where EmployeeID=
Looks to me like there is no variable that denotes what the "Where EmployeeID= " Blank.
Since the key cannot be null it fails.
Is there a variable at the end of this statment that Fieldname=Current Record so that it does not come back Blank?
Please Help
Thanks
DC
If this works correctly I'm buying it today.