> You can use CFQuery to call a stored proc, and thus cache it - but you
have
> to use sp_exec to do it...
I'm not sure what you mean here. You can just call the SP directly, without
using sp_exec. For example, to call an SP called GetClientDetails, passing
it a ClientId of 999:
<cfquery name="blah" datasource="blah" cachedwithin="blah">
Exec GetClientDetails @ClientId=999
</cfquery>
Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
