Thanks Dave & Tony. I must be doing something wrong, I don't know why it's not working. The only way these tags work is if I do a cfparam with default="". I keep getting the same undefined error. Both of your ideas logically make sense and even the Not IsDefined() should work, that's what I use currently outside of the qparams. It's weird.
I did read somewhere about the db having to be set up a curtain way to accept values I think, but if my old method is working just fine, then wouldn't that mean your code should work as well? Crazy code. It's acting like JS or something.. *shivers* ><cfqueryparam null="#len(form.field)eq 0#" value="#form.field#"> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:333283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
