OutFront Forums
     Home    Register     Search      Help      Login    

Follow Us
On Facebook
On Twitter
RSS
Via Email

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
 

Hyperlink in drw with parameters

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP, PHP, and Database >> Hyperlink in drw with parameters 		Page: [1]
 
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		Hyperlink in drw with parameters - 4/12/2009 20:26:00   
I have a drw with 3 drop down boxes that shows results for 1 of the 3 selections that works fine. In the results page I have many results that come up, each result has a hyperlink in it going to another page.

What I'm trying to do is use that hyperlink to carry the PropertyID to the next page and show a larger breakdown of the result. I want to use the same page and just change the query in the hyperlink. Everything is working except the link. Here is what I have. Any ideas on this one would be greatful. I think I'm close.

<a href="propertydescription.asp?PropertyID=<%=Request.Querystring("PropertyID")%>">More Details</a>

I have tried different variations but to no avail. This is the error I get.
Database Results Wizard Error
The database connection named 'properties' is undefined.

This problem can occur if:
* the connection has been removed from the web
* the file 'global.asa' is missing or contains errors
* the root folder does not have Scripting permissions enabled
* the web is not marked as an Application Root

Here is my code on the linked page where I want the larger result to show. 

<%
fp_sQry="SELECT * FROM Properties WHERE PropertyID = ::PropertyID::"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="properties"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&PropertyID=202&UserName=202&IslandName=202&Photograph=202&PropertyType=202&PropertyTitle=202&Bedrooms_numbers=202&Bathroom_Numbers=202&Feature1=202&Feature2=202&PriceRangeNightly=202&PriceRangeWeekly=202&Description=203&SquareFT=202&Details=202&Amenity1=202&Amenity2=202&Amenity3=202&Amenity4=202&Amenity5=202&Amenity6=202&
fp_iDisplayCols=122
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>



< Message edited by Spooky -- 4/14/2009 1:50:40 >
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/15/2009 9:20:26   
Ok, I fixed the error, for some reason the name of my database changed in my query. I fixed that and now I get the no records returned. So I think something is still wrong with my code. It doesn't seem to be pulling my propertyID when clicking on the link in the drw still.

I have also tried this.
<a href="propertydescription.asp?PropertyID=<%=Request.Querystring("PropertyID")%>

Thanks, sorry for the other blunder.

(in reply to mjmtravel)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/16/2009 20:00:20   
Why are you using Request.Querystring? That implies that the propertyID was passed from the previous page. I would think the link should look something like this:

<a href="propertydescription.asp?PropertyID=<%=FP_FieldVal(fp_rs,"PropertyID")%>">More Details</a>

_____________________________

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.

(in reply to mjmtravel)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/18/2009 19:06:19   
No luck either, I have tried this both ways and still get no records found.

<a href="propertydescription.asp?PropertyID=<%=FP_FieldVal(fp_rs,"PropertyID")%>">More Details</a>
<a href="propertydescription.asp?PropertyID=<%=FP_FieldVal(fp_rs,"PropertyID")%>More Details</a>

The page switches but nothing is coming over with it.

(in reply to BeTheBall)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/18/2009 22:03:39   
Can you provide a link to the page in question?

_____________________________

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.

(in reply to mjmtravel)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 0:31:43   
Put the contents of the href property in single quotes like this:

<a href='propertydescription.asp?PropertyID=<%=FP_FieldVal(fp_rs,"PropertyID")%>'>More Details</a>

_____________________________

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.

(in reply to BeTheBall)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 10:12:02   
Duane
Its getting closer, at least I see the whole link in the address bar now but I still get the no records. I'm pretty sure I have the display page (propertydescription.asp) set up correctly?

I'm double checking some things on that page, but otherwise not sure why?

(in reply to BeTheBall)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 10:55:26   
Does this work:

<a href='propertydescription.asp?PropertyID='<%=FP_FieldVal(fp_rs,"PropertyID")%>>More Details</a>

Sorry if it seems like I am guessing a bit. I haven't used the DRW for a while.

_____________________________

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.

(in reply to mjmtravel)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 11:32:28   
Duane
Nope, sorry that doesn't work either. I think I'm getting to old for this.

(in reply to BeTheBall)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 11:35:58   
Can you post the code for the 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.

(in reply to mjmtravel)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 15:17:10   
Duane

Here it is. Its quite large with a lot of fields. This is the propertydescription.asp 

<html>
<head>
<title>Property Description</title>
<meta http-equiv="Content-Style-Type" content="text/css">
<meta name="robots" content="noindex,nofollow">
<LINK HREF="style.css" TYPE="text/css" REL="stylesheet"></head>

<body bgcolor="#D6C5BA">
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td> </td>
    <td width="766" align="left" valign="top"><table width="766"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td align="left" valign="top"> </td>
      </tr>
      <tr>
        <td align="left" valign="top">
		<table width="100%"  border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
          <tr align="left" valign="top">
            <td width="18"><img src="images/spacer.gif" width="18" height="1"></td>
            <td width="729"><table width="729"  border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td height="2" align="left" valign="top"><img src="images/top_left.jpg" width="729" height="2"></td>
              </tr>
              <tr>
                <td align="left" valign="top" background="images/line_4.jpg">
				<div style="padding-left:0px; padding-top:15px">
					 </div>
																<table border="0" width="100%" id="table1" style="border-collapse: collapse">
																	<tr>
																		<td>
