Dear All
I am used to using SQL Server or Oracle with CF so I am now using
Access and having a little trouble.
I want to do a CFQUERY to load up a CFGRID with data from a db
table. One of these fields is a date. In SQL Server I just do some
manipulation with SQL to get an acceptable date format. What
do I do with ACCESS? I tried DATEFORMAT with CF as follows and got
the error below :
<cfquery name="get_activities"
datasource="#ODBC_datasource#"
dbtype="ODBC">
SELECT DISTINCT
title,
date_held,
the_date = #DateFormat(date_held, "dd mmmm yyyy")#
FROM activities
ORDER BY title
</cfquery>
THE ERROR I GET:
An error occurred while evaluating the expression:
#DateFormat(date_held, "dd mmmm yyyy")#
Error near line 43, column 15.
-----------------------------------
Error resolving parameter DATE_HELD
What is the best way to get date data from ACCESS and display it
in a CFGRID?
Thanks
Phil Palmer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
