Selva are you manually creating the first query by using querynew() etc? there is something on this page that may or may not apply for you: http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:17237
On 9/22/06, Selvakumar Selvaraj <[EMAIL PROTECTED]> wrote: > Email : [EMAIL PROTECTED] > > Hi, > > I have a Query which results, > > DICTATOR EMAIL FEEBILLED > INSTALMENT_DATE INSTALMENT_VALUE > > Cuthbert Chris [EMAIL PROTECTED] 13374.50 2006-09-22 00:00:00.0 > 13374.50 > Pursey Simon [EMAIL PROTECTED] 11481.75 2006-09-22 00:00:00.0 > 11481.75 > Cornwell Jonathan [EMAIL PROTECTED] 25500.00 2006-09-22 00:00:00.0 > 25500 > > > I need to fetch Email ids alone from this result set. I have used > <cfquery name="QryGetEmail" dbtype="Query"> > select > EMAIL > from > MailQuery > </cfquery> > But it gives an error: > > Unsupported Numeric type conversion in Query of Queries. > > Please help to solve this issue. > Thanks in advance. > Selva > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253813 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4