<!--#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 Properties WHERE PropertyID = ::PropertyID::"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&PropertyID=202&UserName=202&IslandName=202&Photograph=202&PropertyType=202&PropertyTitle=202&Bedrooms_numbers=202&Bathroom_Numbers=202&Feature1=202&Feature2=202&PriceRangeNightly=202&PriceRangeWeekly=202&Description=203&SquareFT=202&Details=202&Amenity1=202&Amenity2=202&Amenity3=202&Amenity4=202&Amenity5=202&Amenity6=202&Amenity7=202&Amenity8=202&Amenity9=202&Kitchen1=202&Kitchen2=202&Kitchen3=202&Kitchen4=202&Kitchen5=202&Kitchen6=202&Kitchen7=202&Kitchen8=202&Kitchen9=202&Kitchen10=202&DiningRoom=202&DiningRoomSeats=202&Bedroom1=202&BedType1=202&Bedroom1Option1=202&Bedroom1Option2=202&Bedroom2=202&BedType2=202&Bedroom2Option1=202&Bedroom2Option2=202&Bedroom3=202&BedType3=202&Bedroom3Option1=202&Bedroom3Option2=202&Bedroom4=202&BedType4=202&Bedroom4Option1=202&Bedroom4Option2=202&Bedroom5=202&BedType5=202&Bedroom5Option1=202&Bedroom5Option2=202&Bedroom6=202&BedType6=202&Bedroom6Option1=202&Bedroom6Option2=202&Notes=202&Bathroom1=202&BathroomT1=202&Bathroom1Option1=202&Bathroom1Option2=202&Bathroom2=202&BathroomT2=202&Bathroom2Option1=202&Bathroom2Option2=202&Bathroom3=202&BathroomT3=202&Bathroom3Option1=202&Bathroom3Option2=202&Bathroom4=202&BathroomT4=202&Bathroom4Option1=202&Bathroom4Option2=202&Notes2=202&SwimmingPool=202&Media=202&Media5=202&Media0=202&Media6=202&Media1=202&Media7=202&Media2=202&Media8=202&Media3=202&Media9=202&Media4=202&Media10=202&Exterior=202&Exterior4=202&Exterior0=202&Exterior5=202&Exterior1=202&Exterior6=202&Exterior2=202&Exterior7=202&Exterior3=202&Exterior8=202&Activities=202&Activities4=202&Activities0=202&Activities5=202&Activities1=202&Activities6=202&Activities2=202&Activities7=202&Activities3=202&Activities8=202&Activities9=202&Activities10=202&HSbeginDates=202&LSbeginDates=202&HSendDates=202&LSendDates=202&HSweeklyRate=202&LSweeklyRate=202&HSnightlyRate=202&LSnightlyRate=202&HSminimumStay=202&LSminimumStay=202&ClothingOptional=202&Remote_computer_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=122
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<table BORDER="0" width="721" style="border-collapse: collapse">
<tr>
<td width="235" height="25"><img alt="" src="images/spacer.gif" width="35px" height="1px"><font face="Tahoma" size="2" color="#0000FF"><b><%=FP_FieldVal(fp_rs,"IslandName")%></b><img alt="" src="images/spacer.gif" width="35px" height="1px"></font></td>
<td width="507" height="25" colspan="2"><font face="Tahoma" size="3" color="#00FF00"><%=FP_FieldVal(fp_rs,"PropertyTitle")%></font></td>
</tr>
<tr>
<td colspan="3" height="92">
<div align="center">
<table border="0" width="80%" id="table3" style="border-collapse: collapse" height="44">
<tr>
<td width="282" height="25"><font face="Tahoma" size="2" color="#0000FF">
<% 

