Hello all, I am attempting to migrate an exiting CF site from a server running CFMX7 to Railo.
For the most part things are working well, but I have run into 2 problems. The first problem is when attempting to do a query of a query. I get a "variable [revenuehistory] doesn't exist" error. <CFQUERY name="RevenueHistory" datasource="#appdatasource#"> SELECT A BUNCH OF STUFF FROM MULTIPLE DATABASES AND JOIN ALL TOGETHER USING A BUNCH OF UNIONS FOR FURTHER PROCESSING IN CF </CFQUERY> <CFQUERY dbtype="query" name="GetYears"> SELECT DISTINCT PYear FROM RevenueHistory ORDER BY PYear DESC </CFQUERY> This is where the error comes. This works just fine in CFMX7. I was wondering of anyone has heard of any problems with this type of thing. I also am having trouble with links that use "/" in the query string to pass variables used with a very old version of Fusebox's formAttributes2URL custom tag. http://local.careerspecific.com/jobs.cfm/SiteID/1/CatID/881/Engineering_Jobs.htm A link like the one above gives me a 404 error. Any ideas? Thanks, Brian Cain ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345598 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
