Today I've found the weird error in my project. It's because of "query of query" problem between Coldfusion 9 and Coldfusion MX 7. As Coldfusion developers know, one of the coolest features in CF is query of query and know how to use this one, either. But, being CF developer, we must know which features, functions, tags, issues, etc are fixed or missed in the every version of Coldfusion. For me, I can only know and approach which new features, functions and tags are available and being enhanced in the every version of Coldfusion except issues.

Now, I'll let you know one changes between Coldfusion 9 and Coldfusion MX 7.

I've wrote the following CF Query in Coldfusion 9. It's fine and not encounter nothing error after rendering.

view plain print about
1<cfquery name="QryReplenish" dbtype="query" datasource="MyDB">
2    SELECT * FROM GETITEMSTORE
3    WHERE REP = <cfqueryparam value="Y" cfsqltype="CF_SQL_VARCHAR">
4    ORDER BY ITEM ASC
5</cfquery>

But when I've put this CF query in Coldfusion MX 7 and render it again, encountered the following error message.

At that time, I don't know why I could get this error message in CFMX7 even it's fine in CF9. That's why I've just removed " datasource="MyDB"" in CFQuery tag and rendered it again. At that time, no error coming out oddly.

So I feel Adobe fixed this problem or skipped "datasource" attribute in cfquery for CF9 when developers using query of query.

This entry was posted on July 14, 2011 at 10:26 PM and has received 1171 views. There are currently 5 comments. Print this entry.