<%
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%>
Karim Al-Bitar
Full time consultant at
MCS, a part time trainer of General and Financial
Management courses for different training centers,
and a part time lecturer of Accounting at Birzeit
University. Mr. Bitar holds BBA and MBA degrees,
both with high honors, from the Eastern
Mediterranean University in Northern Cyprus. Mr.
Bitar’s line of experience lies in the area of
developing, marketing and structuring business
plans. He is also specialized in financial
management, analysis and evaluation. His current
scope of work at MCS includes undertaking
feasibility Studies, marketing studies, preparation
for business plans, evaluating investments, and
analyzing financial data and reports.
Prior to joining MCS, Mr. Bitar was a senior
researcher and a consultant with Al-Mashriq for
Research and Studies, and the Allied Business
Consultants. He also spent two years as a lecturer
of economics and accounting at the E.M.U- Northern
Cyprus.
Mr. Bitar email address:
kbitar@mcs-palestine.com |
 |
|
|