> It's a plain ol' vanilla query > > <cfquery name="get_study" datasource="#request.dsn#"> > select cycle_id, > ... > from cycle > left join week on cycle.id = week.cycle_id > left join study on week.id = study.week_id > left join person on study.person_id = person.id > where (study.id = '#url.id#') > > </cfquery> > > > If I run this in SQL server Enterprise Manager I get a fiscal year = 2009 > If it's run in a CF Template fiscal year comes back as null/1905
Are you sure you're passing the same value for URL.id in both places? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
