Are you sure you have the latest HSBC driver for FileMaker?
Sent from My Web Mail Account Dan Stein MSN, CPNP, EMT-B [email protected] www.dss-db.com land: 215-799-0192 ---------------------------------------- From: "Erik Gorka" <[email protected]> Sent: Thursday, February 07, 2013 7:45 PM To: [email protected] Subject: TeraScript-Talk: noSQLEncoding config ignored 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. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
