Yeah - I tried that using the below...
The image tag in the email....<img src="http://www.thinkingaboutmoving.co.uk/siteadmin/emailfiles/emailtracker.asp?p=[OfficeID]&c=[CampID]" width="1" height="1" alt="" border="0">BTW, the [OfficeID] and [CampID] are replaced as the sub loops thru the recordset...
The emailtracker file...If Request.QueryString("c") <> "" Then
Dim OfficeID, campaignID
OfficeID = Request.QueryString("p")
campaignID = Request.QueryString("c")
Set cmdTrackEmail
cmdTrackEmail = Server.CreateObject("ADODB.Command")
cmdTrackEmail.ActiveConnection = strConnection
cmdTrackEmail.CommandText = "spTrackEmail"
cmdTrackEmail.CommandType = adCmdStoredProc
Dim objParam1 : Set objParam1 = cmdTrackEmail.CreateParameter ("@OfficeID",adInteger,adParamInput)
Dim objParam2 : Set objParam2 = cmdTrackEmail.CreateParameter ("@CampCode",adIngeger,adParamInput)
cmdTrackEmail.Parameters.Append objParam1
cmdTrackEmail.Parameters.Append objParam2
cmdTrackEmail.Parameters("@OfficeID") = OfficeID
cmdTrackEmail.Parameters("@CampCode") = campaignID
cmdTrackEmail.Execute
Set cmdTrackEmail = Nothing
End If
Response.Write "http://www.thinkingaboutmoving.co.uk/images/general/transparent.gif"
and the stored procedure...CREATE PROCEDURE spTrackEmail (
@OfficeID [int],
@CampCode [int]
)
AS
UPDATE tbl_CampHistory
SET HTMLopened = 1
WHERE OfficeID = @OfficeID AND CampCode = @CampCode
GO
But it doesn't update the campaign history table.
Any ideas???
Dominic :D