[cfaussie] Re: look up date by years old with a 2 year spread < 2 > 2

[stone]

all the spelling is right.. i  spelt clothsize wrong in the db.   question why is the query not showing an 12-12-2003 on dob highted in red   SQL = "SELECT Talent.talentID , Talent.Name , Talent.Gender , Talent.DOB , Talent.Hair , Talent.Eye , Talent.Height , Talent.Clothssize , Talent.shoesize , Talent.hobbies , Talent.BIO , Talent.Compcard , Talent.ID FROM Talent WHERE Talent.gender = 'male' AND (dob BETWEEN DateAdd(Year,5,dob) AND DateAdd(Year,1,dob))"   this seems to be the problem.   new approach: some how the logic should run from a NOW() with a minus years   could i change it to a now() and and use a differnent querry get all records between  2-now() and 4 -now()?     then it should work i think my first logic was out of wack. Then i just send a number from the form and create the differnt older younger numbers eg <cfset Form.age =5> <!--- set age diff ---> <cfset OlderThan = Form.age + 2> <cfoutput>#OlderThan#</cfoutput> <cfset YoungerThan = Form.age - 2> <cfoutput>#youngerThan#</cfoutput> and use that as a way to create the date diff.   or possibly do this in the query with the right funtions   HMMMM its all a bit of a of a muddle but may be its the way to go   greg stone   --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/