Cached Query and CFQUERYPARAM

2004-10-19 Thread Jim McAtee
If I've got a query using a CFQUERYPARAM in the WHERE clause and then attempt to cache that query, will the query remain in CF's cache when called with different values for the queryparam? For example, the table 'mytable' is a very small table with just 5 rows: cfquery datasource=#dsn#

Re: Cached Query and CFQUERYPARAM

2004-10-19 Thread Jim McAtee
Whoops. Brain fart. I had removed the cfqueryparam from the WHERE clause... Makes sense now. - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 1:36 PM Subject: Cached Query and CFQUERYPARAM If I've got a query

RE: Cached Query and CFQUERYPARAM

2004-10-19 Thread Ryan Duckworth
) 754-4272 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 2:42 PM To: CF-Talk Subject: Re: Cached Query and CFQUERYPARAM Whoops. Brain fart. I had removed the cfqueryparam from the WHERE clause... Makes sense now. - Original Message