2008-07-29, 22:37
Hi all.
I'm trying to update the song table of MyMusicDb with
sql is a well formed sql sentence. I can do SELECT's to the database and works fine, but if de sql is an "UPDATE" sentence, it doesn't work, and there is no error visible (I'm newbie, maybe I don't know where to look).
On the same way, if I query my xbox from a navigator, the select
works fine, but if I send an UPDATE sentence I get the following error:
Docs say that querymusicdatabase can be used to modify database... what I'm doing wrong
I'm trying to update the song table of MyMusicDb with
Code:
xbmc.executehttpapi( "QueryMusicDatabase(%s)" % ( sql ), ) )
sql is a well formed sql sentence. I can do SELECT's to the database and works fine, but if de sql is an "UPDATE" sentence, it doesn't work, and there is no error visible (I'm newbie, maybe I don't know where to look).
On the same way, if I query my xbox from a navigator, the select
Code:
http://<myip>/xbmcCmds/xbmcHttp?command=querymusicdatabase¶meter=select%20comment%20from%20song%20WHERE%20idsong=3404
works fine, but if I send an UPDATE sentence I get the following error:
Code:
Error:Successful result Query: PRAGMA count_changes='OFF'
Docs say that querymusicdatabase can be used to modify database... what I'm doing wrong