Thanks, I will try there too. On Thu, Jun 23, 2011 at 12:16 PM, Che Vilnonis <ch...@asitv.com> wrote:
> > Have you tried the Railo Group? It's worked for me in the past. > http://groups.google.com/group/railo?lnk=srg > > ~Che > > -----Original Message----- > From: Brian Cain [mailto:bcc9...@gmail.com] > Sent: Thursday, June 23, 2011 1:13 PM > To: cf-talk > Subject: QoQ in Railo > > > 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:345600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm