<%
sql= "SELECT ID,type,sub_type,des_type,title,sub_title,des_title,email,enter_date FROM [content] Where type='Team of Consultants' ;"
Set rs = Server.CreateObject("ADODB.Recordset")
mdbfilepath = Server.MapPath("mcs.mdb")
rs.Open sql,"Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath &";", 3, 3
%>
<%
' Loop through our records and ouput 1 row per record
Do While Not rs.EOF
For I = 1 To 1
response.write ""
if rs(3)<>"" then
response.write "| " & rs(3) & " | "
else
response.write "" & rs(4) & " "
response.write "" & rs(5) & " "
if rs(6)<>"" then
response.write " more... | "
else
response.write ""
end if
end if
response.write " "
rs.MoveNext
Next 'I
' Increment the number of records we've shown
' Can't forget to move to the next record!
Loop
' All done - close table
' Close DB objects and free variables
rs.Close
Set rs = Nothing%>
Samer Irshaid
Part time consultant at
MCS. Mr. Irshaid holds a BA degree in Economics from
Birzeit University, and is a candidate for a Master
degree in Democracy and Human Rights from the same
university. Mr. Irshaid is highly experienced in the
field of economic assessment, organizational
structuring, and most notably in the analysis and
understanding of the structures and mechanisms of
the local market. Mr. Irshaid has worked with the
loan provision committee of Cooperation for
Development (CD) for more than 7 years, during which
he reviewed and evaluated over 200 projects ranging
from small to macro enterprises.
Prior to Joining MCS Mr. Irshaid was at
Al-Mashriq for Research and Studies, based in
Ramallah. During this time, Mr. Irshaid worked on
many feasibility studies and organizational reports
for both local and international clients.
Mr. Irshaid email adress:
mcs@mcs-palestine.com |
|
|