Query by date doesn't work

[wantaknowcf]

I'm using Informix 9.3, If I run the query in Informix it works, when I run
the same query in ColdFusion I get a string to date conversion. I'm using the
Informix JDBC that comes with ColdFusion 6.1.
SELECT uid, sdate
FROM train_cal_test
WHERE sdate>'10/30/2005'
I've tried the date with and without single and double quoates.

[jonwrob]

Try the CF function CreateODBCDate() or the Informix equivalent of TO_DATE to force the correct date-string conversion.

JR

[Diacritical]

User CFQUERYPARAM... it's not just good security, it speeds things up and
resolves these variable casting problems:

SELECT uid, sdate
FROM train_cal_test
WHERE sdate > <cfqueryparam cfsqltype="cf_sql_date"
value="10/30/2005">;

[BKBK]

Wantaknowcf, is this an idea?

SELECT uid, sdate
FROM train_cal_test
WHERE sdate > DATE('10/30/2005')

[wantaknowcf]

Thank you for the input. I use the date qualifier when running a query against the database and it work. I use createODBCdate when I need to save a date to the database.

[wantaknowcf]

I want to thank everyone for their help. I found several thinks I did wrong.
My biggest mistake was quotes around the form.date when adding or editing. I
use Dreamweaver to create the add query and it adds the quotes. I know to
remove them now. Informix has a date qualifier that I'm using a query to
search, like this. where date(sdate)> date(session.svsdate).
When I use a form to add a date to the database I use two methods to choose.
One is CreateODBCdate() and the other is CFquerypram with the type and value.
Thanks again with everyones help I have my date problems in Informix under
control.