where is your WHERE clause ?
Laurent Fontaine
Sr Web Developer
American Power Conversion
Level 13, 65 Berry Street
North Sydney, NSW 2060
AUSTRALIA
tel: +61 2 8923 9339
@: [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Sent by: To: "CFAussie Mailing
List" <[EMAIL PROTECTED]>
[EMAIL PROTECTED] cc:
emon.com.au Subject: [cfaussie] Re:
look up date by years old with a 2 year spread < 2 > 2
19/03/2003 03:23 PM
Please respond to "CFAussie
Mailing List"
Hi steve removed the WHERE 1=1
but know luck..
should i change the
AND dob BETWEEN DateAdd(Year,#Form.OlderThan#,dob) AND DateAdd(Year,
#Form.YoungerThan#,dob)
move the hashes around the dob as well?
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
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 AND Talent.gender = 'male' AND dob BETWEEN DateAdd(Year,5,dob)
AND DateAdd(Year,1,dob)"
----- Original Message -----
From: Steve Onnis
To: CFAussie Mailing List
Sent: Wednesday, March 19, 2003 2:54 PM
Subject: [cfaussie] Re: look up date by years old with a 2 year spread < 2
> 2
Check your columns names
If its not that, re jig the code to get rid of the WHERE 1=1 part. I know
this works under MSSQL, but not sure if it works under Access.
What is does it just returns true cause 1 does = 1, and then you just add
your AND clauses. Dont know if it works in Access
Anyone?
Steve
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, 19 March 2003 2:43 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: look up date by years old with a 2 year
spread < 2 > 2
I have added the error
Thanks sarah steve and adam
the cfif was the source of the last error now i have a new one.
it looks like the dob which i thought would be evaluated from the
database selected record is not the case.
do i need to pass the dob vale from the form or from a query on the
page.
I would like to use the between younger older compared to the value
in the datase.
At this time i just pass a select vale for OlderThan and YoungerThan
and now dob vale is sent to the query.
Is it possible to just send the 2 values and call the dob from the
database?
and what format should the dob be in?
should it be Talent.DOB?
<cfset Form.OlderThan =5>
<cfset Form.YoungerThan =1>
<cfset form.search = "yes">
<cfset form.gender = "male">
<cfset form.hair = "">
<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>
<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>
The error
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the
fields included in your query exist and that you have specified their
names correctly.
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 1=1 AND Talent.gender
= 'male' AND dob BETWEEN DateAdd(Year,5,dob) AND DateAdd(Year,1,dob)"
Data Source = "INTERACT"
---
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/
---
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/
