MX Javascript error
Question:How can I get the Insert Record with Ident extension to work with Dreamweaver mx? Read More
Insert Record With Identity
How can I get the Insert Record with Ident extension to work with Dreamweaver mx? Read More
Explore the FAQs
How can I get the Insert Record with Ident extension to work with Dreamweaver mx? Read More
Insert Record With Identity
Automatically set a session variable with the new record ID
Make this slight modification to an already great extension to place the just inserted record ID in to a session variable called NewID. Then, you can reference the NewID in a new recordset. (There may be a better way to do this but it worked great for me using UD4 and SQL Server 7.0!) Read MoreInsert Record With Identity
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
Question:
I have noticed several people have been receiving this error as well as myself. I'm using an Access 2000 DB & I've tried it on SQL 7.0.
I receive this error on BOTH types of DBs:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
Any resolution to this so far?