AnsweredAssumed Answered

Syntax Issues Inserting Multiple Date Values in a Single SQL Statement Over The JDBC Driver in FM 11

Question asked by urinformatics on Jun 9, 2010
Latest reply on Jun 15, 2010 by TSGal

Summary

Syntax Issues Inserting Multiple Date Values in a Single SQL Statement Over The JDBC Driver in FM 11

Description of the issue

FileMaker Product(s) involved:FileMaker Pro 11.0v1 Operating System(s) involved:Windows Server 2003 Service Pack 2 Detailed description of the issue:We are using the fmjdbc.jar JDBC Driver (Class com.filemaker.jdbc.Driver) that came with our FileMaker Pro 11 installation to connect our Cold Fusion web application to our FileMaker database.  We have an issue when we attempt insert SQL statements with more than one date field in the insert statement.   e.g. INSERT INTO "Contact" (  "rec.dob" , "rec.datecon" ) VALUES (  {05/17/2002}, {06/09/2010} ) ...results in the error...   ERROR: [FileMaker][FileMaker JDBC] FQL0001/(2:50): There is an error in the syntax of the query.  If we reduce our insert statements to one date field, then we have no issues.   e.g. INSERT INTO "Contact" (  "rec.datecon" )  VALUES (   {06/09/2010} )   We have been able to reproduce this issue outside of our web application and web server using RazorSQL (http://www.razorsql.com/download_win.html) and the exact same connection information and driver to our database.  For now we are going to "work around" the issue by doing an insert with only one date field.  And then performing updates for each additional date field.  

Outcomes