You know, all the time I wasted trying to figure out the undocumented features of this product, I could have build my own LAMP project 3 times over.
Just by chance I discovered the answer to my query. I was trying to enter an email address with an UpdateData query and got this error message:
"multipart' immediately suggests a possible need for quotation marks, so I experimented with entering the ValueList item as "'firstname.lastname@example.org'" and lo-and-behold, it worked. Weird. A string within a string?Anyway on another hunch I tried putting one word into the ValueList field:
and I got the same error message that this thread started with (the strange message about "Invalid Column Name"). And putting the double set of quotes (" 'bread' ") removed that error message and let the UpdateQuery work.I'm beginning to believe that this ridiculously incomplete "API" for the WS is just put out there to trap people into needing their $250/hour coding services.