<%
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%>
Cigarette Market Research: A Survey Study.
Jan. 1997 – April 1998
Contractor: Philip
Morris International
Two separate market researches where conducted
for the interest of Philip Morris Product Inc. The
first was conducted in the Palestinian territories
except the Eastern part of Jerusalem and covered
almost 4,000 outlets that were or might be potential
sellers of the company’s products. The study took
place between December 24, 1997 and January 3, 1998.
The second research took place in East-Jerusalem
between 5th of May 1998 and June 2, 1998. Both
researches were obtained through personal visits to
all outlets in all the Palestinian cities, villages,
and camps that have a 5,000 and above inhabitants. |
|
|
