> 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.
That's essentially analogous to using the ODBC call syntax. It still doesn't
let you cache the results of a CFSTOREDPROC tag, which has all kinds of
extra functionality.
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.
