I'll have to check on that but... it should be... Dave Watts wrote: >> 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:313344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
