|
 |
asp_cdo thread: retrieving more than one value from db table.
Message #1 by cerquettim@y... on Sun, 2 Sep 2001 23:40:02
|
|
Hello - I'm just wondering if anyone can help me out here!
I need to send an email notification to the owner, readers and editors of
a selected project management document.
In order to do that I have to retrieve several field email values from the
database table relative to the owner,
readers and editors emails in the specific table.
What I have done - I have retrieved the single value for the document
owner email in this way:
<input type="text" size="47" name="txtTo" value="<%=rsDocs("WRES_EMAIL")%
>">. TThis works for only one value though
- when I try to retrieve the editors and readers values so that I can pop
them onto the input text box
(To or Cc form fields) it comes back with some dots.
Please have a look at NOTIFY1.asp, the page where the message is submitted:
<%
function DBDateToUKDate( date ) {
var d = new Date(date);
return( d.getDate() + "-" + (d.getMonth()+1) + "-" + d.getYear() );
}
var oConn = new ActiveXObject("ADODB.Connection");
oConn.ConnectionString = "Provider=SQLOLEDB;Data
Source=NEIL;Database=Project_Central;
User ID=PCOwner;Password=PCOwner";
oConn.Open();
var sqlDOCS = "select distinct CPS_WEB_RISKS.*, CPS_WEB_DOC_REVISIONS.*,
CPS_WEB_DOCUMENTS.*, RES_NAME, WRES_EMAIL, PROJ_NAME from ";
sqlDOCS += "(CPS_WEB_RISKS inner join ";
sqlDOCS += " (CPS_WEB_DOC_REVISIONS inner join ";
sqlDOCS += " (CPS_WEB_DOCUMENTS inner join MSP_WEB_RESOURCES ";
sqlDOCS += " on CPS_WEB_DOCUMENTS.[OWNER_WRES_ID] = MSP_WEB_RESOURCES.
[WRES_ID]) ";
sqlDOCS += " on CPS_WEB_DOC_REVISIONS.[DOC_ID] = CPS_WEB_DOCUMENTS.
[DOC_ID]) ";
sqlDOCS += "on CPS_WEB_RISKS.[REV_ID] = CPS_WEB_DOC_REVISIONS.[REV_ID]), ";
sqlDOCS += " CPS_WEB_DOC_ACCESS, MSP_WEB_PROJECTS where ";
sqlDOCS += "CPS_WEB_DOC_REVISIONS.[CURRENT] = 1";
sqlDOCS += " and ";
sqlDOCS += "CPS_WEB_DOCUMENTS.WPROJ_ID = MSP_WEB_PROJECTS.WPROJ_ID";
sqlDOCS += " UNION ";
sqlDOCS += "select distinct CPS_WEB_RISKS.*, CPS_WEB_DOC_REVISIONS.*,
CPS_WEB_DOCUMENTS.*, RES_NAME, WRES_EMAIL, PROJ_NAME from ";
sqlDOCS += "(CPS_WEB_RISKS inner join ";
sqlDOCS += " (CPS_WEB_DOC_REVISIONS inner join ";
sqlDOCS += " (CPS_WEB_DOCUMENTS inner join MSP_WEB_RESOURCES ";
sqlDOCS += " on CPS_WEB_DOCUMENTS.[OWNER_WRES_ID] = MSP_WEB_RESOURCES.
[WRES_ID]) ";
sqlDOCS += " on CPS_WEB_DOC_REVISIONS.[DOC_ID] = CPS_WEB_DOCUMENTS.
[DOC_ID]) ";
sqlDOCS += "on CPS_WEB_RISKS.[REV_ID] = CPS_WEB_DOC_REVISIONS.[REV_ID]), ";
sqlDOCS += " CPS_WEB_DOC_ACCESS, MSP_WEB_PROJECTS where ";
sqlDOCS += "CPS_WEB_DOCUMENTS.DOC_ID = CPS_WEB_DOC_ACCESS.DOC_ID "
sqlDOCS += " and ";
sqlDOCS += "CPS_WEB_DOC_REVISIONS.[CURRENT] = 1";
sqlDOCS += " and ";
sqlDOCS += "CPS_WEB_DOC_ACCESS.[WRES_ID] = ";
sqlDOCS += oPJSession.oUser.nUserID;
sqlDOCS += " and ";
sqlDOCS += "CPS_WEB_DOCUMENTS.WPROJ_ID = MSP_WEB_PROJECTS.WPROJ_ID";
var rsDocs = oConn.Execute( sqlDOCS );
%>
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<meta name="GENERATOR"
content="Microsoft FrontPage (Visual InterDev Edition) 2.0">
<title>CDONTSMail</title>
</head>
<body bgcolor="#FFFFFF">
<form action="SendMail.asp" method="POST" id=form1 name=form1>
<%
var sqlACCESS = "select * from CPS_WEB_DOC_ACCESS where ";
sqlACCESS += "CPS_WEB_DOC_ACCESS.[ACCESS] = ";
sqlACCESS += 0;
sqlACCESS += " and ";
sqlACCESS += " CPS_WEB_DOC_ACCESS.DOC_ID = ";
sqlACCESS += rsDocs("DOC_ID");
var rsAccess = oConn.Execute(sqlACCESS);
%>
<table border="0">
<tr>
<td>From:</td>
<td><!--webbot bot="Validation" b-value-required="TRUE" -->
<input type="text"size="47" name="txtFrom" value=" "></td>
</tr>
<tr>
<td>To:</td>
<td><!--webbot bot="Validation" b-value-required="TRUE" -->
<input type="text" size="47" name="txtTo"
value="<%=rsDocs("WRES_EMAIL")%>">
</td>
</tr>
<tr>
<td>Subject:</td>
<td><input type="text" size="47" name="txtSubject"
value="Enter a subject here"></td>
</tr>
<tr>
<td valign="top">Message:</td>
<td><textarea name="txtMessage" rows="9" cols="45">
Type your message here.</textarea></td>
</tr>
<tr>
<td valign="top">Importance:</td>
<td><input type="radio" name="optImportance"
value="2">High<br>
<input type="radio" checked name="optImportance"
value="1">Normal<br>
<input type="radio" name="optImportance" value="0">Low<br>
</td>
</tr>
</table>
<p><input type="submit" name="cmdSubmit" value="Submit">
<input type="reset" name="cmdClear" value="Clear"> </p>
</form>
</body>
</html> </PRE><BR><BR>
best regards,
Max
|
|
|
View Cart
