Popular Searches: FrontPage Hosting | FrontPage Templates | FrontPage Training | Free FrontPage

Database results wizard   Logged in as: Guest
  Printable Version
All Forums >>FrontPage Specific Issues >>FrontPage Experts >> Page: [1]
Name:
Message<< Newer Topic  Older Topic >>

Paco in Ajijic

 

Posts: 13
Member since: 8/1/2008
 

Database results wizard 
I have a couple of issues. I am accessing an access database with the wizard.

First, is there a switch somewhere within FrontPage or Access that would show results for check boxes in the database as "Yes" or "No" instear of "True" or "False"?

Second, one of the fields in the database contains a web page a page address. Is there any way I can have the web address field show as a hyperlink when the results are displayed?

Third, I can't seem to get the header row to display properly.

http://www.rentallocatersmx.com/find_all.asp
  Report Abuse |  Date: 8/9/2008 12:49:46 PM

TexasWebDevelopers

Posts: 7039
Member since: 9/24/2002
From: USA

RE: Database results wizard (in reply to Paco in Ajijic) 
First:
<%
DIM your_fieldname1, your_fieldname2
your_fieldname1=rs(fp_yourfieldname1)
if your_fieldname1 = true then
your_fieldname1 ="yes"
else
your_fieldname1 ="no"
end if
your_fieldname2=rs(fp_yourfieldname2)
if your_fieldname2 = true then
your_fieldname2 ="yes"
else
your_fieldname2 ="no"
end if
%>
Second:
<a href="<%=rs(fp_URL_field%>"><%=rs(fp_URL_field%></a>
Third:
<p style="line-height: 0"> is keeping the text from fully displaying.
Eliminate or set the line height to a larger value.


_____________________________



FrontPageTools.com:Templates, Tools and Training support this forum
  Report Abuse |  Date: 8/9/2008 5:24:24 PM

Paco in Ajijic

 

Posts: 13
Member since: 8/1/2008
 

RE: Database results wizard (in reply to Paco in Ajijic) 
I have worked with this code on three or four different occasions now and no matter where I insert it I can't seem to get it to work. Does it not go within the wizard? Just where should I insert it?


< Message edited by Paco in Ajijic -- 8/18/2008 10:14:51 AM >
  Report Abuse |  Date: 8/18/2008 10:14:23 AM

TexasWebDevelopers

Posts: 7039
Member since: 9/24/2002
From: USA

RE: Database results wizard (in reply to Paco in Ajijic) 
Post your code and I'll show you.


_____________________________



FrontPageTools.com:Templates, Tools and Training support this forum
  Report Abuse |  Date: 8/18/2008 11:13:49 AM

Paco in Ajijic

 

Posts: 13
Member since: 8/1/2008
 

This is the table code (in reply to Paco in Ajijic) 
web_address is the one that needs to be a url and pets is one of the true fales issues


</table>
<table width="983" height="250">
<tr>
<td width="771" height="246">
<strong><font style="line-height: normal" color="#CC3300" face="arial black,avant garde" size="5">Find
a house to rent</font></strong>
<table width="980" border="1" height="166">
<thead>
<tr>
<td height="23" valign="middle" width="106">
<p style="line-height: 1"><font face="Arial" size="1" color="#000000">Name</font></p>
</td>
<td height="23" valign="middle" width="100">
<p style="line-height: 1"><font face="Arial" size="1" color="#000000">Web
Site</font></p>
</td>
<td height="23" valign="middle" width="56">
<p style="line-height: 1"><font face="Arial" size="1" color="#000000">Area</font></p>
</td>
<td height="23" valign="middle" width="130">
<p style="line-height: 1"><font face="Arial" size="1" color="#000000">Wheelchair</font></p>
</td>
<td height="23" valign="middle" width="53">
<p style="line-height: 1"><font face="Arial" size="1" color="#000000">Pets</font></p>
</td>
<td height="23" valign="middle" width="91">
<p style="line-height: 1"><font face="Arial" size="1" color="#000000">Unfurnished</font></p>
</td>
<td height="23" valign="middle" width="156">
<p style="line-height: 1"><font size="1" color="#000000"><font face="Arial">Part</font>
<font face="Arial">Furnished</font></font></p>
</td>
<td height="23" valign="middle" width="82">
<p style="line-height: 1"><font face="Arial" size="1" color="#000000">Furnished</font></p>
</td>
<td height="23" valign="middle" width="81">
<p style="line-height: 1"><font face="Arial" size="1" color="#000000">Bedrooms</font></p>
</td>
<td height="23" valign="middle" width="84">
<p style="line-height: 1"><font face="Arial" size="1" color="#000000">Bathrooms</font></p>
</td>
<td height="23" valign="middle" width="105">
<p style="line-height: 1"><font face="Arial" size="1" color="#000000">Rental $USD</font></p>
</td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-columntypes="202,202,202,202,202,202,202,202,202,203,202,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,3,3,3,3,3,11,11,202,11,11,11,11,11,11,11,11,11,11,203,203"
s-dataconnection="Database2" b-tableformat="TRUE"
b-menuformat="FALSE" s-menuchoice s-menuvalue
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
b-makeform="TRUE" s-recordsource="rentals"
s-displaycolumns="Property_Name,web_address,Area,Wheelchair_Access,Pets,Unfurnished,Partially_Furnished,Furnished,Bedrooms,Bathrooms,Rental_Amount"
s-criteria s-order="[Area] + [Rental_Amount] +"
s-sql="SELECT * FROM rentals ORDER BY Area ASC,Rental_Amount ASC"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields s-NoRecordsFound="No records returned."
i-MaxRecords="1024" i-GroupSize="5" BOTID="0"
u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><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>" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM rentals ORDER BY Area ASC,Rental_Amount ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=11 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database2"
fp_iMaxRecords=1024
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=11
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="42686" endspan -->
<tr>
<td height="16" width="106"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Property_Name" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1"><<</font>Property_Name<font size="-1">>></font>"
preview="<font size="-1"><<</font>Property_Name<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Property_Name")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="33095" endspan -->
</font></td>
<td height="16" width="100"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="web_address" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1"><<</font>web_address<font size="-1">>></font>"
preview="<font size="-1"><<</font>web_address<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"web_address")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="33228" endspan -->
</font></td>
<td height="16" width="56"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Area" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1"><<</font>Area<font size="-1">>></font>"
preview="<font size="-1"><<</font>Area<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Area")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="5228" endspan -->
</font></td>
<td height="16" width="130"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Wheelchair_Access" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1"><<</font>Wheelchair_Access<font size="-1">>></font>"
preview="<font size="-1"><<</font>Wheelchair_Access<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Wheelchair_Access")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="48412" endspan -->
</font></td>
<td height="16" width="53"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Pets" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1"><<</font>Pets<font size="-1">>></font>"
preview="<font size="-1"><<</font>Pets<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Pets")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="4575" endspan -->
</font></td>
<td height="16" width="91"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Unfurnished" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1"><<</font>Unfurnished<font size="-1">>></font>"
preview="<font size="-1"><<</font>Unfurnished<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Unfurnished")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="30897" endspan -->
</font></td>
<td height="16" width="156"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Partially_Furnished" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1"><<</font>Partially_Furnished<font size="-1">>></font>"
preview="<font size="-1"><<</font>Partially_Furnished<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Partially_Furnished")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="55511" endspan -->
</font></td>
<td height="16" width="82"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Furnished" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1"><<</font>Furnished<font size="-1">>></font>"
preview="<font size="-1"><<</font>Furnished<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Furnished")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="20282" endspan -->
</font></td>
<td height="16" width="81"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Bedrooms" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1"><<</font>Bedrooms<font size="-1">>></font>"
preview="<font size="-1"><<</font>Bedrooms<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Bedrooms")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="14962" endspan -->
</font></td>
<td height="16" width="84"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Bathrooms" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1"><<</font>Bathrooms<font size="-1">>></font>"
preview="<font size="-1"><<</font>Bathrooms<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Bathrooms")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="18788" endspan -->
</font></td>
<td height="16" width="105"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Rental_Amount" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1"><<</font>Rental_Amount<font size="-1">>></font>"
preview="<font size="-1"><<</font>Rental_Amount<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Rental_Amount")%><!--webbot
bot="DatabaseResultColumn" I-CheckSum="34576" endspan -->
</font></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" startspan
b-tableformat="TRUE" b-menuformat="FALSE"
u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside
tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><FORM><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR></FORM></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR><BR></td></tr>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" i-CheckSum="62730" endspan -->
</tbody>
</table>
</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="105%">


