<%Option Explicit %>
<%dim username,loguser
LogUser = clng(Session("_userid"))
username = Session("_username")
username = "" + username
%>
welcome to the world of KVO Parichayt
<%
Dim ConnectString, conn,mfolio
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("kvoparichay.MDB")
conn.open
dim cn,ConnectionString,FilePath,ProviderString
dim saveerror, msg, ht
dim cdate
dim varDay, varMonth, varYear
dim varDay2, varMonth2, varYear2
dim sSql,varsSql,ID,rs,sStatus, UserExists, ReturnURL
Dim strDatabasePath,mrela
dim FromDate, ToDate,xsex,xage1,xage2,xjob,xloc,b
Set cn = Server.CreateObject("ADODB.Connection")
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data 'Source=emp.MDB"
ConnectionString = ProviderString & FilePath &";Persist Security Info=False"
mrela = "SELF"
varDay = trim(Request.Form("cboDay"))
varMonth = trim(Request.Form("cboMon"))
varYear = trim(Request.Form("cboYear"))
varDay2 = trim(Request.Form("cboDay2"))
varMonth2 = trim(Request.Form("cboMon2"))
varYear2 = trim(Request.Form("cboYear2"))
xjob = trim(Request.Form("job"))
xloc = trim(Request.Form("CBOCURRENT_GAAM"))
xsex = Request.Form("sex")
xage1 = request.form("age1")
xage2 = clng(request.form("age2"))
FromDate = varDay & "/" & varMonth & "/" & varYear
ToDate = varDay2 & "/" & varMonth2 & "/" & varYear2
b = " "
Dim flag
Dim sqlwhere
Dim sqland
Dim sqllike
Dim colflag
sqlwhere = " where "
sqland = " and "
sqllike = " like "
'sSql = "select * from memdetail "
'_________________________________________________________________________________________________
'_________________________________________________________________________________________________
ssql = "SELECT member_id,fullname,year(now)-year(date_of_birth),education,village,height,occupation,firstname,fathername,grfather,surname,PResStatus from member_master where isnull(lastupdate)=False and val(year(now))-val(year(date_of_birth)) >= '"& xage1 & "' and val(year(now))-val(year(date_of_birth)) <= '"& xage2 & "' and gender = '" & xsex & "' order by year(now)-year(date_of_birth) asc;"
'ssql = "select member_id,fullname,age,education,height,occupation,PResStatus from member_master where val(age)>= '" & xage & "' and val(age) <= '" & xage & "' and gender = '" & xsex & "' and isnull(lastupdate)=False order by val(age) "
'If xloc="*" Then
' ssql = ssql
'else
' IF(FLAG = 0) THEN
' ssql = ssql & sqlwhere & "name" & sqllike '%" & xloc & "'%"
' flag = 1
' ELSE
' ssql = ssql & sqland & "name" & sqllike & "'" & xloc & "*'"
' End IF
'End If
set rs = conn.execute (sSql)
%>
 |
|
 |
 |
|
 |
Privacy
Policy
|
|
Terms & Conditions
Welcome to KVO Parichay.org. In order to use the KVO Parichay.org
Site ("Site"), you must register as a member of the Site
("Member"). The Member or any users using the Site agree to be
bound by these Terms of Use ("Agreement"). If you wish to become a
Member and communicate with other Members and make use of the KVO
Parichay.org service ("Service"), read these Terms of Use and
follow the instructions in the Registration process. This
Agreement sets out the legally binding terms for your membership.
This Agreement may be modified by KVO Parichay.org from time to
time.
Term: You may terminate your membership at any time, for any
reason by writing to KVO Parichay.org. In the event you terminate
your membership, you will not be entitled to any unutilized
subscriptions or services in future. KVO Parichay.org may
terminate your access to the Site and/or your membership for any
reason effective upon sending notice to you in your inbox.
Non-Commercial Use by Members: The KVO Parichay.org Site is for
the personal use of individual members only, and cannot be used in
connection with any commercial endeavors. This includes providing
links to other web sites, whether deemed competitive to KVO
Parichay.org or otherwise. Organizations, companies, and/or
businesses cannot become Members of KVO Parichay.org and should
not use the KVO Parichay.org Service or Site for any purpose.
Illegal and/or unauthorized uses of the Site, including
unauthorized framing of or linking to the Site will be
investigated, and appropriate legal action will be taken,
including without limitation, civil, criminal, and injunctive
redress.
Copyright Policy: You cannot post, distribute, or reproduce in any
way any copyrighted material, trademarks, or other proprietary
information without obtaining the prior written consent of the
owner of such proprietary rights.
Member Disputes: You are solely responsible for your interactions
with other KVO Parichay.org Members. KVO Parichay.org reserves the
right, but has no obligation, to monitor disputes between you and
other Members. KVO Parichay.org also reserves the right to take
appropriate action against errant members. However, KVO
Parichay.org is not obliged to share such action with other
members, including complainants. KVO Parichay.org expressly
disclaims any responsibility or liability for any transactions or
interactions between the members interest.
|
|
Copyrights 2007 KVO Parichay All
Rights Reserved.
Powered By  |