Well I am home for the weekend at this point and wont have access to the program until Monday. I'll check that first thing though and let you know. What little I do know is it as number formatted like this 99082.00 and occassionally the cell is blank.
And yeah i do think that is the code that is wrong but I can't figure out why. Thanks again for the help and I'll let you know what that value is on Monday >What I'm after is trying to check the value that is coming from the query >for the value "McsalProjNumb" that you're using in your form in the input: > ><input type="text" name="McsalProjNumb" id="UPMcsalProjNumb" size="15" >value="#McsalProjNumb#"> > >Isn't that the line you said the error message is referencing? > >Also, put <cfabort> right after the <cfdump...> to prevent the rest of the >page from running and see what the McsalProjNumb value is returned as in the >query. > >Rick > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4964 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
