No Value Given For One Or More Required Parameters. |
When you get this error, look for quotes in your parameters, like this: UPDATE Table_Production SET TesterStart= <cfif IsDefined("FORM.TesterStart") AND #FORM.TesterStart# NEQ ""> '#FORM.TesterStart#' <cfelse> NULL </cfif> , "TesterEnd"= <cfif IsDefined("FORM.TesterEnd") AND #FORM.TesterEnd# NEQ ""> '#FORM.TesterEnd#' <cfelse> NULL </cfif> , TodayDate= <cfif IsDefined("FORM.TodayDate") AND #FORM.TodayDate# NEQ ""> '#FORM.TodayDate#' <cfelse> I don't know where they came from, probably Dreamweaver. I know, I know, nobody should use Dreamweaver, etc., etc. |
Archives