It's a plain ol' vanilla query
<cfquery name="get_study" datasource="#request.dsn#">
select cycle_id,
cycle.cycle_month,
cycle.cycle_year,
week_id,
week.start_date,
week.fiscal_year,
study.id,
study.pre_pretransplant,
study.pre_pediatric_clinic,
study.notes,
study.pre_ahec,
study.pre_univ,
study.pre_absent,
study.checked_in,
study.contract_number,
study.last_updated,
person.fname,
person.mname,
person.lname,
person.full_time,
person.pid,
person.physician_number,
person.dept_no,
person.study_group_id,
person.dept
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
Dave Watts wrote:
>> unfortunately their not, it's the server's query cache that has them,
>> is it possible to force them to not cache in the first place (without
>> setting the query cache setting in the CF server to 0)
>>
>
> Are you saying they're cached within the Server scope, and you
> reference them as Server.yourqueryname?
>
> If so, you can manage them just like you would any other variable. You
> can delete them using StructDelete, or overwrite them.
>
> The query cache setting in the CF Administrator affects queries cached
> with CACHEDWITHIN/CACHEDAFTER.
>
> CF doesn't cache queries automatically. You must either use
> CACHEDWITHIN/CACHEDAFTER or place your queries in Session, Application
> or Server variables.
>
> 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:313332
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
