This works for me. You will have to translate the javascript to whatever you are using
...
SQL = insert into myTable(field2, field3, field4) values(dat2, dat3, dat4)
var dataConn = Server.CreateObject(ADODB.Connection);
dataConn.open(MM_soCalData_STRING);
var rs1 = dataConn.Execute(SQL); //
I have run into this problem in Access using MyODBC. Access will try to
evaluate the function last_insert_id() before it passes the query to the
database. It will do this EVEN if I say it is a 'dbSQLPassThrough' query.
Very aggravating.
j- k-
On Sunday 29 April 2001 06:23, [EMAIL
Hi,
On Sat, Apr 28, 2001 at 05:12:42PM +0200, Antonino Chirco wrote:
Mysql : 3.23.33
server : NT 4.0 S.P.3
Client : Win98
This is the table structure:
CREATE TABLE `ordinit` (
`ID_Ordine` int(11) NOT NULL auto_increment,
`Cod_Cliente` int(11) default NULL,
.. OMISSIS ..
My insert query look like your
'INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);';
after the query I look into the table 'ordinit' and always looks fine: the value of
ID_ordine is really incremented.
But the following 'select LAST_INSERT_ID()' return zero :-((
It looks like a bug ?
On Sun, Apr 29, 2001 at 03:38:07PM +0200, [EMAIL PROTECTED] wrote:
My insert query look like your
'INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);';
after the query I look into the table 'ordinit' and always looks fine: the value of
ID_ordine is really incremented.
But the
I have found the solution for my 'select LAST_INSERT_ID();' problem.
I must check the 'Change BIGINT columns to INT' option in the
ODBC entry options in my NT server and everything work fine.
Why this ?
This means that I never use BIGINT columns in my Database ?
Thanks.
Regards.