What Justin should have put was this:
WHERE somefield =
Always use cfqueryparam for user-supplied query values!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing
> I have tried multiple combinations using the trim function, but
> none of them work.
It looks like you're putting the trim() on the value attribute of the input
field. How about the value you pass into the query? This should work:
select fields from table where
somefield = '#trim(form.field)
2 matches
Mail list logo