Chris, ><cfquery name="getReportInformation" datasource="Reports"> >SELECT * >FROM runReports >WHERE Reportnumber = <cfqueryparam cfsqltype="cf_sql_varchar" >value="#trim(url.report)#"> ></cfquery> > >I removed the cfqueryparam, and it starts working perfectly. Why would >this break all the suddon? Any idea's?
Using <cfqueryparam /> tags and the "select *" directive, can cause problems if you insert a new column into your table. If you insert the column between existing columns, the cache query plan used by the report all of the sudden becomes corrupt. This is one of many reasons it's recommended not to use "select *" when querying data. Always explicitly set the columns you need in your code. In the long run, it'll make your coding life easier. -Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
