<%
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%>
Israeli Obstacles to International and Local
Trade in Palestine at Border and Crossing Points.
Dec. 1998.
Contractor: Adam Smith
Institute
The study, which took place in the first half of
the year 1998, aimed at monitoring the entry and
exit methods for goods through crossing points: Erez
and Carni. This included the goods and trucks that
move through, kinds of goods, working time, work
system & entry procedures, and security inspection.
The study also covered information about the
apparatuses, and finally monitoring conducted over
the West Bank and Gaza’s crossing points. It also
included a one-week monitoring trial exercise on the
Erez crossing point. |
|
|
