MikeL
|
| Posted: 08/30/2002, 11:26 AM |
|
I'm trying to send an email notification when a record is added (upon insert). I can get the email sent but I'm stuck trying to add the record id (primary key/autoincrementing). I have the record id set to autoincrement in CCS as well. This is the code I tried to use:
Set objCDO = Server.CreateObject("CDONTS.NewMail")
objCDO.From = CCDLookUp("NAME", "USERS", "USERID = " & CCToSQL(CCGetUserID, "Text"), DBITRD)
objCDO.To = "someone@somewhere.com"
objCDO.Subject = "New User Added"
objCDO.Body = "www.url.asp?" &CCDlookUp("USERID", "USERS", "NAME LIKE " & CCToSQL(CCGetParam("NAME", Empty), "Text"), DBITRD)
objCDO.BodyFormat = 1
objCDO.MailFormat = 0
objCDO.Send
set objCDO=Nothing
Any other suggestions?
|
|
|
 |
MikeL
|
| Posted: 08/30/2002, 11:38 AM |
|
CCS 1.0.7.0 / ASP / MSSQL 2K
|
|
|
|
|
