Ah !
That might explain it as it is an Access DB (although we do have SQL Server
7).
IS there a way to do this in Access do you know off ?
-----Original Message-----
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2001 12:27
To: CF-Talk
Subject: RE: Querying by a date field.
Convert is a SQL function. I do not think
Access recognizes it.
-----Original Message-----
From: Darren Adams [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 6:57 AM
To: CF-Talk
Subject: RE: Querying by a date field.
Hello Michael,
Just ran your code and got this message:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'convert' in
expression.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:58).
Date/Time: 05/21/01 11:58:07
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt)
Remote Address: 129.153.207.20
HTTP Referer: http://uk1web2:8070/supportkb/search.cfm
Template: E:\Inetpub\infodesk\supportkb\search_result.cfm
Any ideas ?
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2001 12:19
To: CF-Talk
Subject: Re: Querying by a date field.
try using this:
<cfquery name="getdate" datasource="suppkb" dbtype="ODBC">
SELECT *
FROM Main_Table
WHERE convert(char(10),Date_Entered,101) BETWEEN
#dateformat(date,"dd/mm/yyyy")# and #today#
</cfquery>
that will ensure Date_Entered is also in "dd/mm/yyyy" format.
works for me... let me know!
Thanks,
Michael Lugassy
IT/WEB Specialist
Interactive Music Ltd.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
