If the requested earliest and latest dates fall within the same month,
everything run well...but, if two months are spanned, no results are returned.
Why?
Rick
Here is a query that we use to find birthdays for the next 28 days on our
intranet. This may not be the most elegant solution, but it
lk
Subject: Re: How can I make this query run correctly?
On Wednesday 22 November 2006 15:46, Rick Faircloth wrote:
> from clients
> where Client_Birthdate >= '2006-11-27'
> and Client_Birthdate <= '2006-12-31'
where client_birthdate between and
Between is
006 11:08 AM
To: CF-Talk
Subject: Re: How can I make this query run correctly?
On Wednesday 22 November 2006 15:46, Rick Faircloth wrote:
> from clients
> where Client_Birthdate >= '2006-11-27'
> and Client_Birthdate <= '2006-12-31'
where client_birthdate betwe
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 22, 2006 11:16 AM
To: CF-Talk
Subject: Re: How can I make this query run correctly?
Rick Faircloth wrote:
> Good morning, all.
>
> I'm having to directly query a MySQL database for a client
> b
Rick Faircloth wrote:
> Good morning, all.
>
> I'm having to directly query a MySQL database for a client
> because they can't access their web app on my server.
>
> I'm trying to get clients' whose birthdates fall with a date range.
>
> I've tried variations, with no success in returning *any*
Never mind...figured out that I needed to leave off the year
to get birthdates...years don't matter...
Thanks...
Rick
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 22, 2006 10:47 AM
To: CF-Talk
Subject: How can I make this quer
On Wednesday 22 November 2006 15:46, Rick Faircloth wrote:
> from clients
> where Client_Birthdate >= '2006-11-27'
> and Client_Birthdate <= '2006-12-31'
where client_birthdate between and
Between is a handy SQL shortcut, and the use of cfqueryparam with real CF
dates leaves formatting it
Is it a date formatting issue? Is so, what is the date date format MySQL could
read?
Thanks for any help!
Is it a date field or a text field? If it is a date field try the
createODBCDate() function.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
Good morning, all.
I'm having to directly query a MySQL database for a client
because they can't access their web app on my server.
I'm trying to get clients' whose birthdates fall with a date range.
I've tried variations, with no success in returning *any* results. the
latest version of the que
9 matches
Mail list logo
