That's pretty odd. CFQUERYPARAM doesn't cache the query, binds the value to a query parameter. In fact, you can't even use in-built query caching with that tag in the query.. You sure its not caching it at a higher level somewhere?
Darryl Lyons http://dangermoose.blogspot.com [EMAIL PROTECTED] wrote on 01/06/2005 10:55:53 AM: > > Can someone tell me how CFQUERYPARAM actually works? > > I understand it caches the query, but where? in the CF server or the > database server? > > I just had an issue where I changed a query due to a column being added into > a table, and the query used the CFQUERYPARAM tag. For some reason, the > columns being returned by the query did not change. I changed the name of > the query and it still didnt work. > > This is what i had > /////////////////////////////////// > SELECT col1, col2, col3 > FROM Table > WHERE ID = <cfqueryparam value="#Arguments.ID#" > cfsqltype="CF_SQL_INTEGER"> > /////////////////////////////////// > > > I then added an extra column to the table > > I then changed the query to > /////////////////////////////////// > SELECT * > FROM Table > WHERE ID = <cfqueryparam value="#Arguments.ID#" > cfsqltype="CF_SQL_INTEGER"> > /////////////////////////////////// > > and it still only returned the 3 columns in the first example. the only way > i could get it to pick up the additional column was to remove the > cfqueryparam tag > > > Can anyone shead some light on this? > > Regards > Steve Onnis > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ To unsubscribe from this email please forward this email to [EMAIL PROTECTED] This email message is confidential and may be privileged. Unauthorised use, copying or distribution of any part of this email including attachments is prohibited. If you are not the intended recipient please forward the email to [EMAIL PROTECTED] and delete the original. ABN AMRO Morgans Limited and its associates hold or may hold securities in the companies/trusts mentioned herein. Any general advice included in this email has been prepared without taking into account your objectives, financial situation or needs. Before acting on the advice, you should consider its appropriateness or discuss with one of our investment advisors. To the extent permitted by law we exclude (and where the law does not permit an exclusion, limit to the extent permitted by law) all liability for any direct, indirect and consequential costs, losses, damages and expenses incurred in any way (including but not limited to that arising from negligence), connected with any use or access to this email or any reliance on information contained in this email or any attachments. ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of ASX Group A Principal Member of the Financial Planning Association --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