< Message edited by Paco in Ajijic -- 8/18/2008 11:59:30 AM >
  Report Abuse |  Date: 8/18/2008 11:56:47 AM

TexasWebDevelopers

Posts: 7039
Member since: 9/24/2002
From: USA

RE: Database results wizard (in reply to Paco in Ajijic) 
First:
Make a backup copy of the page.
Second:
Remove any comments that have check sums in them, like this:
<!--webbot bot="DatabaseResultColumn" I-CheckSum="5228" endspan -->This will allow you to edit the page without FrontPage undoing your edits.
Third:
For the pets example, change this:
<%=FP_FieldVal(fp_rs,"Pets")%>
to this:
<%
Pets=FP_FieldVal(fp_rs,"Pets")
if Pets = true then
Pets ="yes"
else
Pets ="no"
end if
%>
Fourth:
For the web url (assuming your field is a text string that is in the form of a long URL).
Change this:
<%=FP_FieldVal(fp_rs,"web_address")%>
To this:
<a href="<%=FP_FieldVal(fp_rs,"web_address")%>"><%=FP_FieldVal(fp_rs,"web_address")%></a>


_____________________________



FrontPageTools.com:Templates, Tools and Training support this forum
  Report Abuse |  Date: 8/18/2008 12:48:12 PM

