Helloo every one this is my fist mail to the forum....
Ok i have a slight problem there with my asp pages..
no i have desiged the asp pages for our company for the customer management.. i am using sql server 2000 as the database..
all for me is workin fine on a stand alnoe pc if i have the asp file and athe sql server on the same pc.
but wht i need to know is that i need to run the same pages from about 10 pc the same time..
so i suppose ill have to upload the pages ont he sever and all the database..
but wht i need to know is how wuold i configure the pages in such a wayu that all the ppl can use the asp pages at the same time and also update or add to the sql daabase which lies ont he server..pls help me out this is gettin really irritaing
ill will give u the lines of code fro one of the oages help me out and tell me wht are the changer id have to make my con stament inorder for it to work right...
the code of one of the pages is below but the main satment that concerns me is
(con.open "provider=sqloledb;data source=matrix;uid=sa;database=princetonreview"
the lines of code are all for pc i am workion on its not connected on any sort of a network..would appreciate ur help..thank u all in advance..
Ok i have a slight problem there with my asp pages..
no i have desiged the asp pages for our company for the customer management.. i am using sql server 2000 as the database..
all for me is workin fine on a stand alnoe pc if i have the asp file and athe sql server on the same pc.
but wht i need to know is that i need to run the same pages from about 10 pc the same time..
so i suppose ill have to upload the pages ont he sever and all the database..
but wht i need to know is how wuold i configure the pages in such a wayu that all the ppl can use the asp pages at the same time and also update or add to the sql daabase which lies ont he server..pls help me out this is gettin really irritaing
ill will give u the lines of code fro one of the oages help me out and tell me wht are the changer id have to make my con stament inorder for it to work right...
the code of one of the pages is below but the main satment that concerns me is
(con.open "provider=sqloledb;data source=matrix;uid=sa;database=princetonreview"
the lines of code are all for pc i am workion on its not connected on any sort of a network..would appreciate ur help..thank u all in advance..
Code:
<!-- #include virtual="princetonreview/adovbs.inc" -->
<%
cpage=trim(request.querystring("currentpage"))
uname=(request.Cookies("counsellorname"))
ClientName=request("clientname")
if cpage="" then cpage=1
set con=server.createobject("adodb.connection")
con.open "provider=sqloledb;data source=matrix;uid=sa;database=princetonreview"
mysql="select * from client where counsellorName='"&uname&"' and clientname='"& ClientName &"'"
set rs=server.createobject("adodb.recordset")
rs.cursortype=adopenstatic
rs.pagesize=1
rs.open mysql,con
while not rs.eof
i=rs.recordcount
rs.movenext
wend
if i=0 then
response.redirect "search.htm"
else
rs.movefirst
end if
rs.absolutepage=CInt(cpage)
rowcount=0
InqNo=rs.fields(0)
inqday=rs.fields(1)
inqmonth=rs.fields(2)
inqyear=rs.fields(3)
ClientName=rs.fields(4)
ClientContact=rs.fields(5)
CourseName=rs.fields(6)
FirstInq=rs.fields(8)
FirstFollowUp=rs.fields(9)
SecondFollowUp=rs.fields(10)
ThirdFollowUp=rs.fields(11)
FollowUpDay=rs.fields(12)
FollowUpMonth=rs.fields(13)
FollowUpYear=rs.fields(14)
%>
<html>
<head>
<title>Client History</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
</head>
<body bgcolor=#ccccc>
<div align="center">
<p><strong><font color="#333333" size="4" face="Arial, Helvetica, sans-serif"><ins>Client
History</ins></font></strong> </p>
</div>
<div align="center">
<div id="Layer1" style="position:absolute; width:72px; height:21px; z-index:1; left: 606px; top: 30px;">
<table width="113%" border="0" align="right">
<tr>
<td align="right">
<%for i=1 to rs.pagecount%>
<a href="clientdetails.asp?currentpage=<%=i%>&clientname=<%=ClientName%>"><%=i%></a>
<%next%>
</td>
</tr>
</table>
</div>
<%while not rs.eof and rowcount<rs.pagesize %>
</div>
<table border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" bgcolor=beige>
<form method="get" action="update.asp">
<input type="hidden" name="ClientName" value="<%=ClientName%>">
<input type="hidden" name="ClientContact" value="<%=ClientContact%>">
<tr>
<td width="246"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Client
Name</font></td>
<td width="271"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<%=ClientName%> </font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Inquiry
Date</font></td>
<td valign="middle"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<%=inqday%>-<%=inqmonth%>-<%=inqyear%> </font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Contact
Number</font></td>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<%=ClientContact%>
</font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Course
Inquired </font></td>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<%=CourseName%>
</font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Next Follow Up Date</font></td>
<td valign="middle">
<font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="FollowUpDay" size="1" value="<%=FollowUpDay%>">-
<input type="text" name="FollowUpMonth" size="1" value="<%=FollowUpMonth%>">-
<input type="text" name="FollowUpYear" size="2" value="<%=FollowUpYear%>">
</font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Initial
Inquiry </font></td>
<td> <font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<textarea rows=5 cols=40 name=FirstInq><%=FirstInq%></textarea>
</font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">First
Follow Up</font></td>
<td> <font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<textarea rows=5 cols=40 name=FirstFollowUp><%=FirstFollowUp%></textarea>
</font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Second
Follow Up</font></td>
<td> <font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<textarea rows=5 cols=40 name=SecondFollowUp><%=SecondFollowUp%></textarea>
</font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Third
Follow Up</font></td>
<td> <font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<textarea rows=5 cols=40 name=ThirdFollowUp><%=ThirdFollowUp%></textarea>
</font></td>
</tr>
<tr>
<td height="26" colspan="2" align="right"> <font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<input type="submit" name="update" size="30" value="U p d a t e">
</font>
</td>
</tr>
</form>
</table>
<%rs.movenext
rowcount=rowcount+1
wend%>
</body>
</html>
