%@LANGUAGE="VBSCRIPT" codepage=1252%>
<%
' Displaying News
Dim cnnLogin
Dim rs, rs1
Dim strUsername, strPassword
Dim strSQL, strSQL1, data_source, RowCount
data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("Allen.mdb")
Set cnnLogin = Server.CreateObject("ADODB.Connection")
cnnLogin.Open "DSN=sstdtorgsa_ALLen;UID=sstdt;PWD=dtsst"
Set rs = Server.createobject("ADODB.Recordset")
Set rs1 = Server.createobject("ADODB.Recordset")
strSQL = "SELECT * FROM news ORDER BY (id) desc"
strSQL1 = "SELECT * FROM advertisement ORDER BY (id) desc"
Set rstLogin = cnnLogin.Execute(strSQL)
rs.Open strSQL, cnnLogin
rs1.Open strSQL1, cnnLogin
'Closing News
'<%
'Mailing Code
Dim name, company, city, country, tel, fax, companies, mobile, email, comments, strBody
name = (Request.Form("name"))
mobile = (Request.Form("mobile"))
email = (Request.Form("email"))
remarks = (Request.form("remarks"))
strBody = "Comments :: From SSTDT Website" & vbcrlf & vbcrlf
strBody = strBody & "Name:" & name & vbcrlf
strBody = strBody & "Mobile:" & mobile & vbcrlf
strBody = strBody & "Email:" & email & vbcrlf
strBody = strBody & "Comments:" & vbcrlf
strBody = strBody & remarks
strHost = "mail.sstdt.org.sa"
If Request("Comments") <> "" Then
Set Mail = Server.CreateObject("Persits.MailSender")
' enter valid SMTP host
Mail.Host = strHost
Mail.From = email ' From address
Mail.FromName = Request.Form("name") ' optional Mail.EncodeHeader( "windows-1256" ,)
Mail.AddAddress "info@sstdt.org.sa"
' message subject
Mail.Subject = "Comments :: From SSTDT Website" 'Mail.EncodeHeader( , "windows-1256")
' message body
Mail.Body = strBody
strErr = ""
bSuccess = False
On Error Resume Next ' catch errors
Mail.Send ' send message
If Err <> 0 Then ' error occurred
strErr = Err.Description
else
bSuccess = True
End If
End If
%>
SSTDT :: Saudi Society for Technology Development & Transfer
Energize and develop the scientific thinking in the area of technological development, innovation, and transfer
:: Establish communication channels between the society members
::
Provide scientific consultation in the area of technology development, innovation and transfer& nbsp;
:: Improve the scientific & professional performance of the society members
:: Facilitate the exchange of scientific output & ideas related to the society interests between establishments and institutes inside and outside of the kingdom
<% If strErr <> "" Then %>
Sorry.. There is error
<% = strErr %>
Please try again...
<% End If %>
<% If bSuccess Then %>
Your commnets has been
successfully sent....
<% End If %>
© Saudi Society of Technology
Development & Transfer. 2007