Index: openacs-4/packages/ecommerce/www/admin/customer-service/interaction-add-2.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/interaction-add-2.tcl,v diff -u -r1.10 -r1.11 --- openacs-4/packages/ecommerce/www/admin/customer-service/interaction-add-2.tcl 25 Aug 2008 12:47:54 -0000 1.10 +++ openacs-4/packages/ecommerce/www/admin/customer-service/interaction-add-2.tcl 25 Jul 2018 02:09:22 -0000 1.11 @@ -188,7 +188,7 @@ set additional_and_clause "and user_identification_id not in ([join $already_selected_user_identification_id_list ", "])" } if { ![empty_string_p $other_id_info] } { - set sql "select user_identification_id as d_user_identification_id from ec_user_identification where other_id_info like '%[DoubleApos $other_id_info]%' $additional_and_clause" + set sql "select user_identification_id as d_user_identification_id from ec_user_identification where other_id_info like [ns_dbquotevalue %${other_id_info}%] $additional_and_clause" db_foreach get_user_identification_info $sql { append customer_id_html "
  • This may be the non-registered person who has had a previous interaction with us: [ec_user_identification_summary $d_user_identification_id "t"] (check here if this is correct).
  • " lappend already_selected_user_identification_id_list $d_user_identification_id