if Replace(FP_FieldVal(fp_rs,"Bedrooms_numbers")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Bedrooms_numbers") & "</li>" 

End If 

%></font></td>
<td height="15"><font face="Tahoma" size="2" color="#0000FF">
<% 

if Replace(FP_FieldVal(fp_rs,"Feature1")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Feature1") & "</li>" 

End If 

%></font></td>
</tr>
<tr>
<td width="282" height="25"><font face="Tahoma" size="2" color="#0000FF">
<% 

if Replace(FP_FieldVal(fp_rs,"Bathroom_Numbers")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Bathroom_Numbers") & "</li>" 

End If 

%></font></td>
<td height="15"><font face="Tahoma" size="2" color="#0000FF">
<% 

if Replace(FP_FieldVal(fp_rs,"Feature2")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Feature2") & "</li>" 

End If 

%></font></td>
		</tr>
		<tr>
<td width="282" height="25"><font face="Tahoma" size="2" color="#0000FF">
<% 

if Replace(FP_FieldVal(fp_rs,"PriceRangeNightly")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"PriceRangeNightly") & "</li>" 

End If 

%></font></td>
<td height="15"><font face="Tahoma" size="2" color="#0000FF">
<% 

if Replace(FP_FieldVal(fp_rs,"PriceRangeWeekly")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"PriceRangeWeekly") & "</li>" 

End If 

%></font></td>
</tr>
</table>
<table border="0" width="92%" id="table8" style="border-collapse: collapse">
<tr>
<td width="123"> </td>
<td> </td>
</tr>
<tr>
<td width="123"><font face="Tahoma" size="2" color="#008000">Property Type:</font></td>
<td><font face="Tahoma" size="2" color="#0000FF"><%=FP_FieldVal(fp_rs,"PropertyType")%></font></td>
</tr>
<tr>
<td height="10"></td>
<td height="10"></td>
</tr>
<tr>
<td width="123" valign="top"><font face="Tahoma" size="2" color="#008000">Property Description:</font></td>
<td><font face="Tahoma" size="2" color="#0000FF"><%=FP_FieldVal(fp_rs,"Description")%></font></td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td colspan="3" height="26">
<p align="center"><b><font face="Tahoma" size="2" color="#FFFFFF">Photo Gallery</font></b></td>
</tr>
<tr>
																							<td colspan="3">
																							<p align="center">
	<object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" id="obj1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" border="0" width="666" height="492">
		<param name="movie" value="flash/stcroix.swf">
		<param name="quality" value="High">
		<embed src="flash/stcroix.swf" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj1" width="666" height="492" quality="High"></object>
																							</td>
																						</tr>
																						<tr>
																							<td width="235" height="25"> </td>
																							<td width="507" colspan="2" height="25"> </td>
																						</tr>
																						<tr>
																							<td width="717" height="58" colspan="3">
																							<p align="center"><font face="Tahoma" size="2" color="#242424">To book this property please pick the open arrival date, then the open departing date.<br>
																							Check below the calendar for the dates you chose and  instantly book your condo vacation<br>
																							or click cancel to start over<br>
</font></td>
																						</tr>
																						<tr>
																							<td width="235" align="center" height="40">
																							<p align="center"><font face="Tahoma" color="#CEE7FF" size="2"><img border="0" src="images/Untitled-1.png" width="19" height="19"> </font><font face="Tahoma" size="2" color="#FFFFFF">Booked</font></td>
																							<td width="254" height="40" align="center">
																							<p align="center"><img border="0" src="images/Untitled-3.png" width="19" height="19"><font face="Tahoma" size="2" color="#FFFFFF"> Pending</font></td>
																							<td width="257" height="40" align="center">
																							<p align="center"><img border="0" src="images/Untitled-2.png" width="19" height="19"><font face="Tahoma" size="2" color="#FFFFFF"> Open</font></td>
																						</tr>
																						<tr>
																							<td width="235">
																							<p align="center"><font color="#FFFFFF" face="Tahoma" size="2">Previous</font></td>
																							<td width="254"> </td>
																							<td width="257">
																							<p align="center"><font face="Tahoma" size="2" color="#FFFFFF">Next</font></td>
																						</tr>
																						<tr>
																							<td colspan="3" height="109" align="center" style="color: #FFFFFF">
																							<p align="center"><script language="javascript" src="/calendar_script/load.php?view=2&cid=2"></script></script></td>
																						</tr>
																						<tr>
																							<td width="235" align="right" height="39"> </td>
																							<td width="507" colspan="2" height="39"> </td>
																						</tr>
																						<tr>
																							<td width="742" align="right" height="39" colspan="3">
																							<div align="center">
																								<table border="1" width="94%" id="table9" bgcolor="#FFFFFF" style="border-collapse: collapse" bordercolor="#0083C3">
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40"><font face="Tahoma" size="2">Square Feet</font></td>
																										<td height="40" colspan="4"><font face="Tahoma" size="2"><img alt="" src="images/spacer.gif" width="30px" height="1px"><%=FP_FieldVal(fp_rs,"SquareFT")%></font></td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40"><font face="Tahoma" size="2">Dining Room</font></td>
																										<td height="40" colspan="4"><font face="Tahoma" size="2"><img alt="" src="images/spacer.gif" width="30px" height="1px"><%=FP_FieldVal(fp_rs,"DiningRoom")%></font></td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40"><font face="Tahoma" size="2">Dining Room Seats</font></td>
																										<td height="40" colspan="4"><font face="Tahoma" size="2"><img alt="" src="images/spacer.gif" width="30px" height="1px"><%=FP_FieldVal(fp_rs,"DiningRoomSeats")%></font></td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40"><font face="Tahoma" size="2">Swimming Pool</font></td>
																										<td height="40" colspan="4"><font face="Tahoma" size="2"><img alt="" src="images/spacer.gif" width="30px" height="1px"><%=FP_FieldVal(fp_rs,"SwimmingPool")%></font></td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40"><font face="Tahoma" size="2">Clothing Optional Property</font></td>
																										<td height="40" colspan="4"><font face="Tahoma" size="2"><img alt="" src="images/spacer.gif" width="30px" height="1px"><%=FP_FieldVal(fp_rs,"ClothingOptional")%></font></td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40"><font face="Tahoma" size="2">Pets Allowed</font></td>
																										<td colspan="4" height="40" style="font-family: Tahoma; font-size: 10pt"><img alt="" src="images/spacer.gif" width="30px" height="1px"><%=FP_FieldVal(fp_rs,"Notes2")%></td>
    </tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40"><font face="Tahoma" size="2">Basic Amenities</font></td>
																										<td colspan="4" height="40" style="font-family: Tahoma; font-size: 10pt">
<font face="Tahoma" size="2">
<% 

if Replace(FP_FieldVal(fp_rs,"Amenity1")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Amenity1") & "</li>" 

End If 

%></font>
<font face="Tahoma" size="2">
<% 

if Replace(FP_FieldVal(fp_rs,"Amenity2")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Amenity2") & "</li>" 

End If 

%></font>
<font face="Tahoma" size="2">
<% 

if Replace(FP_FieldVal(fp_rs,"Amenity3")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Amenity3") & "</li>" 

End If 

%></font>
<font face="Tahoma" size="2">
<% 

if Replace(FP_FieldVal(fp_rs,"Amenity4")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Amenity4") & "</li>" 

End If 

%></font>
<font face="Tahoma" size="2">
<% 

if Replace(FP_FieldVal(fp_rs,"Amenity5")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Amenity5") & "</li>" 

End If 

%></font>
<font face="Tahoma" size="2">
<% 

if Replace(FP_FieldVal(fp_rs,"Amenity6")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Amenity6") & "</li>" 

End If 

%></font>
<font face="Tahoma" size="2">
<% 

if Replace(FP_FieldVal(fp_rs,"Amenity7")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Amenity7") & "</li>" 

End If 

%></font>
<font face="Tahoma" size="2">
<% 

if Replace(FP_FieldVal(fp_rs,"Amenity8")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Amenity8") & "</li>" 

End If 

%></font>
<font face="Tahoma" size="2">
<% 

if Replace(FP_FieldVal(fp_rs,"Amenity9")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Amenity9") & "</li>" 

End If 

%></font>
	</td>
    </tr>
	<tr>
	<td width="24%" bgcolor="#CEE7FF" align="center" height="40">
	<font face="Tahoma" size="2">Kitchen</font></td>
	<td colspan="4" height="40" style="font-family: Tahoma; font-size: 10pt">
<% 

if Replace(FP_FieldVal(fp_rs,"Kitchen1")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Kitchen1") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Kitchen2")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Kitchen2") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Kitchen3")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Kitchen3") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Kitchen4")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Kitchen4") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Kitchen5")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Kitchen5") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Kitchen6")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Kitchen6") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Kitchen7")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Kitchen7") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Kitchen8")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Kitchen8") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Kitchen9")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Kitchen9") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Kitchen10")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Kitchen10") & "</li>" 

End If 

%>
</td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="190" rowspan="7"><font face="Tahoma" size="2">Bedrooms</font></td>
																										<td width="18%" height="40">
																										<p align="center">Bedroom No.</td>
																										<td width="15%" height="40">
																										<p align="center">Bed Type</td>
																										<td width="20%" height="40">
																										<p align="center">Feature 1</td>
																										<td width="22%" height="40">
																										<p align="center">Feature 2</td>
																									</tr>
																									<tr>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"BedType1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom1Option1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom1Option2")%></td>
																									</tr>
																									<tr>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom2")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"BedType2")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom2Option1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom2Option2")%></td>
																									</tr>
																									<tr>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom3")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"BedType3")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom3Option1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom3Option2")%></td>
																									</tr>
																									<tr>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom4")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"BedType4")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom4Option1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom4Option2")%></td>
																									</tr>
																									<tr>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom5")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"BedType5")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom5Option1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom5Option2")%></td>
																									</tr>
																									<tr>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom6")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"BedType6")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom6Option1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bedroom6Option2")%></td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40">
																										<p align="right"><b><font face="Tahoma" size="1">Bedroom Notes</font></b></td>
																										<td colspan="4" height="40"><%=FP_FieldVal(fp_rs,"Notes")%></td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="140" rowspan="5"><font face="Tahoma" size="2">Bathrooms</font></td>
																										<td height="40">
																										<p align="center">Bathroom No.</td>
																										<td height="40">
																										<p align="center">Lavatory</td>
																										<td height="40">
																										<p align="center">Feature 1</td>
																										<td height="40">
																										<p align="center">Feature 2</td>
																									</tr>
																									<tr>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"BathroomT1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom1Option1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom1Option2")%></td>
																									</tr>
																									<tr>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom2")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"BathroomT2")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom2Option1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom2Option2")%></td>
																									</tr>
																									<tr>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom3")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"BathroomT3")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom3Option1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom3Option2")%></td>
																									</tr>
																									<tr>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom4")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"BathroomT4")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom4Option1")%></td>
																										<td height="25" align="center"><%=FP_FieldVal(fp_rs,"Bathroom4Option2")%></td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40"><font face="Tahoma" size="2">Media</font></td>
																										<td colspan="4" height="40" style="font-family: Tahoma; font-size: 10pt">
<% 

if Replace(FP_FieldVal(fp_rs,"Media")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Media0")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media0") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Media1")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media1") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Media2")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media2") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Media3")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media3") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Media4")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media4") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Media5")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media5") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Media6")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media6") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Media7")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media7") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Media8")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media8") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Media10")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Media10") & "</li>" 

