> So I'm guessing that MX is creating the msgid column as a varchar column and > it's complaining about "msgid > #attributes.cleared#" ... So does anybody > know how to set the data type on a query column created using querynew() in > MX?
I've had success with this problem by putting putting Val() around the values to be "cast" as a number. The only thing to be careful about is that if you have a blank string (i.e., ""), Val() will convert the empty string to zero. That might not matter in your case, but a warning just in case. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
