What are you getting when you run this? An error or an empty record set? A. ----- Original Message ----- From: "Chris Holdman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 11:34 AM Subject: [KCFusion] Select in Date Range
> Okay I know this should be easy but I am not having any success. I want to > select betwee two dates. Here is my query, what am I doing wrong. > > > <cfquery datasource="date" name="name"> > select * from request where closed between '2002-10-01 00:00:00' AND > '2002-12-15 00:00:00' > order by closed > </cfquery> > > > > > Christopher V. Holdman > [EMAIL PROTECTED] > > > ______________________________________________________________________ > The KCFusion.org list and website is hosted by Humankind Systems, Inc. > List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org > Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] > To Subscribe.................... mailto:[EMAIL PROTECTED] > To Unsubscribe................ mailto:[EMAIL PROTECTED] > > > ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]