[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

Querying greater than/less than dates in Coldfusion

Asked by diecasthft in ColdFusion Application Server, Databases Miscellaneous, ColdFusion Studio

Good Afternoon. I have a dilhemma that I'm hoping someone can help me with. I have a Coldfusion page and it connects to an Oracle DSN. In that Oracle table, I have some fileds containing dates, one for date tasked, and one for date complete related to projects. I'm trying to create a query, that I will eventually use in Coldfusion Report Builder, but for starters, I need to get my query correct. I would like a query that gives me all of the projects within a certain date span. For instance, show me all of the projects from 10/1/2009 thru 10/27/2009. My web page had two text fields that a user can enter, and the functions work, but the query does not give the correct result. I also must note that the dates in my database are stores as a varchar rather than the date format. Can this be done?? Thanks Alot!!!!
[+][-]10/27/09 11:50 AM, ID: 25675990Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/27/09 12:05 PM, ID: 25676137Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/27/09 12:14 PM, ID: 25676245Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/27/09 12:21 PM, ID: 25676333Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/28/09 05:04 AM, ID: 25682260Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/28/09 09:42 AM, ID: 25685233Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/30/09 02:38 PM, ID: 25706984Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625