End If 

%>
</td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40"><font face="Tahoma" size="2">Exterior</font></td>
																										<td colspan="4" height="40" style="font-family: Tahoma; font-size: 10pt">
<% 

if Replace(FP_FieldVal(fp_rs,"Exterior")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Exterior") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Exterior0")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Exterior0") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Exterior1")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Exterior1") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Exterior2")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Exterior2") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Exterior3")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Exterior3") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Exterior4")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Exterior4") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Exterior5")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Exterior5") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Exterior6")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Exterior6") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Exterior7")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Exterior7") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Exterior8")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Exterior8") & "</li>" 

End If 

%>
</td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40"><font face="Tahoma" size="2">Nearby Activities</font></td>
																										<td colspan="4" height="40" style="font-family: Tahoma; font-size: 10pt">
<% 

if Replace(FP_FieldVal(fp_rs,"Activities")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities0")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities0") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities1")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities1") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities2")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities2") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities3")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities3") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities4")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities4") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities5")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities5") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities6")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities6") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities7")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities7") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities8")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities8") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities9")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities9") & "</li>" 

End If 

%>
<% 

if Replace(FP_FieldVal(fp_rs,"Activities10")," ", "")<>"" Then 

Response.write "<li>" & FP_FieldVal(fp_rs,"Activities10") & "</li>" 

End If 

%>
</td>
																									</tr>
																									<tr>
																										<td width="24%" bgcolor="#CEE7FF" align="center" height="40" rowspan="10"><font face="Tahoma" size="2">Rates</font></td>
																										<td colspan="2" height="20"><font face="Tahoma" size="2">High Season Begin Dates:</font></td>
																										<td colspan="2" height="20"><%=FP_FieldVal(fp_rs,"HSbeginDates")%></td>
																									</tr>
																									<tr>
																										<td colspan="2" height="20"><font face="Tahoma" size="2">High Season End Dates:</font></td>
																										<td colspan="2" height="20"><%=FP_FieldVal(fp_rs,"HSendDates")%></td>
																									</tr>
																									<tr>
																										<td colspan="2" height="20"><font face="Tahoma" size="2">Low Season Begin Dates:</font></td>
																										<td colspan="2" height="20"><%=FP_FieldVal(fp_rs,"LSbeginDates")%></td>
																									</tr>
																									<tr>
																										<td colspan="2" height="20"><font face="Tahoma" size="2">Low Season End Dates:</font></td>
																										<td colspan="2" height="20"><%=FP_FieldVal(fp_rs,"LSendDates")%></td>
																									</tr>
																									<tr>
																										<td colspan="2" height="20"><font face="Tahoma" size="2">High Season Weekly Rate:</font></td>
																										<td colspan="2" height="20"><%=FP_FieldVal(fp_rs,"HSweeklyRate")%></td>
																									</tr>
																									<tr>
																										<td colspan="2" height="20"><font face="Tahoma" size="2">Low Season Weekly Rate:</font></td>
																										<td colspan="2" height="20"><%=FP_FieldVal(fp_rs,"LSweeklyRate")%></td>
																									</tr>
																									<tr>
																										<td colspan="2" height="20"><font face="Tahoma" size="2">High Season Nightly Rate:</font></td>
																										<td colspan="2" height="20"><%=FP_FieldVal(fp_rs,"HSnightlyRate")%></td>
																									</tr>
																									<tr>
																										<td colspan="2" height="20"><font face="Tahoma" size="2">Low Season Nightly Rate:</font></td>
																										<td colspan="2" height="20"><%=FP_FieldVal(fp_rs,"LSnightlyRate")%></td>
																									</tr>
																									<tr>
																										<td colspan="2" height="20"><font face="Tahoma" size="2">High Season Minimum Stay:</font></td>
																										<td colspan="2" height="20"><%=FP_FieldVal(fp_rs,"HSminimumStay")%></td>
																									</tr>
																									<tr>
																										<td colspan="2" height="20"><font face="Tahoma" size="2">Low Season Minimum Stay:</font></td>
																										<td colspan="2" height="20"><%=FP_FieldVal(fp_rs,"LSminimumStay")%></td>
																									</tr>
																									</table>
																							</div>
																							</td>
																						</tr>
																						<tr>
																							<td width="719" colspan="3" align="center" height="50"> </td>
																						</tr>
																						<tr>
																							<td width="719" colspan="3"><hr></td>
																						</tr>
																						<tr>
																							<td width="717" colspan="3" align="center" height="28"><font face="Tahoma" size="2" color="#FFFFFF">Property Owners Section Only<br>
</font></td>
																						</tr>
																						<tr>
																									<td width="235" height="18" align="center"><b><a style="text-decoration: none" href="propertydescriptionedit.asp?PropertyID=<%=FP_FieldVal(fp_rs,"PropertyID")%>"><font color="#FC770B" face="Tahoma" size="2">Edit Property</font></a></b></td>
																									<td width="238" height="18" align="center"><b><font face="Tahoma" size="2" color="#FFFF00"><a style="text-decoration: none" href="calendar_script/user.php"><font color="#FC770B">Edit Calendar</font></a></font></b></td>
																									<td width="0" height="18" align="center"><b><font face="Tahoma" size="2" color="#FFFF00"><a style="text-decoration: none" href="register.asp?UserUpdate=True"><font color="#FC770B">Update registration details</font></a></font></b></td>
																								</tr>
																						<tr>
																							<td width="235"> </td>
																							<td width="507" colspan="2"> </td>
																						</tr>
																						</table>
																					<!--#include file="_fpclass/fpdbrgn2.inc"-->
</td>
																	</tr>
				</table>
				</td>
              </tr>
              <tr>
                <td height="3" align="left" valign="top"><img src="images/line_5.jpg" width="729" height="3"></td>
              </tr>
            </table></td>
            <td width="19"><img src="images/spacer.gif" width="19" height="1"></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td height="47" align="left" valign="middle" background="images/bottom_1.jpg"><div align="center" style="padding-top:0px "><a href="propertydescription.asp" class="style13" style="text-decoration:none ">Copyright 2007-2008 © Travel 
			Buff.net. All rights reserved | Privacy Policy</a></div></td>
      </tr>
    </table></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td width="766" align="left" valign="top"> </td>
    <td> </td>
  </tr>
</table>
</body>
</html>


< Message edited by BeTheBall -- 4/19/2009 21:44:37 >

