Hiya - I too store WDDX and structures in query cells - So it WAS YOUR FAULT it's broken :p - My own stooped fault for not testing EVERYTHING while it was in Beta - bugger!
As I say I've kludged it for now by writing a quick custom tag but it seems too klunky - I'm sure at Java code level they could perform it a lot quicker - particularly on large result sets. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.co.uk -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 10 February 2005 13:03 To: CF-Talk Subject: RE: New CF7 feature request - please support it - Casting query c olumns Ah, this just proves that we should all be careful what we wish for in the first place. The query object in CF6 can store anything you want with no complaint - I even store structs in query cells (using the query as a 2D array of structs with named columns). We asked for control over typing in queries and this is what we got. Oops. It sounds like it's time to write that QueryCastColumn UDF after all... -----Original Message----- From: Martin Parry [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 February 2005 8:17 To: CF-Talk Subject: New CF7 feature request - please support it - Casting query columns I have today posted a feature request on MM's website.. If anyone else agrees with it and would us it please also request it. Due to changes in the way CF7 handles casting on queries, I can no longer populate a string value into an integer column using <cfset QuerySetCell(....)>. Assuming I had a unique_id of 21014 I may want to prefix this with PID_ - I now get a manky error - Invalid data PID_21014 for CFSQLTYPE CF_SQL_INTEGER. A <cfset QueryCastColumn(myQuery, "columnName", "cf_sql_varchar")> would be a real bonus as I'm now needing to kludge around this. Post it on... http://www.macromedia.com/support/email/wishform/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194029 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
