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
where
custid='<dtml-var custid>'
OR
custname LIKE "%<dtml-var custname>%"
 
 
P/s let me know where is my error.TQ

Reply via email to