Database results wizard

Database results wizard (Full Version)

FrontPage Talk - Great Talk About Microsoft FrontP: http://www.frontpagetalk.com/forums/
- FrontPage Specific Issues: http://www.frontpagetalk.com/forums/default.asp?catApp=2
- - FrontPage Experts: http://www.frontpagetalk.com/forums/appid_8/tt.htm

Message

Paco in Ajijic -> Database results wizard (8/9/2008 12:49:46 PM)
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

TexasWebDevelopers -> RE: Database results wizard (8/9/2008 5:24:24 PM)
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.

Paco in Ajijic -> RE: Database results wizard (8/18/2008 10:14:23 AM)
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?

TexasWebDevelopers -> RE: Database results wizard (8/18/2008 11:13:49 AM)
Post your code and I'll show you.

Paco in Ajijic -> This is the table code (8/18/2008 11:56:47 AM)
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%">

TexasWebDevelopers -> RE: Database results wizard (8/18/2008 12:48:12 PM)
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>

Paco in Ajijic -> RE: Database results wizard (8/18/2008 1:50:13 PM)
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"><<</font>Property_Name<font size="-1">>></font>" preview="<font size="-1"><<</font>Property_Name<font size="-1">>></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"><<</font>web_address<font size="-1">>></font>" preview="<font size="-1"><<</font>web_address<font size="-1">>></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"><<</font>Area<font size="-1">>></font>" preview="<font size="-1"><<</font>Area<font size="-1">>></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"><<</font>Wheelchair_Access<font size="-1">>></font>" preview="<font size="-1"><<</font>Wheelchair_Access<font size="-1">>></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"><<</font>Pets<font size="-1">>></font>" preview="<font size="-1"><<</font>Pets<font size="-1">>></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"><<</font>Unfurnished<font size="-1">>></font>" preview="<font size="-1"><<</font>Unfurnished<font size="-1">>></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"><<</font>Partially_Furnished<font size="-1">>></font>" preview="<font size="-1"><<</font>Partially_Furnished<font size="-1">>></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"><<</font>Furnished<font size="-1">>></font>" preview="<font size="-1"><<</font>Furnished<font size="-1">>></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"><<</font>Bedrooms<font size="-1">>></font>" preview="<font size="-1"><<</font>Bedrooms<font size="-1">>></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"><<</font>Bathrooms<font size="-1">>></font>" preview="<font size="-1"><<</font>Bathrooms<font size="-1">>></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"><<</font>Rental_Amount<font size="-1">>></font>" preview="<font size="-1"><<</font>Rental_Amount<font size="-1">>></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>

TexasWebDevelopers -> RE: Database results wizard (8/18/2008 3:29:27 PM)
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 %>

Paco in Ajijic -> RE: Database results wizard (8/19/2008 7:50:35 AM)
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"><<</font>Property_Name<font size="-1">>></font>" preview="<font size="-1"><<</font>Property_Name<font size="-1">>></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"><<</font>web_address<font size="-1">>></font>" preview="<font size="-1"><<</font>web_address<font size="-1">>></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"><<</font>Area<font size="-1">>></font>" preview="<font size="-1"><<</font>Area<font size="-1">>></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"><<</font>Wheelchair_Access<font size="-1">>></font>" preview="<font size="-1"><<</font>Wheelchair_Access<font size="-1">>></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"><<</font>Pets<font size="-1">>></font>" preview="<font size="-1"><<</font>Pets<font size="-1">>></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"><<</font>Unfurnished<font size="-1">>></font>" preview="<font size="-1"><<</font>Unfurnished<font size="-1">>></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"><<</font>Partially_Furnished<font size="-1">>></font>" preview="<font size="-1"><<</font>Partially_Furnished<font size="-1">>></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"><<</font>Furnished<font size="-1">>></font>" preview="<font size="-1"><<</font>Furnished<font size="-1">>></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"><<</font>Bedrooms<font size="-1">>></font>" preview="<font size="-1"><<</font>Bedrooms<font size="-1">>></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"><<</font>Bathrooms<font size="-1">>></font>" preview="<font size="-1"><<</font>Bathrooms<font size="-1">>></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"><<</font>Rental_Amount<font size="-1">>></font>" preview="<font size="-1"><<</font>Rental_Amount<font size="-1">>></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>

TexasWebDevelopers -> RE: Database results wizard (8/19/2008 8:00:53 AM)
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.

Paco in Ajijic -> RE: Database results wizard (8/19/2008 8:09:52 AM)
Here is the original page http://www.rentallocatersmx.com/find_all.asp This is the revised one http://www.rentallocatersmx.com/find_all_copy3.asp In Access, it is a check box field which has always returned true/false in reports. I could certainly restructure the database to make it a text field but there will be a great deal of people entering data and I am not sure we will get back valid data with a text field.

TexasWebDevelopers -> RE: Database results wizard (8/19/2008 9:24:13 AM)
First, try using True instead of true. If that doesn't work then perhaps it is already returning the True/False as a string. Put quotes around the true/false variables and test again: <% Pets=FP_FieldVal(fp_rs,"Pets") if Pets = "True" then Pets ="yes" else Pets ="no" end if %>

TexasWebDevelopers -> RE: Database results wizard (8/20/2008 5:57:55 AM)
It looks like it worked for you. Come on back if you need other help.

Paco in Ajijic -> RE: Database results wizard (8/20/2008 7:32:54 AM)
Thanks for all your help. It was quite a battle.

Page: [1]

Forum Software powered by ASP Playground Advanced Edition 2.0.5
Copyright © 2000 - 2003 ASPPlayground.NET