Barry,
Most of the problem was me being an idiot. I was referring to a
field name that did not exist. The where clause below works.
and (((tbl_GENTracker.DateReceived) >=
###dateformat(form.sDate,'dd/mm/yyyy')###))
I could not get cpqueryparam to work. Do you have an examples of it
working.
Brian
-----Original Message-----
From: Barry Beattie [mailto:[EMAIL PROTECTED]
Sent: Thursday, 7 October 2004 12:44 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Access Date formats
Brian: you might have grief with the delims:
SQLServer date delims: '
Jet/MSAccess date delims: #
which means
> Where receivedDate > ###10/1/2004###
YUCK! that's why I religiously used cfqueryparams (with no grief)
you might also have issues with dd/mm/yyyy vs mm/dd/yyyy since the
internal JET db engine bypasses the MSAccess settings
try these formats instead. the second is more correct but the first
seems to work (from memory)
> Where receivedDate > #2004/1/10#
or
> Where receivedDate > #2004-1-10#
cheers
barry.b
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of KNOTT,
Brian
Sent: Thursday, 7 October 2004 11:09 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Access Date formats
I'm not having much luck with it.
-----Original Message-----
From: Mark Mandel [mailto:[EMAIL PROTECTED]
Sent: Thursday, 7 October 2004 11:01 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Access Date formats
I take it you can't use <cfqueryparam> ?
Mark
On Thu, 7 Oct 2004 10:44:58 +1000, KNOTT, Brian
<[EMAIL PROTECTED]> wrote:
>
>
>
> Does anyone know the correct format for a select statement to query an
> Access database based on a date
>
>
>
> i.e.
>
>
>
> Select *
>
> From table
>
> Where receivedDate > '10/1/2004'
>
>
>
> Brian
>
>
>
------------------------------------------------------------------------
----
-------
> This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or
one
of
> its related entities ("Suncorp").
>
> Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or
on
13
> 11 55 or at suncorp.com.au.
>
> The content of this e-mail is the view of the sender or stated author
and
> does not necessarily reflect the view of Suncorp. The content,
including
> attachments, is a confidential communication between Suncorp and the
> intended recipient. If you are not the intended recipient, any use,
> interference with, disclosure or copying of this e-mail, including
> attachments, is unauthorised and expressly prohibited. If you have
received
> this e-mail in error please contact the sender immediately and delete
the
> e-mail and any attachments from your system.
>
> If this e-mail constitutes a commercial message of a type that you no
> longer wish to receive please reply to this e-mail by typing
Unsubscribe
in
> the subject line.
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED] Aussie Macromedia Developers:
> http://lists.daemon.com.au/
--
E: [EMAIL PROTECTED]
W: www.compoundtheory.com
ICQ: 3094740
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
