<%
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%>
Market Research and Analysis:
This service identifies
marketing opportunities and constraints, prospective
buyers and consumers, information on market trends
and outlooks, market conditions and practices, and
competitive firms and products.
This service is divided into the following
categories:
- Market Surveys: This service aims to provide
comprehensive data and information to clients
depending on their needs.
- Market Research: This service reduces
investment risks with a thoroughly analyzed
Market research study of the project.
- Market Assessment: A pre-feasibility
evaluation to assess the viability of the
project.
- Market Strategy: This service provides a
strategy and a plan depending on: the needs of
clients, the current market climate and predicts
future trends of the investment sector.
|
Example:Phillip Morris
Market Research Analysis |
|
|
