Thanks Matt. I added the name attribute! :-) I then inserted your <cfqueryparam> code you sent, but I still get the same error message. (Thanks for the <cfqueryparam> tip.)
>Two things. First of all, <cfquery> requires a NAME= attribute. >Secondly, you should get into the habit of using <cfqueryparam>. Quick >reference can be found here: >http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/comm >on/html/wwhelp.htm?context=ColdFusion_Documentation&file=part_cfm.htm >This is for CF7. A little browsing will get you the livedocs for CF6.1, >if necessary. > >In this case, you can use the NULL= attribute of <cfqueryparam> instead >of all the <cfif> statements in your query body. This will make your >code more secure, easier to read, and better performing. It may also >help uncover your syntax error. > >In this case, you might have: (sorry if Outlook hoses up the >formatting...) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1305 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
