Hello all,
I am looking for an efficient way to handle database calls.
1.Probably something like caching the Dataset and
querying the cached dataset, is something like this possible.?
<!-- this query returns more than 100,000 records-->
<cfquery Name="Get_All_Data" Datasource="Test"
CACHEDWITHIN=#CreateTimeSpan(0, 10, 0,0)#>
Select * from Big_Table
</cfquery>
<!-- now is it possible to query the above Dataset, something
like -->
<cfoutput Query="Get_All_Data">
<cfquery Name="Get_Sub_Data" Datasource="Get_ALL_Data">
Select * from where field1=#Var1# and Field2="#Var2#
</cfquery>
</cfoutput>
Is something to this effect possible?
2.How do u refresh a CfQuery, when the page Refresh/reloads,
this is th instance where
where form is submitted to the same page itself.?
Appretiate it.
Have a good weekend.
Thanks
Joe
----------------------------------------------------------------------------
--
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
