We're running Terascribe Server 6.2 and are in the process of upgrading our
FileMaker 10 server which we've been accessing via JDBC to FileMaker 11. Seems
FileMaker 11 is very picky about data typing, which has revealed a problem
where, in some cases, part of the SQL is having its single quotes doubled,
breaking the query.
As mentioned it is not doing this in all cases, but refuses to let go of this
one. I've tried turning the "noSQLEncoding" configuration to "true", but the
setting is being ignored. In this case, we're creating a list of items for an
"IN" statement based on an array, like this:
and position in (<@rows array="request$postionList"><@if expr="<@currow> !=
1">, </@if>'<@col 1>'</@rows>)
This list of positions are numbers, the the field in FileMaker is a text field.
So if I remove the quotes it breaks because the items are not of the correct
type (worked fine for FM 10 but not for 11), but add the quotes and the
resulting sql in the logs looks like this:
and position in (''05040'', ''24762'', ''24763'', ''72010'')
There are other quoted parts of the statement above this one, but only this
part is getting the doubled single quote treatment. Is this a bug or am I doing
something wrong?
Erik Gorka
Reed College
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe terascript-talk" in the body.
