enrmpaga
04-26-2006, 11:51 AM
I'm creating a dvd hire webby for uni and i'm stuck on getting the return date to calculate aand was wondering if anyone could help me.. here is my code:
<%
Dim IDKEY, CUSTID, HireLength, DateAdd, days, Price, Dateofreturn
IDKEY=Request.form("IDKEY")
SQL_CUSTID = "SELECT * FROM cust WHERE CUSTID= 'Surname'"
SQL_CUSTID = CUSTID
HireLength= ChkString(Request.form("HireLength"))
days = CStr(HireLength)
response.write "Debug: HireLength = " & HireLength & "!"
response.flush
if Hirelength = "4" THEN
Price = "£4.00"
Dateofreturn = (DateAdd("d",8,date()))
End if
if Hirelength = "7" THEN
Price = "£6.00"
Dateofreturn = (DateAdd("d",11,date()))
End if
%>
<table border="0" cellpadding="4" cellspacing="2" align="center"><br>
<tr><td><b>Product ID:</b></td><td><%response.write(request.querystring("IDKEY"))%></td>
<td><b>Film:</b></td><td><%response.write(request.querystring("Film"))%></td>
<td><b>Length of Hire:</b></td><td><%response.write(request.querystring("HireLength") & " days")%></td></tr>
<tr><td><b>Price:</b></td><td><%response.write(Price)%></td>
<td><b>Hire Date:</b></td><td><%=Date()%></td>
<td><b>Return Date:</b></td><td><%response.write(Dateofreturn)%></td></tr>
</table>
<%
Set RS = Nothing
objConn.Close
Set objConn = Nothing
%>
<%
Dim IDKEY, CUSTID, HireLength, DateAdd, days, Price, Dateofreturn
IDKEY=Request.form("IDKEY")
SQL_CUSTID = "SELECT * FROM cust WHERE CUSTID= 'Surname'"
SQL_CUSTID = CUSTID
HireLength= ChkString(Request.form("HireLength"))
days = CStr(HireLength)
response.write "Debug: HireLength = " & HireLength & "!"
response.flush
if Hirelength = "4" THEN
Price = "£4.00"
Dateofreturn = (DateAdd("d",8,date()))
End if
if Hirelength = "7" THEN
Price = "£6.00"
Dateofreturn = (DateAdd("d",11,date()))
End if
%>
<table border="0" cellpadding="4" cellspacing="2" align="center"><br>
<tr><td><b>Product ID:</b></td><td><%response.write(request.querystring("IDKEY"))%></td>
<td><b>Film:</b></td><td><%response.write(request.querystring("Film"))%></td>
<td><b>Length of Hire:</b></td><td><%response.write(request.querystring("HireLength") & " days")%></td></tr>
<tr><td><b>Price:</b></td><td><%response.write(Price)%></td>
<td><b>Hire Date:</b></td><td><%=Date()%></td>
<td><b>Return Date:</b></td><td><%response.write(Dateofreturn)%></td></tr>
</table>
<%
Set RS = Nothing
objConn.Close
Set objConn = Nothing
%>