|
pmagas -> RE: "Loop without do" (8/11/2004 19:03:02)
|
Thanks, Bobby! I started some pages 'fresh' using FP 2000 so I don't have to worry about the _fpclass problems.
Now I have a logic problem. Here's my code:
quote:
<%
fp_sQry="SELECT * FROM MF2old WHERE ([Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND [Address - Zip] LIKE '::Zip::' AND [Area Desc] LIKE '::Area::' AND [Type of Units Desc] = '::Type::' AND [Unit 1-# of Bedrooms] >= ::Bedrooms:: OR [Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND [Address - Zip] LIKE '::Zip::' AND [Area Desc] LIKE '::Area::' AND [Type of Units Desc] = '::Type::' AND [Unit 2-# of Bedrooms] >= ::Bedrooms:: OR [Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND [Address - Zip] LIKE '::Zip::' AND [Area Desc] LIKE '::Area::' AND [Type of Units Desc] = '::Type::' AND [Unit 3-# of Bedrooms] >= ::Bedrooms:: OR [Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND [Address - Zip] LIKE '::Zip::' AND [Area Desc] LIKE '::Area::' AND [Type of Units Desc] = '::Type::' AND [Unit 4-# of Bedrooms] >= ::Bedrooms::) ORDER BY [Net Income] DESC,[Listing Price] DESC"
fp_sDefault="From=&To=&Zip=&Area=&Type=&Bedrooms=&From=&To=&Zip=&Area=&Type=&Bedrooms=&From=&To=&Zip=&Area=&Type=&Bedrooms=&From=&To=&Zip=&Area=&Type=&Bedrooms="
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=31
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
(I've put it on a Spooky diet.) From the search page, using the defaults, it gives "No Records Found." There are about 440 records and at least 100 should come up with the defaults. I imagine the problem is in my query but I can't find it.
Thanks for any insight you might offer.
|
|
|
|
