> We need to compare 2 values. One is an integer and comes from an MS SQL
> query and the other is a string that is returned from a verity quiery, that
> was put in as an integer but is being returned as a string.
> QofQ throws an error.

There is a cast() function in CFMX7, but not in CFMX6, unfortunately.  The
quickest way of forcing correct typing on a column in CFMX6 was to WDDX it
and change the datatype in there, and then un-WDDX it again.  This has some
nasty overhead on large queries.

-- 

Adam

---
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/

Reply via email to