Yes, they're pretty recent. I know FileMaker 11 has been around for awhile, but we only installed about a month ago. We considered skipping to FileMaker 12 Server, but the client software requirement of forced upgrades made us rethink and essentially downgrade our license. They use the same JDBC drivers, though, so we stuck with them.
I should say that the resulting SQL is coming from the Terascript logs when the file is in debug mode, not the JDBC logs. The doubled quoting is in the SQL being generated before its being sent out. Erik On Feb 8, 2013, at 5:35 AM, Dan Stein <[email protected]> wrote: > Sorry that should be JDBC driver. > -- > Dan Stein MSN CPNP > FileMaker 7 Certified Developer > FileMaker 9 Certified Developer > Digital Software Solutions > 303 W. Chestnut St > Souderton PA 18964 > Land: 215-799-0192 > Cell: 610-256-2843 > FMP, WiTango,MSSQL, MySQL,PHP > [email protected] > www.dss-db.com > > > Men do not care how nobly they live, but only how long they live, although it > is within the reach of every man to live nobly, but within no man's power to > live long. Brian Haig Private Sector > > > > > > > > > On Feb 8, 2013, at 5:27 AM, [email protected] wrote: > >> 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. > > > > > ---------------------------------------- > > 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.
