cuneyt
03-11-03, 10:13
| Hi all, I want to insert multiple data in once.... Example: That's how my code works now... "cnn.execute" executes this code each time inside loop and then I'm taking datas from another table and writing my table.... do while not RS.Eof sqlstr2="insert into T_NBS_CCM_LIST(CTI,NAME,CLUSTERID) values('" & rs("ctiID") & "','" & rs("name") & "','" & rs("cID") & "')" cnn.execute(sqlstr2) rs.MoveNext loop what i want to do is something like below.... do while not RS.Eof array1= array1 + "," + rs("ctiID") array2= array2 + "," + rs("name") array3= array3 + "," + rs("cID") rs.MoveNext loop sqlstr2="insert into T_NBS_CCM_LIST(CTI,NAME,CLUSTERID) values('" & array1 & "','" & array2 & "','" & array3 & "')" cnn.execute(sqlstr2) The select statement below but I want to use it as insert statement.... here "extension " and "user" variables are array... Select * from T_NBS_INTERNAL WHERE (EXTENSION IN (" &extension&") OR USER_CODE IN (" &user&"))" So what i'm lookin for is something like Insert into T_NBS_INTERNAL values (EXTENSION IN (" &extension&") OR USER_CODE IN (" &user&"))" Thanx in advance.... |