RE: QofQ data type assignation
I've been thining of writing and releasing a queryCast() function to fix this, but no-one has been interested so far. -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Wednesday, 19 January 2005 3:41 To: CF-Talk Subject: RE: QofQ data type assignation AFAIK this is correct. There have been many discussions on this topic (and some possible workarounds) in this list Pascal -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: 19 January 2005 08:36 To: CF-Talk Subject: QofQ data type assignation Can someone verify how the QofQ functions assign datatypes to the columns of a query passed into it on CFMX 6.1?? My suspicion is that it typecasts the whole dataset based on a test case of the first row of data in the query you are querying... If someone can verify this or correct my assumption then I'd be most grateful. Paul ~| 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:191044 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
Re: QofQ data type assignation
how the QofQ functions assign datatypes to the columns of a query passed into it on CFMX 6.1?? It guesses. My suspicion is that it typecasts the whole dataset based on a test case of the first row of data in the query you are querying... Your suspicion is right. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:191057 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: QofQ data type assignation
I've been thining of writing and releasing a queryCast() function to fix this, but no-one has been interested so far. I think the problem is not being interested, but HOW one would do it. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191058 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
RE: QofQ data type assignation
I think the problem is not being interested, but HOW one would do it. I agree with the intrest part, this has been a thorn in my side with using Q in Q ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191061 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
RE: QofQ data type assignation
We had this problem, I believe we wrote a a udf which appended an initial first row using the queryAddRow(), setcell() functions HTH Kola -Original Message- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: 19 January 2005 16:26 To: CF-Talk Subject: RE: QofQ data type assignation I think the problem is not being interested, but HOW one would do it. I agree with the intrest part, this has been a thorn in my side with using Q in Q ~| 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:191081 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: QofQ data type assignation
Thanks all for the responses... After much digging on Google I found that the MM livedocs seems to have turned into a forum where QofQ is concerned and there are a few different workarounds published there but the main thrust of the docs say it's broke in CFMX and should be fixed in Blackstone... Paul ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191118 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: QofQ data type assignation
It's actually not very difficult. You convert the query to WDDX, edit the WDDX packet (with XSLT or whatever) to change the types for the columns and then convert back to a query. It' just a matter of finding time to write it and I can only be bothered doing that if people will use it. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, 19 January 2005 10:46 To: CF-Talk Subject: Re: QofQ data type assignation I've been thining of writing and releasing a queryCast() function to fix this, but no-one has been interested so far. I think the problem is not being interested, but HOW one would do it. ~| 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:191137 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
RE: QofQ data type assignation
AFAIK this is correct. There have been many discussions on this topic (and some possible workarounds) in this list Pascal -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: 19 January 2005 08:36 To: CF-Talk Subject: QofQ data type assignation Can someone verify how the QofQ functions assign datatypes to the columns of a query passed into it on CFMX 6.1?? My suspicion is that it typecasts the whole dataset based on a test case of the first row of data in the query you are querying... If someone can verify this or correct my assumption then I'd be most grateful. Paul ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191043 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54