I've got a web application that captures user data and comments, performs some ADO SELECTS to find the user id/status/info, then dumps the data to a VFP table using an ADO connection and INSERT command. I'm getting an ODBC Error:

An error was generated on 6/29/2002 at 11:53:03 AM. Error Number = #-2147217900 Error Description = [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword. Help Context = 0 Help File Path = Error Source = Microsoft OLE DB Provider for ODBC Drivers

which only occurs when the user comments are greater than 254 characters.

mySQL = "INSERT INTO questions (date,client,firstname,lastname,email,phone,besttime,acctnumber,comments) VALUES (DATETIME()," & "'1030'," & "'" & lcFirstname & "'," & "'" & lcLastName & "'," & "'" & lcEmail & "'," & "'" & lcPhone & "'," & "'" & lcContactTime & "'," & "'" & lcAcctNumber & "'," & "'" & lcComments & "')"

Is building a COM object the best way to accomplish this? Is there something else I can do?

Thanks!