|
rikki -> betheball... can you help? (6/21/2004 15:45:10)
|
Hi Duane
I'm asking you because you have helped me so much to get this database to where it is!
I'm trying to do an edit page and then update..
I've got the following code....
What happens is the bookings that are made that have the BOOKINGNUMBER=0 are new. The camp administrator needs to verify payment and then assign a BOOKINGNUMBER. So, I need them to be able to view all the bookings =0 and then edit to assign a booking number to all those that apply.
I'd like the update to cover all the sites booked, so they don't have to do one at a time. I can do something in DIW but it's not near what I'd like.
Can you help?
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>BOOKINGNUMBER</title>
</head>
<body>
<table border="1">
<thead>
<tr>
<td> </td>
</tr>
</thead>
<tbody>
<!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM WETASKIWIN1 WHERE (BOOKINGNUMBER = ::BOOKINGNUMBER::) ORDER BY DateStart ASC"
fp_sDefault="BOOKINGNUMBER=0"
fp_sNoRecords="<tr><td colspan=28 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=28
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<tr>
<td>
<p> </td>
<td>
<%=FP_FieldVal(fp_rs,"BOOKINGNUMBER")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"AutoNumber")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"CAMPGROUP")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"LASTNAME")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"FIRSTNAME")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"EMAIL")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"CAMP")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"DateStart")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"DateEnd")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"CampSite")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"ADDRESS")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"CITY")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"PROVINCE")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"POSTALCODE")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"REGION")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"SECTION")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"YOUTH")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"ADULTS")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"OTHER")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"AREA")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"PHONE")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"PASSWORD")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"CHECKINTIME")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"CHECKOUTTIME")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"SCOUTING")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"NONSCOUTING")%> </td>
<td>
<%=FP_FieldVal(fp_rs,"DateStamp")%> </td>
</tr>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
<form method="POST" action="EDIT.asp?AutoNumber=<%=Request.form("AutoNumber")%>">
<p><input type="submit" value=" EDIT" name="B1"></p>
</form>
</body>
</html>
|
|
|
|
