I am getting the same Unsupported Numeric type error on a QofQ from a site
I'm migrating from CF5 to CFMX. It worked fine in CF5. Mine sounds only
slightly different in the fact that my QofQ is only used to order the query
results. Notice I don't have all the "tie" fields in the QofQ, could that
affect it? If anyone has any ideas or a better way to order the results, I'm
all ears...
[SNIP]
<cfset newRow = QueryAddRow(teamStandings, 1)>
<!--- set the cells in the query --->
<cfset temp = QuerySetCell(teamStandings, "site_id", "#site_id#",
#loop_count#)>
<cfset temp = QuerySetCell(teamStandings, "name",
"#organization_name#", #loop_count#)>
<cfset temp = QuerySetCell(teamStandings, "wins", "#wins#",
#loop_count#)>
<cfset temp = QuerySetCell(teamStandings, "losses", "#losses#",
#loop_count#)>
<cfset temp = QuerySetCell(teamStandings, "ties", "#ties#",
#loop_count#)>
<cfset temp = QuerySetCell(teamStandings, "dist_wins",
"#dist_wins#", #loop_count#)>
<cfset temp = QuerySetCell(teamStandings, "dist_losses",
"#dist_losses#", #loop_count#)>
<cfset temp = QuerySetCell(teamStandings, "dist_ties",
"#dist_ties#", #loop_count#)>
<cfset loop_count = loop_count + 1>
</cfloop>
<cfquery name="Standings" dbtype="query">
SELECT
site_id,
name,
wins,
losses,
dist_wins,
dist_losses
FROM teamStandings
ORDER BY dist_wins DESC
</cfquery>
-----Original Message-----
From: Sam Farmer [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 11:22 AM
To: CF-Talk
Subject: Query of Queries Error
Hi,
I have a query of queries that has been working fine until today when I
started getting the following error:
Query Of Queries runtime error.
Unsupported Numeric type conversion in Query of Queries.
Thats the extent of the error message provided! The columns seem to match
up exactly on database type and length.
Can anyone help provide some insight?
Thanks,
Sam
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
