How do I add the data from the database which is under <job>....</job> with the email send using the sendmail.xsl
in the <sendmail:body> part??
<esql:row-results>
<job>
<post-date> <esql:get-string column="post_dt"/> </post-date>
<location> <esql:get-string column="job_city"/> </location>
<pay-rate> <esql:get-string column="pay_rate"/> </pay-rate>
<assignment> <esql:get-string column="assignment_typ_txt"/> </assignment>
<industry> <esql:get-string column="industry_txt"/> </industry>
<job-type> <esql:get-string column="job_typ_txt"/> </job-type>
<description><esql:get-string column="job_description"/> </description>
</job>
<xsp:logic>
String text ="Hi,\n"+"Here is the job you are looking for\n";
</xsp:logic>
<mailme>
<sendmail:send-mail>
<sendmail:from>email from address</sendmail:from>
<sendmail:to>email to address</sendmail:to>
<sendmail:subject>subject</sendmail:subject>
<sendmail:charset>ISO-8859-1</sendmail:charset>
<sendmail:smtphost>smtp address</sendmail:smtphost>
<sendmail:body><xsp:expr>text</xsp:expr></sendmail:body>
</sendmail:send-mail>
</mailme>
</esql:row-results>
Silvy Mathews
