Ok, I still dunno what it's doin', but I fixed the damn thing! I just wrap the insert with a simple IF
<cfif FORM.criteria NEQ ""> <cfinvoke component="#APPLICATION.productDAO#" method="insertSearch" criteria="#FORM.criteria#" searchreturncount="#getsearchproducts.recordcount#"> </cfif> I left the cfparam, and it just inserts one record now. I had tried dump/abort RIGHT after the code. Just showed the usual variable. Will Did you have a <cfparam name="form.criteria" default="Foobar"> type statement that was not working? (This is the first post I've seen on this topic.) I ran into that one a while ago. It does not work. I pulled some hair out until I realized that the cfparam was not triggering because form.criteria is DEFINED, even if left empty in the form. If the field is in the form, the server is going to send it and CF is going to create it in the form structure, so the param is going to see it exist and not do anything. So you have to do basically what you did. But I usually use this, it accounts for fields that may only contain white space, but not technically be empty. <cfif len(trim(form.criteria))> Do something with form.criteria <cfelse> form.criteria is empty do something else </cfif> -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226966 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
