RE: SQL Dates

2005-12-09 Thread Robertson-Ravo, Neil (RX)
First, you should never use formated dates in SQL Who says? -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 09 December 2005 02:41 To: CF-Talk Subject: Re: SQL Dates #DATEFORMAT(NOW(),'MM/DD/')# BETWEEN PA_START_DATE AND PA_END_DATE First, you should

RE: SQL Dates

2005-12-09 Thread Jennifer Gavin-Wear
/cfif /cfoutput -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: 09 December 2005 02:45 To: CF-Talk Subject: RE: SQL Dates ~| Find out how CFTicket can increase your company's customer support

Re: SQL Dates

2005-12-09 Thread Claude Schneegans
First, you should never use formated dates in SQL Who says? Dozens of users having trouble with dates in queries evey week ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this

RE: SQL Dates

2005-12-09 Thread Robertson-Ravo, Neil (RX)
Then use them correctly!!! ;-) -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 09 December 2005 14:42 To: CF-Talk Subject: Re: SQL Dates First, you should never use formated dates in SQL Who says? Dozens of users having trouble with dates in queries evey

Re: SQL Dates

2005-12-09 Thread Ken Ferguson
Perish the thought sir; perish the very thought. Robertson-Ravo, Neil (RX) wrote: Then use them correctly!!! ;-) -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 09 December 2005 14:42 To: CF-Talk Subject: Re: SQL Dates First, you should never use formated

Re: SQL Dates

2005-12-08 Thread Claude Schneegans
#DATEFORMAT(NOW(),'MM/DD/')# BETWEEN PA_START_DATE AND PA_END_DATE First, you should never use formated dates in SQL, especially if you want to compare them with columns. And most especially with the month first. If PA_START_DATE and PA_END_DATE are true date type, try this: WHERE

RE: SQL Dates

2005-12-08 Thread Matthew Walker
Try cfqueryparam value=#now()# cfsqltype=CF_SQL_TIMESTAMP That will give you the db-independence. -Original Message- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: Friday, 9 December 2005 3:31 p.m. To: CF-Talk Subject: SQL Dates I am trying to get all records from a table where the

RE: SQL Dates

2005-12-08 Thread ColdFusion
Thanks.. I knew it was something simple.. Just could not see it. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, December 08, 2005 9:41 PM To: CF-Talk Subject: Re: SQL Dates #DATEFORMAT(NOW(),'MM/DD/')# BETWEEN PA_START_DATE AND PA_END_DATE