Hi,
Would you imagine that the following code would work?
SELECT
message_type,
[attach],
[attachment],
date_time
FROM messages
WHERE
message_type = 'SWAP' AND
attach = 'Y' AND
date_time < <cfqueryparam cfsqltype="cf_sql_date"
value="#CreateODBCDate(dateadd('d',-7, now()) )#">
it doesn't. the error is:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Too few parameters. Expected 2.
Wow, it expects two parameters now......
Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter Area Health Service
Phone +61 2 49214193
Fax +61 2 49214191
[EMAIL PROTECTED]
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
