>>>>>This produces:
>>>>>Error Type:
>>>>>Response object, ASP 0185 (0x8002000E)
>>>>>A default property was not found for the object.
>>>>>/contactmanager/edituser.asp
>>>>
>>>>If you go back one step, remove execscript and just try insert command (no return), would it work?
>>>
>>>Yes, the insert by itself works fine.
>>
>>Can you create a SP in your database that would return the inserted value (GETAUTOINC()) and try to execute this SP instead of the direct insert?
>
>Probably, that's what Cetin recommended. But wouldn't know how to return the value to ASP.
Here's a SP Example lifted from the web:
PARAMETERS value
SET NULL OFF
INSERT INTO table1 (field1) VALUES (m.value)
CREATE CURSOR result (result i)
INSERT INTO result VALUES (GetAutoincValue())
RETURN SETRESULTSET("result")