|
Sarah
The
hashs are not needed
SQL
also has a DateAdd() function, which is what I am using, not the coldfusion
DateAdd() function which would require hashes:P
Steve
Hi
Greg,
Just skimming over
your query quickly, but aren't your #'s in the wrong places?
e.g.
AND dob BETWEEN
DateAdd(Year,#Form.OlderThan#,dob) AND
DateAdd(Year,#Form.YoungerThan#,dob)
should
be
AND dob BETWEEN
#DateAdd(Year,Form.OlderThan,dob)# AND
#DateAdd(Year,Form.YoungerThan,dob)#
Try fixing them up
and you might have more luck.
Thanks,
Sarah.
-----Original
Message-----
From:
[EMAIL PROTECTED] [mailto:[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
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).
<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>
PS i owe you a bottle of your
preffered posion for helping me out on this one.
---
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/ ---
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/
______________________________________________________________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright. If you
have received this email in error, please advise the sender and delete
it. If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone. You must not copy or
communicate to others content that is confidential or subject to
copyright, unless you have the consent of the content owner.
|
|
