The following is my sql method, it can return result even i only enter one alphabet in custname but it can't work when i enter data into the custid.
select *
from customer
custid='<dtml-var custid>'
custname LIKE "%<dtml-var custname>%"
P/s let me know where is my error.TQ

Reply via email to