(in reply to BeTheBall)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 18:56:16    
<form method="POST" action="--WEBBOT-SELF--">
				<!--webbot bot="SaveResults" U-File="_private/form_results.csv" S-Format="TEXT/CSV" S-Label-Fields="TRUE" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--webbot bot="SaveResults" i-checksum="43374" endspan -->
				<p align="left"><nobr>
				<!--webbot bot="DatabaseRegionStart" s-columnnames="CaribbeanID,CaribbeanName,DestinationID" s-columntypes="3,202,3" s-dataconnection="Database2" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="CaribbeanName" s-menuvalue="CaribbeanID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Caribbean" s-displaycolumns="CaribbeanID,CaribbeanName" s-criteria s-order s-sql="SELECT * FROM Caribbean" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="1" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> " startspan --><!--#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 Caribbean"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="CaribbeanName"
fp_sMenuValue="CaribbeanID"
fp_sColTypes="&CaribbeanID=3&CaribbeanName=202&DestinationID=3&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="19306" --><span style="font-size: 11pt; font-weight: 700">Caribbean</span> 
				<select NAME="CaribbeanID" SIZE="1">
				<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62210" -->
				<option VALUE="<%=FP_FieldHTML(fp_rs,"CaribbeanID")%>"><%=FP_FieldHTML(fp_rs,"CaribbeanName")%>
				</option>
				<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn2.inc" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62218" -->
				</select> 
				<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " startspan --><!--webbot bot="DatabaseRegionEnd" endspan --><!--webbot bot="DatabaseRegionStart" s-columnnames="StateID,StateName,DestinationID" s-columntypes="3,202,3" s-dataconnection="Database2" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="StateName" s-menuvalue="StateID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="UnitedStates" s-displaycolumns="StateID,StateName" s-criteria s-order s-sql="SELECT * FROM UnitedStates" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="2" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> " startspan --><!--#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 UnitedStates"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="StateName"
fp_sMenuValue="StateID"
fp_sColTypes="&StateID=3&StateName=202&DestinationID=3&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="17582" --><span style="font-size: 11pt; font-weight: 700">USA
				</span> <select NAME="StateID" SIZE="1">
				<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62210" -->
				<option VALUE="<%=FP_FieldHTML(fp_rs,"StateID")%>"><%=FP_FieldHTML(fp_rs,"StateName")%>
				</option>
				<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn2.inc" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62218" -->
				</select> 
				<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " startspan --><!--webbot bot="DatabaseRegionEnd" endspan --><!--webbot bot="DatabaseRegionStart" s-columnnames="CountryID,CountryName,DestinationID" s-columntypes="3,202,3" s-dataconnection="Database2" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="CountryName" s-menuvalue="CountryID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="World" s-displaycolumns="CountryID,CountryName" s-criteria s-order s-sql="SELECT * FROM World" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="3" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> " startspan --><!--#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 World"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="CountryName"
fp_sMenuValue="CountryID"
fp_sColTypes="&CountryID=3&CountryName=202&DestinationID=3&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=3
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="7442" --><span style="font-size: 11pt; font-weight: 700">World
				</span> <select NAME="CountryID" SIZE="1">
				<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62210" -->
				<option VALUE="<%=FP_FieldHTML(fp_rs,"CountryID")%>"><%=FP_FieldHTML(fp_rs,"CountryName")%>
				</option>
				<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn2.inc" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62218" -->
				</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " startspan --><!--webbot bot="DatabaseRegionEnd" endspan --></nobr></p>
				<p><input type="submit" value="Search" name="B1"></p>
			</form>
			</td>
            <td width="4"> </td>
          </tr>
          <tr align="left" valign="top">
            <td width="18" height="287"><img src="images/spacer.gif" width="18" height="1"></td>
<td width="19" height="287"><img src="images/spacer.gif" width="19" height="1"><table border="1" width="60%" id="table1">
	<tr>
		<td>
		<!--webbot bot="DatabaseRegionStart" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-columntypes="3,202,3,202,3,202,3,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,135" s-dataconnection="Database2" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="5" b-makeform="FALSE" s-recordsource="Properties" s-displaycolumns="PropertyID,CaribbeanName,StateName,CountryName,Photograph,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Details,SwimmingPool" s-criteria="{CaribbeanID} EQ {CaribbeanID} | {StateID} EQ {StateID} | {CountryID} EQ {CountryID} |" s-order s-sql="SELECT * FROM Properties WHERE (CaribbeanID =  ::CaribbeanID:: OR StateID =  ::StateID:: OR CountryID =  ::CountryID::)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="CaribbeanID=0&StateID=0&CountryID=0" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" startspan --><!--#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 Properties WHERE (CaribbeanID =  ::CaribbeanID:: OR StateID =  ::StateID:: OR CountryID =  ::CountryID::)"
