2. ASPRunnerPro General questions
  3. Insert a record into another table Before Delete
This topic is locked

Insert a record into another table Before Delete

 		7/19/2008 10:38:30 AM
ASPRunnerPro General questions
V
 virtualkaiser author

DON'T WORK!!! >> values (Filed1,Filed2,Filed3) ??? i dont understand!! help me!!! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=9038&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
the name table is TblUserkill

and the file :
UserLogin

Userpassword

UserReference
'** Insert a record into another table ****

strSQLInsert = "insert into TblUserkill (Userid, UserLogin,Userpassword,UserReference) values ({$row.1Login_value}, {$row.1password_value}, {$row.1Reference_value})"

Response.write strSQLInsert

response.end

dbConnection.Execute strSQLInsert
BeforeDelete = True
J
 		Jane 7/21/2008

Hi,
here is the correct code:

'** Insert a record into another table ****

strSQLInsert = "insert into TblUserkill (Userid, UserLogin,Userpassword,UserReference) values (" & dict("UserID") & ",'" & dict("Login") & "','" & dic("password") & "','" & dict("Reference") & "')"
V
 		virtualkaiser author 7/26/2008

WORK Perfect!!! tks TKS tks TKS <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=31442&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=31442&image=2&table=forumreplies' class='bbc_emoticon' alt=':lol:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=31442&image=3&table=forumreplies' class='bbc_emoticon' alt=':P' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=31442&image=4&table=forumreplies' class='bbc_emoticon' alt=':D' />