Paul Giesenhagen wrote: > If using <cfqueryparam> does it matter if you have queries "named" > the same but do different things (on different pages but in the same > application and using the same db)? > > Example one query named getProduct uses a cfqueryparam, while another > query named getProduct uses cfquery param but they are not the > structured query.
the only time that plays a role is with query caching.. cfqueryparam means you can't cache the query at a cfquery level.. the name is tied to the query for "binding" so the query text and execution plan is cached at the database level.. from memory this is per template.. so as you are using the same names in different templates, it doesn't matter z ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
