update wordpress.post set title="update", description="updated", tags='test', keywords='test', allow_comments='false', allow_pings='false', excerpt='none', convert_breaks='false', publish='true', moretext='none' WHERE blogurl = "http://yqltest.wordpress.com" and username= "yqltestuser" and password= "password" and postid=86;
However this doesn't seem to work. Can anyone point out what's wrong with the query?
Your query syntax seems correct, though the postid may need to be wrapped in quotes. I'm suspecting that the table itself is having issues. Were you able to create a new post?
This is a community table. It is not maintained by Yahoo! If you'd like to help debug it, I would recommend copying the table code ( http://github.com/yql/yql-tables/blob/mast...dpress.post.xml ) to your server, and then reference your copy via the USE declaration. For example, use "http://yourserver.com/wordpress.post.xml" as table; insert into table (title, description, blogurl, username, password) values ("Test Title", "This is a test body", "http://yqltest.wordpress.com", "yqltest", "password")
I would then start adding y.log() statements to the table code, set debug=true&diagnostics=true in the yql request, and start validating the functionality ...
If you'd like to contribute an updated table back to the repository, please fork the yql-tables repository and then send us a pull request as described in the github docs: http://help.github.com/forking/