> I can get around this by using a <cfif
> len(trim(form.fieldname)>. Is there
> a better way to handle this? Isn't there a
> performance hit for this sort of
> quasi-dymanic sql statement?
No, because the sql string is all constructed in CF. Then the final string is
sent (all at once) to your database. So the database is not even aware of any
conditionals.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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-talk/message.cfm/messageid:329551
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
