|
| |
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
 |
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: drw default values missing - 5/24/2008 21:55:11
Post the SQL for the page that is throwing the error.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
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>
< Message edited by BeTheBall -- 5/25/2008 10:49:31 >
| |
|
|
|
BeTheBall
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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
%>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
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
Posts: 233
Joined: 7/30/2006
Status: offline
|
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
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>
<!--[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">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">
<!--#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="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
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<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>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
<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">
<!--[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::', 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
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<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>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
<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>
< Message edited by mjmtravel -- 5/26/2008 15:31:50 >
| |
|
|
|
BeTheBall
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
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
Posts: 233
Joined: 7/30/2006
Status: offline
|
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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"
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mjmtravel
Posts: 233
Joined: 7/30/2006
Status: offline
|
RE: drw default values missing - 5/29/2008 19:02:53
Thanks for all your help that will work great.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
