This query should work, at least in Access and MS SQLServer. (I tested
it and it is correct.) However, if you are using a different database, you
mileage will vary.
To test, make a page that just does this and nothing else:
><cfquery name="qGetCertificates" datasource="sonocme">
> SELECT eMail, issueDate, testName, namePDF
> FROM certificates
> WHERE issueDate >=
{ts '2007-01-01 00:00:00'}
> AND issueDate <=
{ts '2007-01-01 00:00:00'}
>
></cfquery>
<cfdump var="#
>qGetCertificates
#">
If you don't get records or you get an error, then it is either your data,
or your database requires "special" sql. Hard to say without knowing what
you are using.....if this little snippet runs okay, then it is something
other than the query.....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2743
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
