var conn = Server.CreateObject( "ADODB.Connection ");
conn.open( "remweb ", "remuser ", "zz*rem#user@ " );
var rs=server.CreateObject( "adodb.recordset ");
rs.open( "insert into em_talk(content,talk_from,talk_to) values ' "+say+ "',' "+from+ "',' "+to+ "') ",conn,1,3);
return ?;
-------------
先把原来的id选出来,在加1不就是你想要的值吗。哈哈
conn.open( "remweb ", "remuser ", "zz*rem#user@ " );
var rs=server.CreateObject( "adodb.recordset ");
rs.open( "insert into em_talk(content,talk_from,talk_to) values ' "+say+ "',' "+from+ "',' "+to+ "') ",conn,1,3);
return ?;
-------------
先把原来的id选出来,在加1不就是你想要的值吗。哈哈
直接加1得到的可能不是新插入的id
记住表名需要引号开心就好
conn.open( "remweb ", "remuser ", "zz*rem#user@ " );
var rs=server.CreateObject( "adodb.recordset ");
rs.open( "insert into em_talk(content,talk_from,talk_to) values ' "+say+ "',' "+from+ "',' "+to+ "') select @@identity 编号 ",conn,1,3);