RE: How can I make this query run correctly?

2006-11-22 Thread Ian Skinner
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

RE: How can I make this query run correctly?

2006-11-22 Thread Rick Faircloth
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

RE: How can I make this query run correctly?

2006-11-22 Thread Rick Faircloth
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

RE: How can I make this query run correctly?

2006-11-22 Thread Rick Faircloth
-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

Re: How can I make this query run correctly?

2006-11-22 Thread Jim Wright
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*

RE: How can I make this query run correctly?

2006-11-22 Thread Rick Faircloth
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 query run correctl

Re: How can I make this query run correctly?

2006-11-22 Thread Tom Chiverton
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

RE: How can I make this query run correctly?

2006-11-22 Thread Ian Skinner
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