fp_sDefault="CaribbeanID=0&StateID=0&CountryID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&PropertyID=3&UserName=202&CaribbeanID=3&CaribbeanName=202&StateID=3&StateName=202&CountryID=3&CountryName=202&Photograph=202&PropertyType=202&PropertyTitle=202&Bedrooms_numbers=202&Bathroom_Numbers=202&Feature1=202&Feature2=202&PriceRangeNightly=202&PriceRangeWeekly=202&Description=203&SquareFT=202&Details=202&Amenity1=202&Amenity2=202&Amenity3=202&Amenity4=202&Amenity5=202&Amenity6=202&Amenity7=202&Amenity8=202&Amenity9=202&Kitchen1=202&Kitchen2=202&Kitchen3=202&Kitchen4=202&Kitchen5=202&Kitchen6=202&Kitchen7=202&Kitchen8=202&Kitchen9=202&Kitchen10=202&DiningRoom=202&DiningRoomSeats=202&Bedroom1=202&BedType1=202&Bedroom1Option1=202&Bedroom1Option2=202&Bedroom2=202&BedType2=202&Bedroom2Option1=202&Bedroom2Option2=202&Bedroom3=202&BedType3=202&Bedroom3Option1=202&Bedroom3Option2=202&Bedroom4=202&BedType4=202&Bedroom4Option1=202&Bedroom4Option2=202&Bedroom5=202&BedType5=202&Bedroom5Option1=202&Bedroom5Option2=202&Bedroom6=202&BedType6=202&Bedroom6Option1=202&Bedroom6Option2=202&Notes=202&Bathroom1=202&BathroomT1=202&Bathroom1Option1=202&Bathroom1Option2=202&Bathroom2=202&BathroomT2=202&Bathroom2Option1=202&Bathroom2Option2=202&Bathroom3=202&BathroomT3=202&Bathroom3Option1=202&Bathroom3Option2=202&Bathroom4=202&BathroomT4=202&Bathroom4Option1=202&Bathroom4Option2=202&Notes2=202&SwimmingPool=202&Media=202&Media4=202&Media0=202&Media2=202&Media1=202&Media7=202&Media5=202&Media6=202&Media3=202&Media8=202&Media9=202&Media10=202&Exterior=202&Exterior3=202&Exterior0=202&Exterior5=202&Exterior1=202&Exterior4=202&Exterior2=202&Exterior6=202&Exterior7=202&Exterior8=202&Activities=202&Activities3=202&Activities0=202&Activities5=202&Activities1=202&Activities4=202&Activities2=202&Activities6=202&Activities7=202&Activities8=202&Activities9=202&Activities10=202&HSbeginDates=202&LSbeginDates=202&HSendDates=202&LSendDates=202&HSweeklyRate=202&LSweeklyRate=202&HSnightlyRate=202&LSnightlyRate=202&HSminimumStay=202&LSminimumStay=202&ClothingOptional=202&Email=202&Remote_computer_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=14
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="18566" --><table BORDER="0" width="730" style="border-collapse: collapse">
			<tr>
				<td colspan="2" valign="top" align="left"><font color="#3288BD">
				<span style="font-size: 11pt; font-weight: 700">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="CaribbeanName" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>CaribbeanName<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"CaribbeanName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29888" --><!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="StateName" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>StateName<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"StateName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20877" --><!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="CountryName" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>CountryName<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"CountryName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29563" --></span></font></td>
				<td width="258" valign="top">
				<p align="right"><font color="#242424">Listing No.</font><font color="#CC66FF"><!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="PropertyID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PropertyID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PropertyID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="24368" --></font></td>
			</tr>
			<tr>
				<td colspan="3"><font color="#009900">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="PropertyTitle" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PropertyTitle<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PropertyTitle")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="35864" --></font></td>
			</tr>
			<tr>
				<td colspan="3" height="5"></td>
			</tr>
			<tr>
				<td width="231" rowspan="6">
				<p align="center">
				<img border="0" src="<%=FP_FieldLink(fp_rs,"Photograph")%>" align="left"></td>
				<td width="235"><font color="#242424">
				<span style="font-size: 11pt; font-weight: 700">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="Bedrooms_numbers" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Bedrooms_numbers<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Bedrooms_numbers")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="42161" --></span></font></td>
				<td width="258"><font color="#242424">
				<span style="font-size: 11pt; font-weight: 700">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="Feature1" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Feature1<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Feature1")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13027" --></span></font></td>
			</tr>
			<tr>
				<td width="235"><font color="#242424">
				<span style="font-size: 11pt; font-weight: 700">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="Bathroom_Numbers" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Bathroom_Numbers<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Bathroom_Numbers")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="37401" --></span></font></td>
				<td width="258"><font color="#242424">
				<span style="font-size: 11pt; font-weight: 700">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="Feature2" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Feature2<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Feature2")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13059" --></span></font></td>
			</tr>
			<tr>
				<td width="235"><font color="#242424">
				<span style="font-size: 11pt; font-weight: 700">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="SwimmingPool" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>SwimmingPool<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"SwimmingPool")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="33035" --></span></font></td>
				<td width="258"><font color="#242424">
				<span style="font-size: 11pt; font-weight: 700">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="Details" b-tableformat="FALSE" b-hashtml="TRUE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Details<font size="-1">>></font>" s-ColumnTypes="3,202,3,202,3,202,3,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,135" startspan --><%=FP_Field(fp_rs,"Details")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13804" --></span></font></td>
			</tr>
			<tr>
				<td width="235"> </td>
				<td width="258"> </td>
			</tr>
			<tr>
				<td width="235"><font color="#3288BD">
				<span style="font-size: 11pt; font-weight: 700">Nightly 
				</span></font>
				<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="PriceRangeNightly" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PriceRangeNightly<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PriceRangeNightly")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="48111" --></td>
				<td width="258"><font color="#3288BD">
				<span style="font-size: 11pt; font-weight: 700">Weekly  
				</span></font>
				<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="PriceRangeWeekly" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PriceRangeWeekly<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PriceRangeWeekly")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="43542" --></td>
			</tr>
			<tr>
				<td width="235"> </td>
				<td width="258"> </td>
			</tr>
		</table>
		<hr>
		<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><p> </td>
	</tr>
</table>
			</td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td height="47" align="left" valign="middle" background="images/bottom_1.jpg"><div align="center" style="padding-top:0px ">
			<a class="style13" style="text-decoration:none " href="privacypage.html">Copyright 2007-2008 © Travel 
			Buff.net. All rights reserved | Privacy Policy</a></div></td>
      </tr>
    </table></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td width="766" align="left" valign="top"> </td>
    <td> </td>
  </tr>
</table>
</body>
</html>


< Message edited by BeTheBall -- 4/19/2009 21:45:22 >

(in reply to mjmtravel)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 20:15:53   
Now I am getting confused. I do not see a "More Details" link anywhere in the code you have posted.

_____________________________

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.

(in reply to mjmtravel)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 20:36:31   
Duane

Its actually in the database as a field called details, that is where the hyperlink is and shows up when the drw results show up from the island or state results. I wanted to use the same page to do all the work, same as the propertydescription.asp page.

Will that not work.

(in reply to BeTheBall)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 20:49:20   
You can have one details page that covers all properties. Not sure why you would want the link in the database. The link will be the same for all properties, just the id that is passed to the page will change.

_____________________________

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.

(in reply to mjmtravel)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 21:24:36   
So your saying I can put the word Details in the drw result with the link we have been trying and it will pass the correct ID information to the other page.

(in reply to BeTheBall)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 21:35:05   
Yes. As long as the link is within the database results region, which is the area between the last two includes files. For example, find this block of code: 

<!--webbot bot="DatabaseResultColumn" s-columnnames="PropertyID,UserName,CaribbeanID,CaribbeanName,StateID,StateName,CountryID,CountryName,Photograph,PropertyType,PropertyTitle,Bedrooms_numbers,Bathroom_Numbers,Feature1,Feature2,PriceRangeNightly,PriceRangeWeekly,Description,SquareFT,Details,Amenity1,Amenity2,Amenity3,Amenity4,Amenity5,Amenity6,Amenity7,Amenity8,Amenity9,Kitchen1,Kitchen2,Kitchen3,Kitchen4,Kitchen5,Kitchen6,Kitchen7,Kitchen8,Kitchen9,Kitchen10,DiningRoom,DiningRoomSeats,Bedroom1,BedType1,Bedroom1Option1,Bedroom1Option2,Bedroom2,BedType2,Bedroom2Option1,Bedroom2Option2,Bedroom3,BedType3,Bedroom3Option1,Bedroom3Option2,Bedroom4,BedType4,Bedroom4Option1,Bedroom4Option2,Bedroom5,BedType5,Bedroom5Option1,Bedroom5Option2,Bedroom6,BedType6,Bedroom6Option1,Bedroom6Option2,Notes,Bathroom1,BathroomT1,Bathroom1Option1,Bathroom1Option2,Bathroom2,BathroomT2,Bathroom2Option1,Bathroom2Option2,Bathroom3,BathroomT3,Bathroom3Option1,Bathroom3Option2,Bathroom4,BathroomT4,Bathroom4Option1,Bathroom4Option2,Notes2,SwimmingPool,Media,Media4,Media0,Media2,Media1,Media7,Media5,Media6,Media3,Media8,Media9,Media10,Exterior,Exterior3,Exterior0,Exterior5,Exterior1,Exterior4,Exterior2,Exterior6,Exterior7,Exterior8,Activities,Activities3,Activities0,Activities5,Activities1,Activities4,Activities2,Activities6,Activities7,Activities8,Activities9,Activities10,HSbeginDates,LSbeginDates,HSendDates,LSendDates,HSweeklyRate,LSweeklyRate,HSnightlyRate,LSnightlyRate,HSminimumStay,LSminimumStay,ClothingOptional,Email,Remote_computer_name,Browser_type,Timestamp" s-column="Details" b-tableformat="FALSE" b-hashtml="TRUE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Details<font size="-1">>></font>" s-ColumnTypes="3,202,3,202,3,202,3,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,135" startspan --><%=FP_Field(fp_rs,"Details")%>


