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

Steve Onnis Tue, 18 Mar 2003 18:57:01 -0800

Try changing <CFIF ParameterExists(form.search)> to <CFIF isDefined("form.search")>

Steve

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, 19 March 2003 1:49 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: look up date by years old with a 2 year spread < 2 > 2

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#'


<CFIF Form.OlderThan AND Form.YoungerThan>
   AND dob BETWEEN DateAdd(Year,#Form.OlderThan#,dob) AND DateAdd(Year,#Form.YoungerThan#,dob)
<cfif>

<cfif Form.YoungerThan AND NOT Form.OlderThan>
   AND dob < DateAdd(Year,#Form.YoungerThan#,dob)
</cfif>

<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/

---
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/

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

Reply via email to