Okies.. Dina Hess is officially a smart cool person ^_^ If you meet her, buy her some muffins!
Hee hee. -Gel ------- <CFSET TheDate = StartDate> is inside loop over "getClients" query so it's resetting the value of TheDate to getClients.StartDate each time it loops over the query rs ----- Original Message ----- From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 9:37 AM Subject: RE: Going crazy! Dates acting insane..AIIIEEE! > Hi, > > This is the GetClients Query: > > <CFQUERY name="GetClients" datasource="#DSN#" > > > SELECT * > > FROM tblMaster > > WHERE > > tblMaster.startdate <= #enddate# > > AND tblMaster.startdate >= #startdate# > > AND tblMaster.empid = #client.empid# > > </CFQUERY> > > No field called TheDate....:-\ > > -Gel ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists