>Oh my goodness me, still wrong! Should be:
>
>SELECT email
>FROM user u
>WHERE country = <cfqueryparam cfsqltype="cf_sql_varchar"
>value=#somecountry#>
>AND ( Len('<cfqueryparam cfsqltype="cf_sql_varchar" value=#somestate#>') = 0
>
> OR state = <cfqueryparam cfsqltype="cf_sql_varchar" value=#somestate#>)
>
>Phew!
>
>Dom
Interesting idea, Dom. Thanks. But do you really need the quotes around the
cfqp inside the len() statement? I would think not.
Ben
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291993
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
