After selecting a set of data with a JDBC select adapter, we are trying to perform another select based on the first set of data. One of the fields should be just a VARCHAR, saved as a String. But when we try to use it in the WHERE clause, no values are found.
Running in debug mode, the value looks appropriate. But when I click on it, the value shows four extra square/box characters. Another forum thread mentioned that the view may simply not be able to display the value correctly. But surely there is actually something extra in the field if the subsequent SQL Select is failing?
Could the issue be something with the way the value is selected or stored?