Re: Query of Queries error - solution

I have no doubt that it would be put to good use by many if you did... --Jeff On 6/23/2005 10:07 AM, James Holmes wrote: > Would it help if I made good on my threat to write a QueryCast() UDF for CF > 6.1? > > On 6/23/05, Jeff Langevin <[EMAIL PROTECTED]> wrote: > >>Oh yes, and I used the cas

RE: Query of Queries error - solution

awesome... good tip... (still a kludge though - ha)... -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 7:52 AM To: CF-Talk Subject: Re: Query of Queries error - solution Thanks for the idea. I still had problems though. So I added a dummy

Re: Query of Queries error - solution

Would it help if I made good on my threat to write a QueryCast() UDF for CF 6.1? On 6/23/05, Jeff Langevin <[EMAIL PROTECTED]> wrote: > Oh yes, and I used the cast in the other query to get QoQ to play > nicely. Thanks! > > cast(OrderDetails.Order_ID AS varchar(12)) AS Order_ID, > > --Jeff > >

Re: Query of Queries error - solution

Oh yes, and I used the cast in the other query to get QoQ to play nicely. Thanks! cast(OrderDetails.Order_ID AS varchar(12)) AS Order_ID, --Jeff On 6/23/2005 8:52 AM, Jeff Langevin wrote: > Thanks for the idea. I still had problems though. So I added a dummy > row using querySetCell() wher

Re: Query of Queries error - solution

Thanks for the idea. I still had problems though. So I added a dummy row using querySetCell() where the offending column's value was set to "aaa" (I think someone might have suggested something like this earlier). This is a value that would never occur in "real life". On the next process th