Mike L
|
| Posted: 08/30/2002, 12:29 PM |
|
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?
I'm using CCS 1.0.7.0 / ASP / MSSQL 2K
|
|
|
 |
|
