Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
MySql with Long as fieldname
Hi all,
I'm trying to insert information into a MySql server from one of our customers but they have 1 field in the table with the name LONG.
If I use passthrough and put ` = backquotes around the LONG everything works ok. Now I changed everything to work with a adapter and in the UpdateNameList I used long `products.long` , if I put the quote around the first long always results in an error, but then the field just doesn't get updated.
Anybody any suggestions (since the only solution I can think of is to change the fieldname but then I have to tell the customer that he has to change the structure of the table because I can't handle the quotes, wich will leave me standing with egg all over my face of course :-) )
Guillaume
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