and try replacing <%=FP_Field(fp_rs,"Details")%> with:

<a href='propertydescription.asp?PropertyID=<%=FP_FieldVal(fp_rs,"PropertyID")%>'>More Details</a>

_____________________________

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.

(in reply to mjmtravel)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 21:41:25   
Thanks Duane I'll give it a try in the morning.

(in reply to BeTheBall)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 22:31:34   
Duane

I couldn't wait till morning, I had to try it.
It wouldn't work that way front page kept changing the drw back, so I put it on the spooky diet and now I get this fpclass error.

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/_fpclass/fpdblib.inc, line 48

(in reply to mjmtravel)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/19/2009 23:09:04   
Hmmm. If I recall that error refers to using a field name that doesn't exist in the database. Could be a typo. Repost the new, dieted code.

_____________________________

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.

(in reply to mjmtravel)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/20/2009 6:54:16   
Ok here it is: I don't see any mispellings or a missing field?


<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults" U-File="_private/form_results.csv" S-Format="TEXT/CSV" S-Label-Fields="TRUE" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--webbot bot="SaveResults" i-checksum="43374" endspan -->
<p align="left"><nobr>
<!--#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 Caribbean"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="CaribbeanName"
fp_sMenuValue="CaribbeanID"
fp_sColTypes="&CaribbeanID=3&CaribbeanName=202&DestinationID=3&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<span style="font-size: 11pt; font-weight: 700">Caribbean</span> 
<select NAME="CaribbeanID" SIZE="1">
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<option VALUE="<%=FP_FieldHTML(fp_rs,"CaribbeanID")%>"><%=FP_FieldHTML(fp_rs,"CaribbeanName")%>
</option>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</select> 
<!--#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 UnitedStates"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="StateName"
fp_sMenuValue="StateID"
fp_sColTypes="&StateID=3&StateName=202&DestinationID=3&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<span style="font-size: 11pt; font-weight: 700">USA
</span> <select NAME="StateID" SIZE="1">
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<option VALUE="<%=FP_FieldHTML(fp_rs,"StateID")%>"><%=FP_FieldHTML(fp_rs,"StateName")%>
</option>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</select> 
<!--#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 World"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="CountryName"
fp_sMenuValue="CountryID"
fp_sColTypes="&CountryID=3&CountryName=202&DestinationID=3&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=3
fp_iRegion=BOTID
%>
<span style="font-size: 11pt; font-weight: 700">World
</span> <select NAME="CountryID" SIZE="1">
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<option VALUE="<%=FP_FieldHTML(fp_rs,"CountryID")%>"><%=FP_FieldHTML(fp_rs,"CountryName")%>
</option>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</select></nobr></p>
<p><input type="submit" value="Search" name="B1"></p>
</form>
</td>
<td width="4"> </td>
</tr>
<tr align="left" valign="top">
<td width="18" height="287"><img src="images/spacer.gif" width="18" height="1"></td>
<td width="19" height="287"><img src="images/spacer.gif" width="19" height="1"><table border="1" width="60%" id="table1">
<tr>
<td>
<!--#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 Properties WHERE (CaribbeanID = ::CaribbeanID:: OR StateID = ::StateID:: OR CountryID = ::CountryID::)"
fp_sDefault="CaribbeanID=0&StateID=0&CountryID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&PropertyID=3&UserName=202&CaribbeanID=3&CaribbeanName=202&StateID=3&StateName=202&CountryID=3&CountryName=202&Photograph=202&PropertyType=202&PropertyTitle=202&Bedrooms_numbers=202&Bathroom_Numbers=202&Feature1=202&Feature2=202&PriceRangeNightly=202&PriceRangeWeekly=202&Description=203&SquareFT=202&Details=202&Amenity1=202&Amenity2=202&Amenity3=202&Amenity4=202&Amenity5=202&Amenity6=202&Amenity7=202&Amenity8=202&Amenity9=202&Kitchen1=202&Kitchen2=202&Kitchen3=202&Kitchen4=202&Kitchen5=202&Kitchen6=202&Kitchen7=202&Kitchen8=202&Kitchen9=202&Kitchen10=202&DiningRoom=202&DiningRoomSeats=202&Bedroom1=202&BedType1=202&Bedroom1Option1=202&Bedroom1Option2=202&Bedroom2=202&BedType2=202&Bedroom2Option1=202&Bedroom2Option2=202&Bedroom3=202&BedType3=202&Bedroom3Option1=202&Bedroom3Option2=202&Bedroom4=202&BedType4=202&Bedroom4Option1=202&Bedroom4Option2=202&Bedroom5=202&BedType5=202&Bedroom5Option1=202&Bedroom5Option2=202&Bedroom6=202&BedType6=202&Bedroom6Option1=202&Bedroom6Option2=202&Notes=202&Bathroom1=202&BathroomT1=202&Bathroom1Option1=202&Bathroom1Option2=202&Bathroom2=202&BathroomT2=202&Bathroom2Option1=202&Bathroom2Option2=202&Bathroom3=202&BathroomT3=202&Bathroom3Option1=202&Bathroom3Option2=202&Bathroom4=202&BathroomT4=202&Bathroom4Option1=202&Bathroom4Option2=202&Notes2=202&SwimmingPool=202&Media=202&Media4=202&Media0=202&Media2=202&Media1=202&Media7=202&Media5=202&Media6=202&Media3=202&Media8=202&Media9=202&Media10=202&Exterior=202&Exterior3=202&Exterior0=202&Exterior5=202&Exterior1=202&Exterior4=202&Exterior2=202&Exterior6=202&Exterior7=202&Exterior8=202&Activities=202&Activities3=202&Activities0=202&Activities5=202&Activities1=202&Activities4=202&Activities2=202&Activities6=202&Activities7=202&Activities8=202&Activities9=202&Activities10=202&HSbeginDates=202&LSbeginDates=202&HSendDates=202&LSendDates=202&HSweeklyRate=202&LSweeklyRate=202&HSnightlyRate=202&LSnightlyRate=202&HSminimumStay=202&LSminimumStay=202&ClothingOptional=202&Email=202&Remote_computer_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=14
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<table BORDER="0" width="730" style="border-collapse: collapse">
<tr>
<td colspan="2" valign="top" align="left"><font color="#3288BD">
<span style="font-size: 11pt; font-weight: 700">
<%=FP_FieldVal(fp_rs,"CaribbeanName")%><%=FP_FieldVal(fp_rs,"StateName")%><%=FP_FieldVal(fp_rs,"CountryName")%></span></font></td>
<td width="258" valign="top">
<p align="right"><font color="#242424">Listing No.</font><font color="#CC66FF"><%=FP_FieldVal(fp_rs,"PropertyID")%></font></td>
</tr>
<tr>
<td colspan="3"><font color="#009900">
<%=FP_FieldVal(fp_rs,"PropertyTitle")%></font></td>
</tr>
<tr>
<td colspan="3" height="5"></td>
</tr>
<tr>
<td width="231" rowspan="6">
<p align="center">
<img border="0" src="<%=FP_FieldLink(fp_rs,"Photograph")%>" align="left"></td>
<td width="235"><font color="#242424">
<span style="font-size: 11pt; font-weight: 700">
<%=FP_FieldVal(fp_rs,"Bedrooms_numbers")%></span></font></td>
<td width="258"><font color="#242424">
<span style="font-size: 11pt; font-weight: 700">
<%=FP_FieldVal(fp_rs,"Feature1")%></span></font></td>
</tr>
<tr>
<td width="235"><font color="#242424">
<span style="font-size: 11pt; font-weight: 700">
<%=FP_FieldVal(fp_rs,"Bathroom_Numbers")%></span></font></td>
<td width="258"><font color="#242424">
<span style="font-size: 11pt; font-weight: 700">
<%=FP_FieldVal(fp_rs,"Feature2")%></span></font></td>
</tr>
<tr>
<td width="235"><font color="#242424">
<span style="font-size: 11pt; font-weight: 700">
<%=FP_FieldVal(fp_rs,"SwimmingPool")%></span></font></td>
<td width="258"><font color="#242424">
<span style="font-size: 11pt; font-weight: 700">
<a href='propertydescription.asp?PropertyID=<%=FP_FieldVal(fp_rs,"PropertyID")%>'>More Details</a> </span></font></td>
</tr>
<tr>
<td width="235"> </td>
<td width="258"> </td>
</tr>
<tr>
<td width="235"><font color="#3288BD">
<span style="font-size: 11pt; font-weight: 700">Nightly 
</span></font>
<%=FP_FieldVal(fp_rs,"PriceRangeNightly")%></td>
<td width="258"><font color="#3288BD">
<span style="font-size: 11pt; font-weight: 700">Weekly  
</span></font>
<%=FP_FieldVal(fp_rs,"PriceRangeWeekly")%></td>
</tr>
<tr>
<td width="235"> </td>
<td width="258"> </td>
</tr>
</table>
<hr>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
<p> </td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="47" align="left" valign="middle" background="images/bottom_1.jpg"><div align="center" style="padding-top:0px ">
<a class="style13" style="text-decoration:none " href="privacypage.html">Copyright 2007-2008 © Travel
Buff.net. All rights reserved | Privacy Policy</a></div></td>
</tr>
</table></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td width="766" align="left" valign="top"> </td>
<td> </td>
</tr>
</table>
</body>
</html>

