DRW lookup between date ranges

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

DRW lookup between date ranges

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> DRW lookup between date ranges

Page: [1]


Jordan Posts: 117 Joined: 1/8/2002 From: Maine Status: offline	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! _____________________________


Spooky Posts: 26599 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: DRW lookup between date ranges - 1/23/2008 14:09:48 fp_sQry="SELECT * FROM Results WHERE (Results.Expire BETWEEN #date1# AND #date2#)" _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to Jordan)