%
Const adTypeBinary = 1
Dim BinaryStream
Set BinaryStream = CreateObject("ADODB.Stream")
Function SetImgForDisp(inField, inContentType,i,blnHotProduct,Section)
Dim mOleHeadSize, mBytes
Dim mFieldSize, mDumpaway
mOleHeadSize = 78
inContentType = LCase(inContentType)
Select Case inContentType
Case "gif", "jpeg", "bmp", "jpg"
inContentType = "image/" & inContentType
mBytes = inField.value
Case "ole"
inContentType = "image/bmp"
mFieldSize = inField.ActualSize
mDumpaway = inField.GetChunk(mOleHeadSize)
mBytes = inField.GetChunk(mFieldSize - mOleHeadSize)
End Select
if blnHotProduct and section = "HotProduct" then
Session("HotProductBytes" & i) = mBytes
Session("HotProductTypes" & i) = inContentType
elseif section = "Movie" then
session("MovieImageByte") = mBytes
session("MovieImageType") = inContentType
elseif section = "Sport" then
session("SportImageByte") = mBytes
session("SportImageType") = inContentType
end if
End Function
set rsNews = server.CreateObject("adodb.recordset")
set rsCategory = server.CreateObject("adodb.recordset")
set rsHotProduct = server.CreateObject("adodb.recordset")
set rsNewsImages = server.CreateObject("Adodb.recordset")
set rsClassified = server.CreateObject("Adodb.Recordset")
set rsYellowPages = server.CreateObject("Adodb.Recordset")
rsCategory.Open "Select * from NEWS_CATEGORY order by categoryorder",cn,1,3
rsNews.Open "select a.*,b.categoryid,b.categoryname,b.categoryorder,c.NewsInHomePage from News_Posting as a, News_Category as b,Configuration as c where a.categoryid=c.categoryid and a.categoryid=b.categoryid and Approve = 1 order by CategoryORder asc,NewsID desc,Rank asc",cn,1,3
rsHotProduct.Open "Select * from SUPERSTORE_PRODUCTS WHERE Show = 1",cn,1,3
rsNewsImages.Open "select * from NEWS_IMAGES",cn,1,3
rsClassified.Open "Select a.SubCategoryID,a.categoryid,a.stateid,b.SubCategoryName,c.statename from C_Posting as a, c_subcategory as b,c_state as c where a.subcategoryid=b.subcategoryid and a.stateid=c.stateid order by a.postingdatetime desc",cn,1,3
rsYellowPages.Open "Select * from YP_CATEGORY WHERE DisplayInHomePage = 1 order by CategoryName",cn,1,3
cn.execute "UPDATE News_Posting SET DisplayInSite = 0"
%>
Indian Era works as a basis of wide variety
of Information about the Indian Community
in various cities and their surroundings.
This site also provides the platform for
the users to buy and sell various products,
services etc. as well as communication on
various topics and to find the jobs. Though
this service is free and intended for the
benefit of users, users should be aware
of the limitations and the latent risks
involved including but not limited to outdated
or wrong information. It is exclusively
at users' risk, caution and responsibility
that user use this site and information
provided in it.
Though we put every effort to provide
correct and reliable information in
our website, we can not give assurance
about outdated or wrong information.
Indian Era Team is not responsible for
accuracy of contents and other information
provided in the site. We are not accountable
for any errors, inaccuracies or insufficient
information on any of pages, links or
advertisement.
Most of the Information or material
is either from the web or is the only
responsibility of their respective owners
who submitted such information to us.
Such information doesn't reflect our
views. We are not liable for such material
or information. If users find such information
then they are requested to help us to
maintain our site with proper way.
When every precaution is made to avoid
material which offend, or criticize
any particular nation, section, caste
or sex, we can't rule out any such stray
occurrences. When user submits any information,
it is the user's responsibility that
it suitable with our policy. We are
not responsible for any dispute due
to such instances.
Our site provides the links to Affiliate
Sites maintained by third parties. We
are not responsible for development
and maintenance for the same. We are
not liable for the authenticity of the
material provided by third party.
User agrees that neither
Indian Era nor its staff shall be liable
for any direct, indirect damages or
losses due to the information provided
in this site. User aggress that the
usage of the information on this site
is solely at his own risk.
Third party logos, trademarks, services
and names used on Indian Era belong to
their respective owners. For more information
on them, please contact them.