.asp ODBC SequeLink error QUERY FAILED

[BearRiver]

Hi I have an .asp site that queries our Filemaker database and it usually runs fine without problems. However about once a day a random user gets the following error ][ODBC FileMaker driver][FileMaker]Query Failed .

This error occurs on an INSERT statement on the Set rsInfo = oConn.execute(strSQL). I don't see anything wrong in the code and it works successfully on dozens of instances of the same event each day.

Please let me know if you have any ideas or need any more clues. Thank you for your time!

[BearRiver]

I figured out what was going on and wanted to let anyone else with this problem know the answer...

This error was caused by a date field in the query using a 10 digit date...in other words a "mm/dd/yyyy" date crashes the query, which is why this just started popping up at the end of the year... 9/31/2008 in the query is ok but 10/31/2008 crashes the query. I came up with a workaround for my solution that strips the "20" from the year so the dat is only mm/dd/yy.