trying to do the following query:
SELECT *
FROM tblCheckout
WHERE
videoID = <cfqueryparam value="#URL.videoID#" cfsqltype="cf_sql_integer"> AND
actual_returndate = <cfqueryparam value="" cfsqltype="cf_sql_date" null="yes">
i'm getting 0 records returned, where I know there is 1 record that matches the criteria.
I'm getting hung up on the actual_returndate value, where i'm searching for a NULL.
it works without <cfqueryparam>:
SELECT *
FROM tblCheckout
WHERE
videoID = <cfqueryparam value="#URL.videoID#" cfsqltype="cf_sql_integer"> AND
actual_returndate IS NULL
returns the record i'm looking for.
Am I using <cfqueryparam> wrong here?
Thx!
Charlie
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
