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

[stone]

Thanks steve Ok i understand  number issue NOW . but i still get the error on the <cfif>   The tag is not correctly positioned relative to other tags in the template: tag CFIF must have some content. This means that there must be at least one tag, some text, or even just whitespace characters between the <CFIF> and </CFIF> markers. This problem may be due to a CFML comment that has no end comment mark. The error occurred while processing an element with a general identifier of (CFIF), occupying document position (25:1) to (25:35). Below the exact query <cfset form.olderthan = 5 > <cfset form.youngerthan = 1 > <cfset form.gender = "male"> <cfset form.search = "yes">   <CFQUERY name="getRecord" dataSource="interact">  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 1=1  <CFIF ParameterExists(url.ID)>  AND Talent.ID = #url.ID#  </CFIF>   LINE 25 <CFIF ParameterExists(form.search)>   AND Talent.gender = '#form.gender#'   <!--- Check for age --->   <!--- If we want an age range --->   <CFIF Form.OlderThan AND Form.YoungerThan>    AND dob BETWEEN DateAdd(Year,#Form.OlderThan#,dob) AND DateAdd(Year,#Form.YoungerThan#,dob)   <cfif>   <!--- If we want all people younger than an age --->   <cfif Form.YoungerThan AND NOT Form.OlderThan>    AND dob < DateAdd(Year,#Form.YoungerThan#,dob)   </cfif>   <!--- If we want all people older than an age --->   <cfif NOT Form.YoungerThan AND Form.OlderThan>    AND dob > DateAdd(Year,#Form.OlderThan#,dob)   </cfif>       <CFIF form.hair IS NOT "">    and talent.hair = '#form.hair#'    </CFIF> </CFIF>   </CFQUERY>   PS i owe you a bottle of your preffered posion for helping me out on this one. what do you drink?   regards greg --- 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/