(in reply to BeTheBall)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/20/2009 9:22:53   
Just took a look. The fix I gave you worked in that it generated a correct URL to get you to the details page. Now we just have to sort out what is wrong on the details page. Judging by the error message, I would guess there is a typo or something among all the sections that look like this one:

<%

if Replace(FP_FieldVal(fp_rs,"Bedrooms_numbers")," ", "")<>"" Then

Response.write "<li>" & FP_FieldVal(fp_rs,"Bedrooms_numbers") & "</li>"

End If

%>

I would begin by deleting all but a few of statements like the one above until you zero in on the one with an error. For example, remove all but the first one and see if the page then works. If it does, then start adding the statements back in a few at a time.

Does that help?

_____________________________

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.

(in reply to mjmtravel)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/20/2009 22:40:19   
Duane

I took your advise and went through each line, what a pain. Not sure which one it was but its working now. I only have one more question.

In my 3 drop down boxes I have the word --choose-- in the list for each box, how do I make --choose-- my default. I have tried using the properties and putting the word at the top, but it seems to mess up the query somehow.

If I can get that figured out I'm good for a while.

Thanks again for all your help.

(in reply to BeTheBall)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/20/2009 23:03:06   
Looking at your code, it appears the "Choose" option is also coming from the database? I would not do that. I would hard code it into the dropdown: 


				<select NAME="CaribbeanID" SIZE="1">
<option selected>Choose</option>
				<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62210" -->
				<option VALUE="<%=FP_FieldHTML(fp_rs,"CaribbeanID")%>"><%=FP_FieldHTML(fp_rs,"CaribbeanName")%>
				</option>
				<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn2.inc" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62218" -->
				</select>


_____________________________

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.

(in reply to mjmtravel)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/21/2009 7:44:44   
Duane

That is what I did initially, but when I do I always get this error:

Database Results Wizard Error
Description: Parameter ?_1 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

I did remove them from the database table also, but got the same error.

(in reply to BeTheBall)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/21/2009 9:08:23   
See if this works any better:

<option selected value="0">Choose</option>


_____________________________

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.

(in reply to mjmtravel)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/21/2009 11:23:42   
That gives me nothing but the word choose to pick from. The first part with the dropdown boxes are dieted also.

(in reply to BeTheBall)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/21/2009 11:25:13   
That gives me on the word choose to pick from in the whole list. The dropdown boxes are dieted also, I don't know if that matters.

(in reply to BeTheBall)
mjmtravel

 

Posts: 326
Joined: 7/30/2006
Status: offline

  		RE: Hyperlink in drw with parameters - 4/21/2009 12:02:51   
Duane

I got it. If you right click the field properties box and add the word choose, you must also check the box specify value and put a zero in the value box.

That allows it to work without errors. Simple enough after playing with it for 1.5 hours.

(in reply to mjmtravel)
BeTheBall

 

Posts: 6487
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Hyperlink in drw with parameters - 4/21/2009 12:24:59   
Glad you sorted it out.

_____________________________

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.

(in reply to mjmtravel)
Page:   [1]

All Forums >> Web Development >> ASP, PHP, and Database >> Hyperlink in drw with parameters 		Page: [1]
Jump to: 1





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


Copyright © 2009 Thomas Brunt's OutFront Inc. All Rights Reserved.