drw default values missing

drw default values missing (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

mjmtravel -> drw default values missing (5/24/2008 20:41:44)
I have another problem. I get this error when doing a update database results on the update page. Database Results Wizard Error Description: Parameter ?_3 has no default value. Number: -2147217904 (0x80040E10) Source: Microsoft JET Database Engine One or more form fields were empty. You should provide default values for all form fields that are used in the query. I have already run all 3 pages on the spooky diet. (results, edit, update). How do I change the default values after running the diet, or do I have to start over and do the defaults over again.

BeTheBall -> RE: drw default values missing (5/24/2008 21:55:11)
Post the SQL for the page that is throwing the error.

mjmtravel -> RE: drw default values missing (5/24/2008 21:59:57)

<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<title>Untitled</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<META HTTP-EQUIV="refresh" content="5;URL=reviews.asp">
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table cellpadding="0" cellspacing="0" border="0"  align="center">
	<tr>	
	  <td valign="top" width="766" height="700">
	  	<table cellpadding="0" cellspacing="0" border="0">
			<tr>
				<td valign="top" width="766" height="158" style="background-image:url(images/top.jpg) ">
					<table cellpadding="0" cellspacing="0" border="0">
						<tr>
							<td valign="top" width="766" height="158" style="background:url(images/7_bg1.gif) no-repeat bottom ">
								<div  style="margin:0 0 0 15px " class="s"><object align="left" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="736" height="158">
    <param name="movie" value="flash/Menu.swf?button=0">
    <param name="quality" value="high">
    <param name="menu" value="false">
    <!--[if !IE]> <!-->
    </object>
   <object data="flash/Menu.swf?button=0"
            width="736" height="158" type="application/x-shockwave-flash"> 
     <param name="quality" value="high">
     <param name="menu" value="false">
     <param name="pluginurl" value="http://www.macromedia.com/go/getflashplayer">
     FAIL (the browser should render some flash content, not this).
    </object>
    <!--> <![endif]-->
  </object>										
</div>		
							</td>
						</tr>
					</table>
				</td>
			</tr>
			<tr>
				<td valign="top" width="766" height="7" style="background-image:url(images/7_bg.gif) "></td>
			</tr>
			<tr>
				<td valign="top" width="766" height="637" bgcolor="#093465">
					<table cellpadding="0" cellspacing="0" border="0">
						<tr>
							<td valign="top" width="2" height="637" bgcolor="#163F6E"></td>
							<td valign="top" width="13" height="637"></td>
							<td valign="top" width="737" height="637">
								<table cellpadding="0" cellspacing="0" border="0">
									<tr>
										<td valign="top" width="737" height="637">
											<table cellpadding="0" cellspacing="0" border="0">
															<tr>
																<td valign="top" width="737" height="5">
																	<table cellpadding="0" cellspacing="0" border="0">
																		<tr>
																			<td valign="top" width="5" height="5" style="background-image:url(images/1_q1.gif) "></td>
																			<td valign="top" width="727" height="5" style="background-image:url(images/1_li1.gif) "></td>
																			<td valign="top" width="5" height="5" style="background-image:url(images/1_q2.gif) "></td>
																		</tr>
																	</table>
																</td>
															</tr>
															<tr>
																<td valign="top" width="737" height="627">
																	<table cellpadding="0" cellspacing="0" border="0">
																		<tr>
																			<td valign="top" width="1" height="627" bgcolor="#FFFFFF"></td>
																			<td valign="top" width="735" height="627" bgcolor="#0083C3">
<div class="w1"  style=" margin:5 10 0 12px; line-height:12px "><img src="images/6_z1.gif" alt="" border="0" align="left" style="margin-right:6px "><br style="line-height:3px "><img src="images/7_w1.gif" style="margin-bottom:1px " alt="" border="0"><br>
</div>
<p><b><font face="Zurich BT" size="2" color="#093465"> </font></b><!--#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="UPDATE Reviews SET Nickname = '::Nickname::', Title = '::Title::', DateArrived = '::DateArrived::', Rating = '::Rating::', RatingNumber = '::RatingNumber::', EmailAddress = '::EmailAddress::', CityStateCountry = '::CityStateCountry::', Comment = '::Comment::'  WHERE (Nickname = '" & session("Nickname") & "')"
fp_sDefault="Nickname="
fp_sNoRecords="Your Review Has Been Updated"
fp_sDataConn="ReviewDatabase"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&NicknameID=3&Nickname=202&Title=202&AssignedTo=3&OpenedBy=3&DateArrived=135&Status=202&Rating=202&RatingNumber=3&EmailAddress=202&EmailConfirm=202&CityStateCountry=202&Priority=202&Comment=203&DueDate=135&"
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<table BORDER="1" width="356">
	<tr>
		<td width="160"><b>Rating Number:</b></td>
		<td>
		<%=FP_FieldVal(fp_rs,"RatingNumber")%></td>
	</tr>
	<tr>
		<td width="160"><b>Title:</b></td>
		<td>
		<%=FP_FieldVal(fp_rs,"Title")%></td>
	</tr>
	<tr>
		<td width="160"><b>Date Arrived:</b></td>
		<td>
		<%=FP_FieldVal(fp_rs,"DateArrived")%></td>
	</tr>
	<tr>
		<td width="160"><b>Comment:</b></td>
		<td>
		<%=FP_FieldVal(fp_rs,"Comment")%></td>
	</tr>
	<tr>
		<td width="160"><b>Nickname:</b></td>
		<td>
		<%=FP_FieldVal(fp_rs,"Nickname")%></td>
	</tr>
	<tr>
		<td width="160"><b>Email Address:</b></td>
		<td>
		<%=FP_FieldVal(fp_rs,"EmailAddress")%></td>
	</tr>
	<tr>
		<td width="160"><b>Email Address Confirm:</b></td>
		<td>
		<%=FP_FieldVal(fp_rs,"EmailAddressConfirm")%></td>
	</tr>
	<tr>
		<td width="160"><b>City, State, Country:</b></td>
		<td>
		<%=FP_FieldVal(fp_rs,"CityStateCountry")%></td>
	</tr>

</table>
<hr>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</td>
																			<td valign="top" width="1" height="627" bgcolor="#FFFFFF"></td>
																		</tr>
																	</table>
																</td>
															</tr>
															<tr>
																<td valign="top" width="737" height="5">
																	<table cellpadding="0" cellspacing="0" border="0">
																		<tr>
																			<td valign="top" width="5" height="5" style="background-image:url(images/1_q4.gif) "></td>
																			<td valign="top" width="727" height="5" style="background-image:url(images/1_li2.gif) "></td>
																			<td valign="top" width="5" height="5" style="background-image:url(images/1_q3.gif) "></td>
																		</tr>
																	</table>
																</td>
															</tr>
										  </table>
										</td>
									</tr>
								</table>
							</td>
							<td valign="top" width="13" height="637"></td>
							<td valign="top" width="2" height="637" bgcolor="#163F6E"></td>
						</tr>
					</table>
				</td>
			</tr>
			<tr>
				<td valign="top" width="766" height="72">
					<table cellpadding="0" cellspacing="0" border="0" id="table1">
						<tr>
							<td valign="top" width="24" height="72" style="background-image:url(images/q1.gif) "></td>
							<td valign="top" width="720" height="72" style="background-image:url(images/li1.gif) ">
								<div  style="margin:27 0 0 6px " class="w">
									<img alt="" src="images/spacer.gif" width="40px" height="1px"><strong>Copyright©2008<br>
									Baker Investment Properties</strong><img alt="" src="images/spacer.gif" width="40px" height="1px"><a href="index.html" class="w">Home</a>  |  
									<a href="stcroix.html" class="w">St.Croix</a>  |  
									<a href="condofeatures.html" class="w">Condo 
									Features</a>  |  
									<a href="reservations.asp" class="w">Condo Reservations</a>  |  <a href="car_rental.html" class="w">Car Rental</a>  |  
									<a class="w" href="contactus.html">Contact Us</a>  |  
									<a class="w" href="reviewsupdate.asp">
									Privacy</a></div>
							</td>
							<td valign="top" width="22" height="72" style="background-image:url(images/q2.gif) "></td>
						</tr>
					</table>
				</td>
			</tr>
			<tr>
				<td valign="top" width="766" height="78"></td>
			</tr>
		</table>
	  </td>
	</tr>
</table>
</body>
</html>

BeTheBall -> RE: drw default values missing (5/24/2008 23:08:02)
Are you sure the session value has been correctly created? To check, insert the following code just before the <body> tag of the update page: <% Response.write(session("Nickname")) Response.end %>

mjmtravel -> RE: drw default values missing (5/25/2008 8:18:57)
Duane Yes after inserting that code I get a page not found. So that means its in my session value?

BeTheBall -> RE: drw default values missing (5/25/2008 10:24:26)
You should not be getting page not found even if there is a problem with the session. Have you turned off the "Show friendly http errors" feature in Internet Explorer? You will need to do so to see the true error. The setting is turned off by unchecking the box found under Internet Options - Advanced

mjmtravel -> RE: drw default values missing (5/25/2008 10:39:46)
Duane I have been trying this for so long. I have other sites that this is working fine. I'm going to start all over on these 3 pages and will let you know where I'm at. I will do all of the drw results wizards and put them on the diet after its all done. Thanks.

mjmtravel -> RE: drw default values missing (5/26/2008 12:03:52)
Duane I re-created all 3 of my form pages from scratch. I still have nothing showing up. If I change my session values to WHERE (Nickname = '" & session("Nickname") & "')" I get no records found. If I change it to WHERE NicknameID=::NicknameID::" I get this still: Database Results Wizard Error Description: Parameter ?_1 has no default value. Number: -2147217904 (0x80040E10) Source: Microsoft JET Database Engine One or more form fields were empty. You should provide default values for all form fields that are used in the query. I had this process down pat with 2 other sites, but something is wrong with this one. Any more help would be greatly appreciated.

BeTheBall -> RE: drw default values missing (5/26/2008 13:41:35)
Post the code for all three pages. Note, when you post, put at the beginning of each page and at the end of each page. That will create the little scrollable text boxes instead of causing the page to be too big horizontally.

mjmtravel -> RE: drw default values missing (5/26/2008 15:19:52)

results page

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<title>Untitled</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<link href="style.css" rel="stylesheet" type="text/css">
<script language="JavaScript">
<!--
function FP_swapImg() {//v1.0
 var doc=document,args=arguments,elm,n; doc.$imgSwaps=new Array(); for(n=2; n<args.length;
 n+=2) { elm=FP_getObjectByID(args[n]); if(elm) { doc.$imgSwaps[doc.$imgSwaps.length]=elm;
 elm.$src=elm.src; elm.src=args[n+1]; } }
}

function FP_preloadImgs() {//v1.0
 var d=document,a=arguments; if(!d.FP_imgs) d.FP_imgs=new Array();
 for(var i=0; i<a.length; i++) { d.FP_imgs=new Image; d.FP_imgs.src=a; }
}

function FP_getObjectByID(id,o) {//v1.0
 var c,el,els,f,m,n; if(!o)o=document; if(o.getElementById) el=o.getElementById(id);
 else if(o.layers) c=o.layers; else if(o.all) el=o.all[id]; if(el) return el;
 if(o.id==id || o.name==id) return o; if(o.childNodes) c=o.childNodes; if(c)
 for(n=0; n<c.length; n++) { el=FP_getObjectByID(id,c[n]); if(el) return el; }
 f=o.forms; if(f) for(n=0; n<f.length; n++) { els=f[n].elements;
 for(m=0; m<els.length; m++){ el=FP_getObjectByID(id,els[n]); if(el) return el; } }
 return null;
}
// -->
</script>
</head>
<body onload="FP_preloadImgs(/*url*/'images/button3E.jpg',/*url*/'images/button3D.jpg')">
<table cellpadding="0" cellspacing="0" border="0"  align="center">
	<tr>	
	  <td valign="top" width="766" height="700">
	  	<table cellpadding="0" cellspacing="0" border="0">
			<tr>
				<td valign="top" width="766" height="158" style="background-image:url(images/top.jpg) ">
					<table cellpadding="0" cellspacing="0" border="0">
						<tr>
							<td valign="top" width="766" height="158" style="background:url(images/7_bg1.gif) no-repeat bottom ">
								<div  style="margin:0 0 0 15px " class="s"><object align="left" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="736" height="158">
    <param name="movie" value="flash/Menu.swf?button=0">
    <param name="quality" value="high">
    <param name="menu" value="false">
    </object>
    <!--[if !IE]> <!-->
   <object data="flash/Menu.swf?button=0"
            width="736" height="158" type="application/x-shockwave-flash"> 
     <param name="quality" value="high">
     <param name="menu" value="false">
     <param name="pluginurl" value="http://www.macromedia.com/go/getflashplayer">
     FAIL (the browser should render some flash content, not this).
    </object>
    <!--> <![endif]-->
  </object>										
</div>		
							</td>
						</tr>
					</table>
				</td>
			</tr>
			<tr>
				<td valign="top" width="766" height="7" style="background-image:url(images/7_bg.gif) "></td>
			</tr>
			<tr>
				<td valign="top" width="766" height="637" bgcolor="#093465">
					<table cellpadding="0" cellspacing="0" border="0">
						<tr>
							<td valign="top" width="2" height="637" bgcolor="#163F6E"></td>
							<td valign="top" width="13" height="637"></td>
							<td valign="top" width="737" height="637">
								<table cellpadding="0" cellspacing="0" border="0">
									<tr>
										<td valign="top" width="737" height="637">
											<table cellpadding="0" cellspacing="0" border="0">
															<tr>
																<td valign="top" width="737" height="5">
																	<table cellpadding="0" cellspacing="0" border="0">
																		<tr>
																			<td valign="top" width="5" height="5" style="background-image:url(images/1_q1.gif) "></td>
																			<td valign="top" width="727" height="5" style="background-image:url(images/1_li1.gif) "></td>
																			<td valign="top" width="5" height="5" style="background-image:url(images/1_q2.gif) "></td>
																		</tr>
																	</table>
																</td>
															</tr>
															<tr>
																<td valign="top" width="737" height="627">
																	<table cellpadding="0" cellspacing="0" border="0">
																		<tr>
																			<td valign="top" width="1" height="627" bgcolor="#FFFFFF"></td>
																			<td valign="top" width="735" height="627" bgcolor="#0083C3">
<div class="w1"  style=" margin:5 10 0 12px; line-height:12px "><img src="images/6_z1.gif" alt="" border="0" align="left" style="margin-right:6px "><br style="line-height:3px "><img src="images/7_w1.gif" style="margin-bottom:1px " alt="" border="0"><font size="3">Reviews</font><p align="right">
	<a href="reviewsedit.asp">
	<img border="0" id="img1" src="images/button3C.jpg" height="20" width="100" alt="Post Review" onmouseover="FP_swapImg(1,0,/*id*/'img1',/*url*/'images/button3D.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img1',/*url*/'images/button3C.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img1',/*url*/'images/button3E.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img1',/*url*/'images/button3D.jpg')" fp-style="fp-btn: Brick Row 1; fp-orig: 0" fp-title="Post Review" align="right"></a></p>
	<p> </p>
	<p> </p>
	<!--#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 Reviews WHERE NicknameID=::NicknameID::"
fp_sDefault="NicknameID="
fp_sNoRecords="No records returned."
fp_sDataConn="ReviewDatabase"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&NicknameID=3&Nickname=202&Title=202&DateArrived=3&Rating=202&RatingNumber=3&EmailAddress=202&EmailAddressConfirm=202&CityStateCountry=202&Comment=202&"
fp_iDisplayCols=37
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<table BORDER="1" width="565" bordercolorlight="#3E91CD" bordercolordark="#0000FF">
				<tr>
					<td width="180" align="left">
					<font face="Tahoma" size="2" color="#242424"><b>Nickname:</b></font></td>
					<td align="left"><%=FP_FieldVal(fp_rs,"Nickname")%></td>
				</tr>
				<tr>
					<td width="180" align="left">
					<font face="Tahoma" size="2" color="#242424"><b>Title:</b></font></td>
					<td align="left">
					<%=FP_FieldVal(fp_rs,"Title")%></td>
				</tr>
				<tr>
					<td width="180" align="left">
					<font face="Tahoma" size="2" color="#242424"><b>Date Arrived:</b></font></td>
					<td align="left">
					<%=FP_FieldVal(fp_rs,"DateArrived")%></td>
				</tr>
				<tr>
					<td width="180" align="left">
					<font face="Tahoma" size="2" color="#242424"><b>Rating:</b></font></td>
					<td align="left">
					<%=FP_FieldVal(fp_rs,"Rating")%></td>
				</tr>
				<tr>
					<td width="180" align="left">
					<font face="Tahoma" size="2" color="#242424"><b>Rating Number:</b></font></td>
					<td align="left">
					<%=FP_FieldVal(fp_rs,"RatingNumber")%></td>
				</tr>
				<tr>
					<td width="180" align="left">
					<font face="Tahoma" size="2" color="#242424"><b>Email Address:</b></font></td>
					<td align="left">
					<%=FP_FieldVal(fp_rs,"EmailAddress")%></td>
				</tr>
				<tr>
					<td width="180" align="left">
					<font face="Tahoma" size="2" color="#242424"><b>Email Address Confirm:</b></font></td>
					<td align="left">
					<%=FP_FieldVal(fp_rs,"EmailAddressConfirm")%></td>
				</tr>
				<tr>
					<td width="180" align="left">
					<font face="Tahoma" size="2" color="#242424"><b>City, State, Country:</b></font></td>
					<td align="left">
					<%=FP_FieldVal(fp_rs,"CityStateCountry")%></td>
				</tr>
				<tr>
					<td width="180" align="left">
					<font face="Tahoma" size="2" color="#242424"><b>Comment:</b></font></td>
					<td align="left">
					<%=FP_FieldVal(fp_rs,"Comment")%></td>
				</tr>
				</table>
			<!--#include file="_fpclass/fpdbrgn2.inc"--></p>
	<p><br>
</div>
																			</td>
																			<td valign="top" width="1" height="627" bgcolor="#FFFFFF"></td>
																		</tr>
																	</table>
																</td>
															</tr>
															<tr>
																<td valign="top" width="737" height="5">
																	<table cellpadding="0" cellspacing="0" border="0">
																		<tr>
																			<td valign="top" width="5" height="5" style="background-image:url(images/1_q4.gif) "></td>
																			<td valign="top" width="727" height="5" style="background-image:url(images/1_li2.gif) "></td>
																			<td valign="top" width="5" height="5" style="background-image:url(images/1_q3.gif) "></td>
																		</tr>
																	</table>
																</td>
															</tr>
										  </table>
										</td>
									</tr>
								</table>
							</td>
							<td valign="top" width="13" height="637"></td>
							<td valign="top" width="2" height="637" bgcolor="#163F6E"></td>
						</tr>
					</table>
				</td>
			</tr>
			<tr>
				<td valign="top" width="766" height="72">
					<table cellpadding="0" cellspacing="0" border="0" id="table1">
						<tr>
							<td valign="top" width="24" height="72" style="background-image:url(images/q1.gif) "></td>
							<td valign="top" width="720" height="72" style="background-image:url(images/li1.gif) ">
								<div  style="margin:27 0 0 6px " class="w">
									<img alt="" src="images/spacer.gif" width="40px" height="1px"><strong>Copyright©2008<br>
									Baker Investment Properties</strong><img alt="" src="images/spacer.gif" width="40px" height="1px"><a href="index.html" class="w">Home</a>  |  
									<a href="stcroix.html" class="w">St.Croix</a>  |  
									<a href="condofeatures.html" class="w">Condo 
									Features</a>  |  
									<a href="reservations.asp" class="w">Condo Reservations</a>  |  <a href="car_rental.html" class="w">Car Rental</a>  |  
									<a class="w" href="contactus.html">Contact Us</a>  |  
									<a class="w" href="reviews.asp">
									Privacy</a></div>
							</td>
							<td valign="top" width="22" height="72" style="background-image:url(images/q2.gif) "></td>
						</tr>
					</table>
				</td>
			</tr>
			<tr>
				<td valign="top" width="766" height="78"></td>
			</tr>
		</table>
	  </td>
	</tr>
</table>
</body>
</html>

Reviews edit page

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Language" content="en-us"> <title>Untitled</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <link href="style.css" rel="stylesheet" type="text/css"> </head> <body> <table cellpadding="0" cellspacing="0" border="0" align="center"> <tr> <td valign="top" width="766" height="700"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="766" height="158" style="background-image:url(images/top.jpg) "> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="766" height="158" style="background:url(images/7_bg1.gif) no-repeat bottom "> <div style="margin:0 0 0 15px " class="s"><object align="left" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="736" height="158"> <param name="movie" value="flash/Menu.swf?button=0"> <param name="quality" value="high"> <param name="menu" value="false"> </object>  <object data="flash/Menu.swf?button=0" width="736" height="158" type="application/x-shockwave-flash"> <param name="quality" value="high"> <param name="menu" value="false"> <param name="pluginurl" value="http://www.macromedia.com/go/getflashplayer"> FAIL (the browser should render some flash content, not this). </object>  </object> </div> </td> </tr> </table> </td> </tr> <tr> <td valign="top" width="766" height="7" style="background-image:url(images/7_bg.gif) "></td> </tr> <tr> <td valign="top" width="766" height="637" bgcolor="#093465"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="2" height="637" bgcolor="#163F6E"></td> <td valign="top" width="13" height="637"></td> <td valign="top" width="737" height="637"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="737" height="637"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="737" height="5"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="5" height="5" style="background-image:url(images/1_q1.gif) "></td> <td valign="top" width="727" height="5" style="background-image:url(images/1_li1.gif) "></td> <td valign="top" width="5" height="5" style="background-image:url(images/1_q2.gif) "></td> </tr> </table> </td> </tr> <tr> <td valign="top" width="737" height="627"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="1" height="627" bgcolor="#FFFFFF"></td> <td valign="top" width="735" height="627" bgcolor="#0083C3"> <div class="w1" style=" margin:5 10 0 12px; line-height:12px "><img src="images/6_z1.gif" alt="" border="0" align="left" style="margin-right:6px "><br style="line-height:3px "><img src="images/7_w1.gif" style="margin-bottom:1px " alt="" border="0"><font size="3">Review your stay with us</font><br> </div> <p><b><font face="Zurich BT" size="2" color="#093465"> </font></b> <p> <form method="POST" action="reviewsupdate.asp">  <% 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 Reviews WHERE NicknameID=::NicknameID::" fp_sDefault="Nickname=" fp_sNoRecords="No records returned." fp_sDataConn="ReviewDatabase" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_sColTypes="&NicknameID=3&Nickname=202&Title=202&DateArrived=3&Rating=202&RatingNumber=3&EmailAddress=202&EmailAddressConfirm=202&CityStateCountry=202&Comment=202&" fp_iDisplayCols=10 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %>  <table BORDER="0" width="461"> <tr> <td width="163"> <font face="Tahoma" size="2" color="#242424"><b>Nickname Name:</b></font></td> <td width="288"> <input NAME="Traveler1FirstName" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Nickname")%>" tabindex="1"></td> </tr> <tr> <td width="163"> <font face="Tahoma" size="2" color="#242424"><b>Title:</b></font></td> <td width="288"> <input NAME="Traveler1LastName" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Title")%>" tabindex="2"></td> </tr> <tr> <td width="163"> <font face="Tahoma" size="2" color="#242424"><b>Date Arrived:</b></font></td> <td width="288"> <input NAME="Traveler2FirstName" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"DateArrived")%>" tabindex="3"></td> </tr> <tr> <td width="163"> <font face="Tahoma" size="2" color="#242424"><b>Rating:</b></font></td> <td width="288"> <input NAME="Traveler2LastName" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Rating")%>" tabindex="4"></td> </tr> <tr> <td width="163"> <font face="Tahoma" size="2" color="#242424"><b>Rating Number:</b></font></td> <td width="288"> <input NAME="HomeAddress" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"RatingNumber")%>" tabindex="5"></td> </tr> <tr> <td width="163"> <font face="Tahoma" size="2" color="#242424"><b>Email Address:</b></font></td> <td width="288"> <input NAME="City" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"EmailAddress")%>" tabindex="6"></td> </tr> <tr> <td width="163"> <font face="Tahoma" size="2" color="#242424"><b>Email Address Confirm:</b></font></td> <td width="288"> <input NAME="StateOrProvince" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"EmailAddressConfirm")%>" tabindex="7"></td> </tr> <tr> <td width="163"> <font face="Tahoma" size="2" color="#242424"><b>City, State, Country:</b></font></td> <td width="288"> <input NAME="ZipCode" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"CityStateCountry")%>" tabindex="8"></td> </tr> <tr> <td width="163"> <font face="Tahoma" size="2" color="#242424"><b>Comment:</b></font></td> <td width="288"> <input NAME="HomePhone" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Comment")%>" tabindex="9"></td> </tr> <tr> <td COLSPAN="2"><font face="Tahoma"> <font size="2" color="#242424"><br> </font><font color="#242424"> <input TYPE="submit" NAME="fp_submit" value="Update"><input TYPE="Reset" NAME="fp_reset"></font></font></td> </tr> </table>  <p> </p> <input type="hidden" name="UserName" value="<%=Request("NicknameID")%>"> </form></td> <td valign="top" width="1" height="627" bgcolor="#FFFFFF"></td> </tr> </table> </td> </tr> <tr> <td valign="top" width="737" height="5"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="5" height="5" style="background-image:url(images/1_q4.gif) "></td> <td valign="top" width="727" height="5" style="background-image:url(images/1_li2.gif) "></td> <td valign="top" width="5" height="5" style="background-image:url(images/1_q3.gif) "></td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> <td valign="top" width="13" height="637"></td> <td valign="top" width="2" height="637" bgcolor="#163F6E"></td> </tr> </table> </td> </tr> <tr> <td valign="top" width="766" height="72"> <table cellpadding="0" cellspacing="0" border="0" id="table1"> <tr> <td valign="top" width="24" height="72" style="background-image:url(images/q1.gif) "></td> <td valign="top" width="720" height="72" style="background-image:url(images/li1.gif) "> <div style="margin:27 0 0 6px " class="w"> <img alt="" src="images/spacer.gif" width="40px" height="1px"><strong>Copyright©2008<br> Baker Investment Properties</strong><img alt="" src="images/spacer.gif" width="40px" height="1px"><a href="index.html" class="w">Home</a> | <a href="stcroix.html" class="w">St.Croix</a> | <a href="condofeatures.html" class="w">Condo Features</a> | <a href="reservations.asp" class="w">Condo Reservations</a> | <a href="car_rental.html" class="w">Car Rental</a> | <a class="w" href="contactus.html">Contact Us</a> | <a class="w" href="privacypolicy.html"> Privacy</a></div> </td> <td valign="top" width="22" height="72" style="background-image:url(images/q2.gif) "></td> </tr> </table> </td> </tr> <tr> <td valign="top" width="766" height="78"></td> </tr> </table> </td> </tr> </table> </body> </html>

Reviews update page

<% Const cdoSendUsingPickup = 1 'Send message using the local SMTP service pickup directory. Const cdoSendUsingPort = 2 'Send the message using the network (SMTP over the network). Const cdoAnonymous = 0 'Do not authenticate Const cdoBasic = 1 'basic (clear-text) authentication Const cdoNTLM = 2 'NTLM Set objMessage = Server.CreateObject("CDO.Message") objMessage.Subject = "User Updated Personal Information" objMessage.Sender = "info@i******.com" objMessage.From = "info@********.com" objMessage.To = "j*****@.com" objMessage.TextBody = "Island comments have just been updated" & vbCRLF & "It was sent using SMTP authentication." '==This section provides the configuration information for the remote SMTP server. objMessage.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'Name or IP of Remote SMTP Server objMessage.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "****.******condos.com" 'Type of authentication, NONE, Basic (Base64 encoded), NTLM objMessage.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoBasic 'Your UserID on the SMTP server objMessage.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendusername") = "****@*****condos.com" 'Your password on the SMTP server objMessage.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "l******" 'Server port (typically 25) objMessage.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 'Use SSL for the connection (False or True) objMessage.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = False 'Connection Timeout in seconds (the maximum time CDO will try to establish a connection to the SMTP server) objMessage.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60 objMessage.Configuration.Fields.Update objMessage.Send %> <html> <head> <meta http-equiv="Content-Language" content="en-us"> <title>Untitled</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <META HTTP-EQUIV="refresh" content="5;URL=reviews.asp"> <link href="style.css" rel="stylesheet" type="text/css"> </head> <body> <table cellpadding="0" cellspacing="0" border="0" align="center"> <tr> <td valign="top" width="766" height="700"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="766" height="158" style="background-image:url(images/top.jpg) "> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="766" height="158" style="background:url(images/7_bg1.gif) no-repeat bottom "> <div style="margin:0 0 0 15px " class="s"><object align="left" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="736" height="158"> <param name="movie" value="flash/Menu.swf?button=0"> <param name="quality" value="high"> <param name="menu" value="false">  </object> <object data="flash/Menu.swf?button=0" width="736" height="158" type="application/x-shockwave-flash"> <param name="quality" value="high"> <param name="menu" value="false"> <param name="pluginurl" value="http://www.macromedia.com/go/getflashplayer"> FAIL (the browser should render some flash content, not this). </object>  </object> </div> </td> </tr> </table> </td> </tr> <tr> <td valign="top" width="766" height="7" style="background-image:url(images/7_bg.gif) "></td> </tr> <tr> <td valign="top" width="766" height="637" bgcolor="#093465"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="2" height="637" bgcolor="#163F6E"></td> <td valign="top" width="13" height="637"></td> <td valign="top" width="737" height="637"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="737" height="637"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="737" height="5"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="5" height="5" style="background-image:url(images/1_q1.gif) "></td> <td valign="top" width="727" height="5" style="background-image:url(images/1_li1.gif) "></td> <td valign="top" width="5" height="5" style="background-image:url(images/1_q2.gif) "></td> </tr> </table> </td> </tr> <tr> <td valign="top" width="737" height="627"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="1" height="627" bgcolor="#FFFFFF"></td> <td valign="top" width="735" height="627" bgcolor="#0083C3"> <div class="w1" style=" margin:5 10 0 12px; line-height:12px "><img src="images/6_z1.gif" alt="" border="0" align="left" style="margin-right:6px "><br style="line-height:3px "><img src="images/7_w1.gif" style="margin-bottom:1px " alt="" border="0"><br> </div> <p><b><font face="Zurich BT" size="2" color="#093465"> </font></b>  <% 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="UPDATE Reviews SET Nickname = '::Nickname::', Title = '::Title::', DateArrived = '::DateArrived::', Rating = '::Rating::', RatingNumber = '::RatingNumber::', EmailAddress = '::EmailAddress::', EmailAddressConfirm = '::EmailAddressConfirm::', CityStateCountry = '::CityStateCountry::', Comment = '::Comment::' WHERE NicknameID=::NicknameID::" fp_sDefault="Nickname" fp_sNoRecords="Your Personal Travel Information Has Been Updated, Please wait a moment!" fp_sDataConn="ReviewDatabase" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_sColTypes="&NicknameID=3&Nickname=202&Title=202&DateArrived=3&Rating=202&RatingNumber=3&EmailAddress=202&EmailAddressConfirm=202&CityStateCountry=202&Comment=202&" fp_iDisplayCols=10 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %>  <table BORDER="1" width="585"> <tr> <td><b>Nickname:</b></td> <td> <%=FP_FieldVal(fp_rs,"Nickname")%></td> </tr> <tr> <td width="210"><b>Title:</b></td> <td> <%=FP_FieldVal(fp_rs,"Title")%></td> </tr> <tr> <td width="210"><b>DateArrived:</b></td> <td> <%=FP_FieldVal(fp_rs,"DateArrived")%></td> </tr> <tr> <td width="210"><b>Rating:</b></td> <td> <%=FP_FieldVal(fp_rs,"Rating")%></td> </tr> <tr> <td width="210"><b>Rating Number:</b></td> <td> <%=FP_FieldVal(fp_rs,"RatingNumber")%></td> </tr> <tr> <td width="210"><b>EmailAddress:</b></td> <td> <%=FP_FieldVal(fp_rs,"EmailAddress")%></td> </tr> <tr> <td width="210"><b>EmailAddressConfirm:</b></td> <td> <%=FP_FieldVal(fp_rs,"EmailAddressConfirm")%></td> </tr> <tr> <td width="210"><b>CityStateCountry:</b></td> <td> <%=FP_FieldVal(fp_rs,"CityStateCountry")%></td> </tr> </table>  <td valign="top" width="1" height="627" bgcolor="#FFFFFF"></td> </tr> </table> </td> </tr> <tr> <td valign="top" width="737" height="5"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="5" height="5" style="background-image:url(images/1_q4.gif) "></td> <td valign="top" width="727" height="5" style="background-image:url(images/1_li2.gif) "></td> <td valign="top" width="5" height="5" style="background-image:url(images/1_q3.gif) "></td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> <td valign="top" width="13" height="637"></td> <td valign="top" width="2" height="637" bgcolor="#163F6E"></td> </tr> </table> </td> </tr> <tr> <td valign="top" width="766" height="72"> <table cellpadding="0" cellspacing="0" border="0" id="table1"> <tr> <td valign="top" width="24" height="72" style="background-image:url(images/q1.gif) "></td> <td valign="top" width="720" height="72" style="background-image:url(images/li1.gif) "> <div style="margin:27 0 0 6px " class="w"> <img alt="" src="images/spacer.gif" width="40px" height="1px"><strong>Copyright©2008<br> Baker Investment Properties</strong><img alt="" src="images/spacer.gif" width="40px" height="1px"><a href="index.html" class="w">Home</a> | <a href="stcroix.html" class="w">St.Croix</a> | <a href="condofeatures.html" class="w">Condo Features</a> | <a href="reservations.asp" class="w">Condo Reservations</a> | <a href="car_rental.html" class="w">Car Rental</a> | <a class="w" href="contactus.html">Contact Us</a> | <a class="w" href="reviewsupdate.asp"> Privacy</a></div> </td> <td valign="top" width="22" height="72" style="background-image:url(images/q2.gif) "></td> </tr> </table> </td> </tr> <tr> <td valign="top" width="766" height="78"></td> </tr> </table> </td> </tr> </table> </body> </html>

BeTheBall -> RE: drw default values missing (5/26/2008 17:36:27)
How does one get from the results page to the edit page? I don't see a link whereby one can access an edit page for a specific record.

mjmtravel -> RE: drw default values missing (5/26/2008 18:24:43)
Duane There is a link just above the fp include line about 4 lines up. <a href="reviewsedit.asp">

BeTheBall -> RE: drw default values missing (5/26/2008 18:37:52)
I see that, but with that link being outside the DRW, how does the edit form know which record to bring up for editing? It would seem to me the link should be inside the DRW and include the ID of the record as part of the querystring. Something like: reviewsedit.asp?id=RecordID That would make it so clicking the link would bring up a particular record.

mjmtravel -> RE: drw default values missing (5/26/2008 19:00:58)
Duane Ok I have done that with this code. <!--#include file="_fpclass/fpdbrgn1.inc"--> <table BORDER="1" width="565" bordercolorlight="#3E91CD" bordercolordark="#0000FF"> <tr> <td width="180" align="left"> <b><font size="2"> <a href="reviewsedit.asp?NicknameID=NicknameID " style="text-decoration: none">Post a Review</a></font></b></td> <td align="left"> </td> </tr> <tr> <td width="180" align="left" height="18"> <font face="Tahoma" size="2" color="#242424"><b>Nickname:</b></font></td> <td align="left" height="18"><%=FP_FieldVal(fp_rs,"Nickname")%></td> But the table will not even load I still get this error. I also found my input names on the edit page didn't match so I fixed them. Same error. Database Results Wizard Error Description: Parameter ?_1 has no default value. Number: -2147217904 (0x80040E10) Source: Microsoft JET Database Engine One or more form fields were empty. You should provide default values for all form fields that are used in the query.

mjmtravel -> RE: drw default values missing (5/26/2008 19:28:50)
Duane Its kind of coming back to me now. On my other sites I did the spooky work around changing the fpclass files back to fp 2000. After doing that I now get a new error, much simpler I think. Its: Database Results Error Description: Syntax error (missing operator) in query expression 'NicknameID='. Number: -2147217900 (0x80040E14) Source: Microsoft JET Database Engine

BeTheBall -> RE: drw default values missing (5/26/2008 23:13:23)

Assuming the database field is named NicknameID, then this:

<td width="180" align="left">
<b><font size="2">
<a href="reviewsedit.asp?NicknameID=NicknameID " style="text-decoration: none">Post a Review</a></font></b></td>

needs to be:

<td width="180" align="left">
<b><font size="2">
<a href="reviewsedit.asp?NicknameID=<%=FP_FieldVal(fp_rs,"NicknameID")%>" style="text-decoration: none">Post a Review</a></font></b></td>

mjmtravel -> RE: drw default values missing (5/27/2008 19:32:55)
Duane I get this error now on all 3 pages. Description: Syntax error (missing operator) in query expression 'NicknameID ='. Number: -2147217900 (0x80040E14) Source: Microsoft JET Database Engine One or more form fields were empty. You should provide default values for all form fields that are used in the query. Here is my query again fp_sQry="SELECT * FROM Reviews WHERE NicknameID = ::NicknameID::" fp_sDefault="Nickname=" fp_sNoRecords="No records returned." fp_sDataConn="ReviewDatabase" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_sColTypes="&NicknameID=3&Nickname=202&Title=202&DateArrived=3&Rating=202&RatingNumber=3&EmailAddress=202&EmailAddressConfirm=202&CityStateCountry=202&Comment=202&" fp_iDisplayCols=37 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID

BeTheBall -> RE: drw default values missing (5/27/2008 20:27:19)
I think I may have misunderstood how this is working. How do users get to the results page? What does the page before the results page look like?

mjmtravel -> RE: drw default values missing (5/27/2008 20:47:32)
Duane I have a link set up to get to the results page from a reservations page. What this is, is a condo review database that customers who rent a particular condo can post a review on how they liked it etc. The link goes to the results page with everyones reviews and from there they can post their own review with the link we just created. Only problem is that I cannot open any of the form pages without the error above. I remembered the last time I did the 3 page form, that I actually had to change the fpclass files back to older versions, because we simply could not make the forms work. Once I did that it worked fine. So I did that last night and I think the only thing I'm missing now is a " or ' out of place on the query line. What do you think?

BeTheBall -> RE: drw default values missing (5/27/2008 23:36:10)
The problem is this. Your results page has a WHERE clause of WHERE NicknameID = ::NicknameID::. Therefore, the results page is expecting a NicknameID to be passed to it. The link on the Reservations page does not pass an ID.

mjmtravel -> RE: drw default values missing (5/28/2008 17:39:48)
Duane Yes I would like to see all of the reviews that are posted on the reviews or results page. Do I need to put a similar link to the page like above. <a href="reviews.asp?NicknameID=<%=FP_FieldVal(fp_rs,"NicknameID")%>"

BeTheBall -> RE: drw default values missing (5/28/2008 17:44:43)
No. If the results page should be unfiltered, then there should be no WHERE clause. In other words, the SQL for the Results page should be simply: fp_sQry="SELECT * FROM Reviews"

mjmtravel -> RE: drw default values missing (5/28/2008 20:24:17)
Duane I sure don't know where my head was or what I was thinking. You were correct all along. I didn't even need the 3 page set up. I just put your code in to post the results and I made a new form to ad information to the database and perfecto. I must have been on another planet. One last question and I'll leave you alone for awhile. Is there a easy way to post, say 10 reviews or results and then go to another page for the next 10 and so on, or should I just let them scroll? Thanks again for all your help. I really enjoy this forum. Jeff

BeTheBall -> RE: drw default values missing (5/28/2008 23:53:00)
The number of records can be set in the red line below: <% fp_sQry="SELECT * FROM Reviews" fp_sDefault="" fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">No records returned.</td></tr>" fp_sDataConn="Music" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_iDisplayCols=7 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %> Change the 0 to 10 to display 10 records per page

mjmtravel -> RE: drw default values missing (5/29/2008 19:02:53)
Thanks for all your help that will work great.

Page: [1]

0.171875