query = "select domain from apiaccess where apiaccessid=3052";
row = sql.firstRow(query);
dom = row.Domain;
The reason is that the Domain in row.Domain does not match regards case with domain in the filter string.
This works:
query = "select domain from apiaccess where apiaccessid=3052";
row = sql.firstRow(query);
dom = row.domain;
However, on an earleir version (perhaps the RC1 candidate of 1.6), the first block of code worked. There groovy expected a match with the actual mysql column name vs the filter string.
On both versions, the case used in the filter string do not need to match the mysql column names with regards to case.
No comments:
Post a Comment