Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
ADO problem inserting Memo data
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!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement