RE: reorder a query

2010-01-12 Thread Chad Gray
ay, January 12, 2010 2:06 PM > To: cf-talk > Subject: RE: reorder a query > > > Hope that at least pointed you in the right direction Chad. I know the > queries were different but the method was sound. > > > Robert B. Harrison > Director of Interactive Services &g

RE: reorder a query

2010-01-12 Thread Robert Harrison
Hope that at least pointed you in the right direction Chad. I know the queries were different but the method was sound. Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.a

Re: reorder a query

2010-01-12 Thread Qing Xia
Could it be that one (or more) of the rows in column reOrder is of type Double while the other rows are all of type string? I am guessing maybe you want a numeric value in this row but one of more rows got empty. On Tue, Jan 12, 2010 at 1:34 PM, Chad Gray wrote: > > While I am looking over Robe

RE: reorder a query

2010-01-12 Thread Chad Gray
Never mind... figured it out. I needed javaCast when setting the values of the Array. > -Original Message- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Tuesday, January 12, 2010 1:35 PM > To: cf-talk > Subject: RE: reorder a query > > > While I

RE: reorder a query

2010-01-12 Thread Chad Gray
While I am looking over Roberts code that he sent me why would I get a casting error for this code? I take the ORDER BY statement out of the Query of a Query and it does not error. Error casting an object of type java.lang.Double cannot be cast to java.lang.String to an incompatible type.

RE: reorder a query

2010-01-12 Thread Robert Harrison
Chad... can't attach files to the list, but I'm sending you a CF Routine that does exactly that... coming shortly. Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin