Hi
I tired that one but still getting an error.
Dont know what to do any one with more
pointers
<cfset Form.age =5>
<!--- set age diff --->
<cfset
Older = Form.age + 2>
<cfset Younger = Form.age - 2>
<!--- create the dates --->
<cfoutput>
<cfset Olderthan
= dateformat(DateAdd("yyyy", -Older, Now()),'yyyy-mm-dd')>
<cfset
Youngerthan = dateformat(DateAdd("yyyy",-Younger,Now()),'yyyy-mm-dd')>
get
all records where member was born between #Olderthan# and
#Youngerthan#
</cfoutput>
<cfquery name="getRecord"
datasource="interact">
<cfoutput><pre>
SELECT
Talent.talentID ,
Talent.Name ,
Talent.Gender ,
Talent.DOB ,
Talent.Hair ,
Talent.Eye ,
Talent.Height ,
Talent.Clothessize ,
Talent.shoesize ,
Talent.hobbies ,
Talent.BIO ,
Talent.Compcard ,
Talent.ID
FROM Talent
where
(Talent.DOB <= {d '#Olderthan#'} and Talent.DOB >= {d
'#Youngerthan#'})
</pre></cfoutput>
</cfquery>
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected
'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
SQL = "
SELECT Talent.talentID ,
Talent.Name ,
Talent.Gender ,
Talent.DOB ,
Talent.Hair ,
Talent.Eye ,
Talent.Height ,
Talent.Clothessize ,
Talent.shoesize ,
Talent.hobbies ,
Talent.BIO ,
Talent.Compcard ,
Talent.ID
FROM Talent
where (Talent.DOB <= {d '1996-03-20'} and Talent.DOB >= {d '2000-03-20'})
"
Data Source = "INTERACT"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (16:1) to (16:48) in the template file
C:\Documents and Settings\Greg Stone.GREG\My Documents\client coldfusion
workfiles\interact\application\members\test.cfm.
Date/Time: 03/20/03 11:41:57
Browser: Mozilla/4.0 (compatible; MSIE 6.0;
Windows NT 5.0; MSOCD; YComp 5.0.2.4; .NET CLR 1.0.3705)
Remote Address:
127.0.0.1
HTTP Referer:
http://127.0.0.1/mydocuments/client%20coldfusion%20workfiles/interact/application/members/test.cfm
---