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/
