nmarano
asked on
Returning a query with #now()#
Experts-
I'm having some trouble returning results from a query. I am using SQL server 2008 and the field (enterDate) is set as a dateTime in the table. When I run the query below, it does not return any records although there are records in the DB that should be returned. Any suggestions would be appreciated. EnterDate field in the db looks like this....
2013-01-03 09:51:09.613
<cfquery name="getBillable" datasource="#application.d
select *
from prospects
where email = '#form.email#'
and enterDate = #dateFormat(now(),'yyyy-mm
</cfquery>
Thanks
Nick
I'm having some trouble returning results from a query. I am using SQL server 2008 and the field (enterDate) is set as a dateTime in the table. When I run the query below, it does not return any records although there are records in the DB that should be returned. Any suggestions would be appreciated. EnterDate field in the db looks like this....
2013-01-03 09:51:09.613
<cfquery name="getBillable" datasource="#application.d
select *
from prospects
where email = '#form.email#'
and enterDate = #dateFormat(now(),'yyyy-mm
</cfquery>
Thanks
Nick
Last Comment
becraig
why not set the date as a variable before the query then pass the variable into the query.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for your help
> and enterDate > [original date] AND enterDate < [orginal date plus 1 day]
Small typo. I think he meant ">= [original date]" rather than "> [original date]"
Edit: That approach works well. Using cfqueryparam it is a simple as:
WHERE enterDate >= <cfqueryparam value="#now()#" cfsqltype="cf_sql_date">
AND enterDate < <cfqueryparam value="#dateAdd('d', 1, now())#" cfsqltype="cf_sql_date">
...
Small typo. I think he meant ">= [original date]" rather than "> [original date]"
Edit: That approach works well. Using cfqueryparam it is a simple as:
WHERE enterDate >= <cfqueryparam value="#now()#" cfsqltype="cf_sql_date">
AND enterDate < <cfqueryparam value="#dateAdd('d', 1, now())#" cfsqltype="cf_sql_date">
...
ColdFusion Language
ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.
11K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
