RE: Form Field Validation - No Spaces

2000-05-25 Thread Henry, David B
Andy, It is possible to remove this complexity from the users by using a cfif along with the trim function. code ... This This would strip all of the spaces out from the beginning and end of the form field string. If this is not what you are looking for, let me know. I hope this helps.

RE: help with approach to complicated query

2000-05-25 Thread Henry, David B
If I am following you correctly, here is a possibility. I am assuming that you are using a checkbox that returns multiple values and you want your query to use these values. Since coldfusion passes these variables into a comma delimited list, the following code should work. SELECT (necessary