|
Jordan -> DRW lookup between date ranges (1/22/2008 10:35:20)
|
I have looked at the various posts trying to figure this out, but still run into trouble. Here is the code I am currently using (and it works correctly):
quote:
<% end if %>
<%
fp_sQry="SELECT * FROM Results WHERE ((Results.Expire)>Date()) AND ((Results.Status)=-1) ORDER BY Deceased ASC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="view"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Deceased"
fp_sMenuValue="Deceased"
fp_sColTypes="&Key=3&Deceased=202&Status=11&Expire=135&Death=135&Obituary=203&Legacy=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
What I want to do now is create another lookup where Results.Expire is between 1/1/2007 and 6/30/2007. What is the code to accomplish this?
Also, can the iMaxRecords be increased? How many records can be displayed?
Thanks for the help!
|
|
|
|
