M
MikeG
I am trying to search a database between two values, but I keep getting a "No records retuned" message when there should be many matching records. The following is the query
fp_sQry="SELECT * FROM STable WHERE (((Price >= :rice: AND (Price < :rice:));
fp_sDefault="Price=&Price=
fp_sNoRecords="<tr><td colspan=10 align=left width=""100%"">No records returned.</td></tr>
fp_sDataConn="SalesDB
fp_iMaxRecords=25
fp_iCommandType=
fp_iPageSize=
fp_fTableFormat=Tru
fp_fMenuFormat=Fals
fp_sMenuChoice="
fp_sMenuValue="
fp_sColTypes="&ID=3&Address=202&Neighborhood=202&City=202&State=202&Beds=202&Baths=3&Price=3&Description=202&Photo=202&
fp_iDisplayCols=1
fp_fCustomQuery=Tru
What I am I doing wrong? Thanks
fp_sQry="SELECT * FROM STable WHERE (((Price >= :rice: AND (Price < :rice:));
fp_sDefault="Price=&Price=
fp_sNoRecords="<tr><td colspan=10 align=left width=""100%"">No records returned.</td></tr>
fp_sDataConn="SalesDB
fp_iMaxRecords=25
fp_iCommandType=
fp_iPageSize=
fp_fTableFormat=Tru
fp_fMenuFormat=Fals
fp_sMenuChoice="
fp_sMenuValue="
fp_sColTypes="&ID=3&Address=202&Neighborhood=202&City=202&State=202&Beds=202&Baths=3&Price=3&Description=202&Photo=202&
fp_iDisplayCols=1
fp_fCustomQuery=Tru
What I am I doing wrong? Thanks