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