2. ASPRunnerPro General questions
  3. Email Quetions Part II
This topic is locked

Email Quetions Part II

 		8/8/2006 10:24:57 AM
ASPRunnerPro General questions
B
 BrownLumber author

I'm trying to send the subject line equal to 2 of the fields on the edit form. The fields are "JobID" and "SupportStatus". I can send one or the other by using the subject=dict("fieldname"). But I don't know how to send both. Can you help me on this one as well? Thanks.
J
 		Jane 8/9/2006

Hi,
here is a sample code:

subject = dict("JobID")&", "&dict("SupportStatus")
B
 		BrownLumber author 8/9/2006

Thanks for the code. However, it doesn't seem to want to show the "JobID" field. The JobID is an autonumber field (primarykey) in an Access Database. The result I get from your code looks like this :
, Resolved
If I use a different field other than "JobID" then it works fine. Would this not work for an AutoNumber field?
J
 		Jane 8/11/2006

Hi,
add following code in your event:

str = "select * from TableName where " & where

Set rsTemp = server.CreateObject("ADODB.Recordset")

rsTemp.open str, dbConnection
message = "JobID : " & rsTemp("JobID") & vbcrlf



where TableName is your actual table name.