I have a question about the FIELD command.
I'm searching the table for some values and then i show them in the table on the page. If the values are not there i need to still have the rows in the table but with nothing in them, i can't figure out how to do that.
Here is what i'm doing:
[SEARCH TABLE fT INTO findTemp SQL "
SELECT something1, something2 FROM table_name
WHERE some_field = 'somevalue' ORDER BY some_field"]
Then i can either do a [FOREACH ROW IN $findTemp ...]
of i can check if the $findTemp is empty or not.
My question is, if something2 is empty, how can i check it with FIELD or any other command?