querysetcell on MX

[odysseus55]

Hi;
I am extracting an ODBCdate from an array, and trying to build a Query object
using QuerySetCell(). I convert the ODBCdate object to a string (using
dateformat then tried mid() function) but when I insert the string into the
queryobject, it is reconverted to a {ts date}.

Any ideas how to force the querysetcell to keep the date as a string? (Yeah I
know that I can type cast in CF7, but I gotta work with what I have).
Thanks in advance
Dale

[Adam Cameron]

> using QuerySetCell(). I convert the ODBCdate object to a string (using

> dateformat then tried mid() function)

What's the code you've got doing this?

> but when I insert the string into the
> queryobject, it is reconverted to a {ts date}.

Interesting.

> Any ideas how to force the querysetcell to keep the date as a string? (Yeah I

CFMX 6.x needs to GUESS (strange; true) what the column type is, and it's
rally bad at guessing. If you have data in the first row of the query that
looks like it could be parsed as a date, then it WILL be treated like a
date. Bleah.

One question I have... WHY are you trying to store this data as a "string
that is quite similar to a date" (give CF can still interpret it as a date)
, as opposed to just leaving it as it is? I'm sure there's a reason, but
understanding what that reason is could help solving the problem.

--
Adam

[odysseus55]

I am trying to select on the date field of the built Query object - "where datefield = 'somedate' but MX generates an error.
I have gotten a work around.

Thanks