Paco in Ajijic

 

Posts: 13
Member since: 8/1/2008
 

RE: Database results wizard (in reply to Paco in Ajijic) 
I have made the changes and not I get an HTTP 500 Internal Server Error

I must be too close to the forrest for the trees. Here is the code

<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-columntypes="202,202,202,202,202,202,202,202,202,203,202,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,3,3,3,3,3,11,11,202,11,11,11,11,11,11,11,11,11,11,203,203"
s-dataconnection="Database2" b-tableformat="TRUE"
b-menuformat="FALSE" s-menuchoice s-menuvalue
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
b-makeform="TRUE" s-recordsource="rentals"
s-displaycolumns="Property_Name,web_address,Area,Wheelchair_Access,Pets,Unfurnished,Partially_Furnished,Furnished,Bedrooms,Bathrooms,Rental_Amount"
s-criteria s-order="[Area] + [Rental_Amount] +"
s-sql="SELECT * FROM rentals ORDER BY Area ASC,Rental_Amount ASC"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields s-NoRecordsFound="No records returned."
i-MaxRecords="1024" i-GroupSize="5" BOTID="0"
u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><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>" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM rentals ORDER BY Area ASC,Rental_Amount ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=11 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database2"
fp_iMaxRecords=1024
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=11
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="42686" endspan -->
<tr>
<td height="16" width="106"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Property_Name" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Property_Name<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Property_Name<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Property_Name")%>
</font></td>
<td height="16" width="100"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="web_address" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>web_address<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>web_address<font size="-1">&gt;&gt;</font>" --><a href="<%=FP_FieldVal(fp_rs,"web_address")%>"><%=FP_FieldVal(fp_rs,"web_address")%></a>
</font></td>
<td height="16" width="56"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Area" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Area<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Area<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Area")%>
</font></td>
<td height="16" width="130"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Wheelchair_Access" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Wheelchair_Access<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Wheelchair_Access<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Wheelchair_Access")
if Wheelchair_Access = true then
Wheelchair_Access ="yes"
else
Wheelchair_Access ="no"
end if
%>
</font></td>
<td height="16" width="53"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Pets" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Pets<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Pets<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Pets")
if Pets = true then
Pets ="yes"
else
Pets ="no"
end if
%>
</font></td>
<td height="16" width="91"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Unfurnished" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Unfurnished<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Unfurnished<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Unfurnished")
if Unfurnished = true then
Unfurnished ="yes"
else
Unfurnished ="no"
end if
%>
</font></td>
<td height="16" width="156"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Partially_Furnished" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Partially_Furnished<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Partially_Furnished<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Partially_Furnished")
if Partially_Furnished = true then
Partially_Furnished ="yes"
else
Partially_Furnished ="no"
end if
%>
</font></td>
<td height="16" width="82"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Furnished" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Furnished<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Furnished<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Furnished")
if Furnished = true then
Furnished ="yes"
else
Furnished ="no"
end if
%>
</font></td>
<td height="16" width="81"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Bedrooms" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Bedrooms<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Bedrooms<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Bedrooms")%>
</font></td>
<td height="16" width="84"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Bathrooms" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Bathrooms<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Bathrooms<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Bathrooms")%>
</font></td>
<td height="16" width="105"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Rental_Amount" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Rental_Amount<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Rental_Amount<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Rental_Amount")%>
</font></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" startspan
b-tableformat="TRUE" b-menuformat="FALSE"
u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside
tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><FORM><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR></FORM></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR><BR></td></tr>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
</td>
</tr>
  Report Abuse |  Date: 8/18/2008 1:50:13 PM

