I haven't verified that there is actually anything in the cached query but
the debug does say (Records=1, Time=Cached Query)
<cfquery name="GetUser" datasource="#datasource#"
cachedwithin="#CreateTimeSpan(0,1,0,0)#">
exec sp_getUser @username = '#client.username#', @password =
'#client.password#'
</cfquery>
You could give it a try.
Jeff Craig
----- Original Message -----
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 11, 2000 7:09 PM
Subject: RE: CFSTOREDPROC and caching
> > As far as I can tell, there are no caching attributes for
> > CFSTOREDPROC the way there are for CFQUERY. Has anyone
> > developed a generic tag to implement this? It should
> > theoretically be possible to mimic CFSTOREDPROC and keep
> > all the relevant stuff in server variables, but I don't
> > think it's trivial, and I don't want to do it if someone
> > else has.
>
> It's an unfortunate omission that CFSTOREDPROC doesn't support the query
> caching introduced in CF 4. However, if you're using a platform that
> supports the ODBC call syntax for executing stored procedures through the
> CFQUERY tag, you can call your stored procedure and have it cached:
>
> <cfquery name="foo" datasource="bar"
> cachedwithin="#CreateTimeSpan(1,0,0,0)#">
> { call mysp(#mynumericparam#, '#mystringparam#') }
> </cfquery>
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> 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.mail-archive.com/[email protected]/
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.
