In the past I've found that creating a dynamic query with the first row being the "data type" you want the columns to be works best. In your example, the first row could contain the "**CHAR**" for the column value, and then you append the rest of the rows from the query into the query object. In your QofQ you'd just filter out the dummy first row.
Of course, this is all in CF6.1 though... --- 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/
