Norbert
|
| Posted: 11/07/2004, 1:08 PM |
|
Hi,
I am building search and grid forms, however grid is based on custom sql:
SELECT *
FROM customers
WHERE i_id = {s_i_id}
AND s_name LIKE '%{s_s_name}%'
ID is taken from URL's varialble s_i_id, but as ID is of type INT I HAVE TO specify default value. And here the problem begins, because if the user does not specify customer ID then my sql query will use default value e.g. 0 and this is exactly what I do NOT want to happen, because then my grid is limited to customers that have ID=0 and does not display anything.
Any idea how to solve that problem? I will appreciate any help.
Thank you in advance
Norbert
|
. After searching the forum I found a few answers:
