Explore the FAQs

Insert Record With Identity

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

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 More
Insert 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?

Read More