General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only