I had a similar issue trying to get an ORDER BY to work on a value that QoQ didn't like.
I ended up looping through the query and adding 0 to each value. After that, it recognised it as a number, and I could order with without a problem. (There was a udf on cflib that helped with the looping) Maybe try that? Mark On Wed, 23 Mar 2005 07:50:00 +1000, Darryl Lyons <[EMAIL PROTECTED]> wrote: > Darren, > > Datacasting is possible with dynamic queries by inserting a "dummy row" as > the first row... As far as I am aware, ColdFusion MX looks at the first > row to learn the data types. Perhaps you could create a new dynamic query > and populate it with the verity query, where the first (dummy) row > contains all of columns defined as integers. > > E.g. > > QuerySetCell(qData, "Column1" , 0); > QuerySetCell(qData, "Column2" , 0); > QuerySetCell(qData, "RecordType" , "dummy"); > > You would of course need to filter out the dummy row, but this should > work. > > Darryl > http://dangermoose.blogspot.com -- 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/