TexasWebDevelopers

Posts: 7039
Member since: 9/24/2002
From: USA

RE: Database results wizard (in reply to Paco in Ajijic) 
As stated above---
You have this:
<%=FP_FieldVal(fp_rs,"Pets")
if Pets = true then
Pets ="yes"
else
Pets ="no"
end if
%>
It needs to be this:
<%
Pets=FP_FieldVal(fp_rs,"Pets")
if Pets = true then
Pets ="yes"
else
Pets ="no"
end if
%>


_____________________________



FrontPageTools.com:Templates, Tools and Training support this forum
  Report Abuse |  Date: 8/18/2008 3:29:27 PM

Paco in Ajijic

 

Posts: 13
Member since: 8/1/2008
 

RE: Database results wizard (in reply to Paco in Ajijic) 
Thank you for all your help and I am sorry to be such a pest. I have read and reread this code and it looks identical to what you gave me in your last post but for some reason I am not getting the query results back. http://www.rentallocatersmx.com/find_all_copy3.asp

Here is the code for the database wizard again:

<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-columntypes="202,202,202,202,202,202,202,202,202,203,202,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,3,3,3,3,3,11,11,202,11,11,11,11,11,11,11,11,11,11,203,203"
s-dataconnection="Database2" b-tableformat="TRUE"
b-menuformat="FALSE" s-menuchoice s-menuvalue
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
b-makeform="TRUE" s-recordsource="rentals"
s-displaycolumns="Property_Name,web_address,Area,Wheelchair_Access,Pets,Unfurnished,Partially_Furnished,Furnished,Bedrooms,Bathrooms,Rental_Amount"
s-criteria s-order="[Area] + [Rental_Amount] +"
s-sql="SELECT * FROM rentals ORDER BY Area ASC,Rental_Amount ASC"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields s-NoRecordsFound="No records returned."
i-MaxRecords="1024" i-GroupSize="5" BOTID="0"
u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><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>" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM rentals ORDER BY Area ASC,Rental_Amount ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=11 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database2"
fp_iMaxRecords=1024
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=11
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="42686" endspan -->
<tr>
<td height="16" width="106"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Property_Name" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Property_Name<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Property_Name<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Property_Name")%>
</font></td>
<td height="16" width="100"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="web_address" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>web_address<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>web_address<font size="-1">&gt;&gt;</font>" --><a href="<%=FP_FieldVal(fp_rs,"web_address")%>"><%=FP_FieldVal(fp_rs,"web_address")%></a>
</font></td>
<td height="16" width="56"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Area" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Area<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Area<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Area")%>
</font></td>
<td height="16" width="130"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Wheelchair_Access" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Wheelchair_Access<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Wheelchair_Access<font size="-1">&gt;&gt;</font>" -->
<%
Wheelchair_access=FP_FieldVal(fp_rs,"Wheelchair_Access")
if Wheelchair_Access = true then
Wheelchair_Access ="yes"
else
Wheelchair_Access ="no"
end if
%>
</font></td>
<td height="16" width="53"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Pets" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Pets<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Pets<font size="-1">&gt;&gt;</font>" -->
<%
Pets=FP_FieldVal(fp_rs,"Pets")
if Pets = true then
Pets ="yes"
else
Pets ="no"
end if
%>
</font></td>
<td height="16" width="91"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Unfurnished" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Unfurnished<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Unfurnished<font size="-1">&gt;&gt;</font>" -->
<%
Unfurnished=FP_FieldVal(fp_rs,"Unfurnished")
if Unfurnished = true then
Unfurnished ="yes"
else
Unfurnished ="no"
end if
%>
</font></td>
<td height="16" width="156"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Partially_Furnished" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Partially_Furnished<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Partially_Furnished<font size="-1">&gt;&gt;</font>" -->
<%
Partially_Furnished=FP_FieldVal(fp_rs,"Partially_Furnished")
if Partially_Furnished = true then
Partially_Furnished ="yes"
else
Partially_Furnished ="no"
end if
%>
</font></td>
<td height="16" width="82"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Furnished" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Furnished<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Furnished<font size="-1">&gt;&gt;</font>" -->
<%
Furnished=FP_FieldVal(fp_rs,"Furnished")
if Furnished = true then
Furnished ="yes"
else
Furnished ="no"
end if
%>
</font></td>
<td height="16" width="81"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Bedrooms" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Bedrooms<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Bedrooms<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Bedrooms")%>
</font></td>
<td height="16" width="84"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Bathrooms" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Bathrooms<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Bathrooms<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Bathrooms")%>
</font></td>
<td height="16" width="105"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="Locator,Submitter,Contact_Phone,Submitter_email,Owner,Listing_Agency,Listing_Agency_ID,Property_Name,Address,web_address,Area,Clothes_Washer,Clothes_Dryer,Dishwasher,Disposal,Microwave,Refrigerator,Separate_Freezer,Stove,Oven,Cable_TV,Satellite_TV,High_Speed_Internet,Phone_Line,Security_System,Covered_Terrace,Patio,Deck_Balcony,Walled_Fenced,Yard_Garden,Detached,Gated_Community,Lakefront_Rental,Rural,Wheelchair_Access,Pets,Casita,Potable_Water,Pressure_System,Purification_System,Pool,Jacuzzi,Unfurnished,Partially_Furnished,Furnished,On_Street,Off_Street,Gated,Carport,Garage,Automatic_Opener,Bedrooms,Bathrooms,Square_Feet_House,Square_Feet_Yard,Rental_Amount,Long_Term,Short_Term,Availability,Lease_Option,Less_than_500,501_750,751_1000,1001_1250,1251_1500,1501_up,Lake,Mountain,Lake_Mountain,Comment_1,Comment_2"
s-column="Rental_Amount" b-tableformat="TRUE"
b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Rental_Amount<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Rental_Amount<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Rental_Amount")%>
</font></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" startspan
b-tableformat="TRUE" b-menuformat="FALSE"
u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside
tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><FORM><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR></FORM></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR><BR></td></tr>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
  Report Abuse |  Date: 8/19/2008 7:50:35 AM

TexasWebDevelopers

Posts: 7039
Member since: 9/24/2002
From: USA

RE: Database results wizard (in reply to Paco in Ajijic) 
Are your db fields really returning true/false or are they returning yes/no?
How are the fields set up in Access?
The code is looking for true/false.


_____________________________



FrontPageTools.com:Templates, Tools and Training support this forum
  Report Abuse |  Date: 8/19/2008 8:00:53 AM

Paco in Ajijic

 

Posts: 13
Member since: 8/1/2008
 

RE: Database results wizard (in reply to Paco in Ajijic) 
Here is the original page http://www.rentallocatersmx.com/find_all.asp
This is the revised one http://www.rentallocatersmx.com/fi