Thread: [SQLObject] Storing file paths
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: <lea...@gm...> - 2007-11-22 16:09:46
|
Hi list, I need to store local files paths on the database. I retrieve the filepaths from the database and stores it in the database: I declared the database field as UnicodeCol One example of a correct filepath: /home/user/MyDocs/.sounds/10 - ANDR=C3(c)A D=C3=B3RIA.MP3 But when I retrieve the data from the database I get: exceptions.OSError: [Errno 2] No such file or directory: '/home/user/MyDocs/.sounds/10 - ANDR\xe9A D\xf3RIA.MP3' This error occur when I try to open the file via twisted. Any clue? Leandro. |
From: Oleg B. <ph...@ph...> - 2007-11-22 16:26:31
|
On Thu, Nov 22, 2007 at 01:09:43PM -0300, Łeandro Sales wrote: > I need to store local files paths on the database. I retrieve the > filepaths from the database and stores it in the database: > > I declared the database field as UnicodeCol Do you put file paths to the DB as unicode or strings? Do you pass paths from the DB to Twisted as unicode or strings? If you pass paths to Twisted as unicode - does Twisted convert them to strings? Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: <lea...@gm...> - 2007-11-22 16:32:27
|
MjAwNy8xMS8yMiwgT2xlZyBCcm95dG1hbm4gPHBoZEBwaGQucHAucnU+Ogo+IE9uIFRodSwgTm92 IDIyLCAyMDA3IGF0IDAxOjA5OjQzUE0gLTAzMDAsIKNlYW5kcm8gU2FsZXMgd3JvdGU6Cj4gPiAg IEkgbmVlZCB0byBzdG9yZSBsb2NhbCBmaWxlcyBwYXRocyBvbiB0aGUgZGF0YWJhc2UuIEkgcmV0 cmlldmUgdGhlCj4gPiBmaWxlcGF0aHMgZnJvbSB0aGUgZGF0YWJhc2UgYW5kIHN0b3JlcyBpdCBp biB0aGUgZGF0YWJhc2U6Cj4gPgo+ID4gSSBkZWNsYXJlZCB0aGUgZGF0YWJhc2UgZmllbGQgYXMg VW5pY29kZUNvbAo+Cj4gICAgRG8geW91IHB1dCBmaWxlIHBhdGhzIHRvIHRoZSBEQiBhcyB1bmlj b2RlIG9yIHN0cmluZ3M/IERvIHlvdSBwYXNzIHBhdGhzCj4gZnJvbSB0aGUgREIgdG8gVHdpc3Rl ZCBhcyB1bmljb2RlIG9yIHN0cmluZ3M/IElmIHlvdSBwYXNzIHBhdGhzIHRvIFR3aXN0ZWQKPiBh cyB1bmljb2RlIC0gZG9lcyBUd2lzdGVkIGNvbnZlcnQgdGhlbSB0byBzdHJpbmdzPwo+Cj4gT2xl Zy4KPiAtLQo+ICAgICAgT2xlZyBCcm95dG1hbm4gICAgICAgICAgICBodHRwOi8vcGhkLnBwLnJ1 LyAgICAgICAgICAgIHBoZEBwaGQucHAucnUKPiAgICAgICAgICAgIFByb2dyYW1tZXJzIGRvbid0 IGRpZSwgdGhleSBqdXN0IEdPU1VCIHdpdGhvdXQgUkVUVVJOLgo+Cj4gLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LQo+IFRoaXMgU0YubmV0IGVtYWlsIGlzIHNwb25zb3JlZCBieTogTWljcm9zb2Z0Cj4gRGVmeSBh bGwgY2hhbGxlbmdlcy4gTWljcm9zb2Z0KFIpIFZpc3VhbCBTdHVkaW8gMjAwNS4KPiBodHRwOi8v Y2xrLmF0ZG10LmNvbS9NUlQvZ28vdnNlMDEyMDAwMDA3MG1ydC9kaXJlY3QvMDEvCj4gX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPiBzcWxvYmplY3QtZGlz Y3VzcyBtYWlsaW5nIGxpc3QKPiBzcWxvYmplY3QtZGlzY3Vzc0BsaXN0cy5zb3VyY2Vmb3JnZS5u ZXQKPiBodHRwczovL2xpc3RzLnNvdXJjZWZvcmdlLm5ldC9saXN0cy9saXN0aW5mby9zcWxvYmpl Y3QtZGlzY3Vzcwo+CgpJIHBhc3MgYXMgYXMgdW5pY29kZSwgdXNpbmcgdGhpcyBmdW5jdGlvbjoK CmRlZiBfZW5jKHN0cmluZyA9ICcnLCBlbmNvZGluZz0idXRmLTgiKToKICAgIGlmIHN0cmluZyBp cyBOb25lOgogICAgICAgIHN0cmluZyA9ICcnCiAgICBwcmludCBzdHJpbmcKICAgIGlmIG5vdCBp c2luc3RhbmNlKHN0cmluZywgdW5pY29kZSk6CiAgICAgICAgcmV0dXJuIHVuaWNvZGUoc3RyaW5n LCBlbmNvZGluZywgZXJyb3JzPSJpZ25vcmUiKQogICAgcmV0dXJuIHN0cmluZwoKLi4uIGFuZCB0 byBwYXNzIHRvIHR3aXN0ZWQgSSBkbzoKCiAgICBkZWYgZ2V0Q2hpbGRXaXRoRGVmYXVsdChzZWxm LCBpZCwgcmVxdWVzdCk6CiAgICAgICAgaXRlbSA9IEZhY2FkZS5zZWxlY3RfaXRlbV9ieV9pZChp ZCkKICAgICAgICBpZiBpdGVtOgogICAgICAgICAgICBsb2NhbF9wYXRoID0gaXRlbS5sb2NhbF9w YXRoCiAgICAgICAgICAgIHJldHVybiBTdGF0aWNGaWxlKGxvY2FsX3BhdGgpCiAgICAgICAgZWxz ZToKICAgICAgICAgICAgcmV0dXJuIHN0YXRpYy5EYXRhKCIiLCAiIikK |
From: Oleg B. <ph...@ph...> - 2007-11-22 16:39:10
|
On Thu, Nov 22, 2007 at 01:32:22PM -0300, ?eandro Sales wrote: > ... and to pass to twisted I do: > > def getChildWithDefault(self, id, request): > item = Facade.select_item_by_id(id) > if item: > local_path = item.local_path > return StaticFile(local_path) That is, unicode in both way. Now if anybody explains how Twisted handles unicode filename... Well, to check if it's SQLObject bug or not you are to add some debugging output (print, logging using repr()) - what bytes come in and what go out. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: <lea...@gm...> - 2007-11-22 19:39:07
|
2007/11/22, Oleg Broytmann <ph...@ph...>: > On Thu, Nov 22, 2007 at 01:32:22PM -0300, ?eandro Sales wrote: > > ... and to pass to twisted I do: > > > > def getChildWithDefault(self, id, request): > > item = Facade.select_item_by_id(id) > > if item: > > local_path = item.local_path > > return StaticFile(local_path) > > That is, unicode in both way. Now if anybody explains how Twisted > handles unicode filename... > Well, to check if it's SQLObject bug or not you are to add some > debugging output (print, logging using repr()) - what bytes come in and > what go out. > > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > Hello Oleg, I talked to one of the twisted developers and they explained me that the fileopen receives a sequence of bytes in the local_path parameter, not unicode object (retorned by twisted). I solve the problem doing local_path.encode('utf-8'). But know I got another problem. As I said, before send data to database, I encode de data to unicode calling this function: def _enc(string = '', encoding="utf-8"): if string is None: string = '' if not isinstance(string, unicode): return unicode(string, encoding, errors="ignore") else: return string.encode(encoding) But SQLObject is raising an exception: ... File "/usr/lib/python2.5/site-packages/SQLObject-0.10dev_r2852-py2.5.egg/sqlobject/sqlite/sqliteconnection.py", line 183, in _executeRetry raise OperationalError(ErrorMessage(e)) OperationalError: unrecognized token: "'Heathen Chemistry" Why is this happening? Thanks, Leandro. |
From: <lea...@gm...> - 2007-11-22 20:23:13
|
MjAwNy8xMS8yMiwgo2VhbmRybyBTYWxlcyA8bGVhbmRyb2FsQGdtYWlsLmNvbT46Cj4gMjAwNy8x MS8yMiwgT2xlZyBCcm95dG1hbm4gPHBoZEBwaGQucHAucnU+Ogo+ID4gT24gVGh1LCBOb3YgMjIs IDIwMDcgYXQgMDE6MzI6MjJQTSAtMDMwMCwgP2VhbmRybyBTYWxlcyB3cm90ZToKPiA+ID4gLi4u IGFuZCB0byBwYXNzIHRvIHR3aXN0ZWQgSSBkbzoKPiA+ID4KPiA+ID4gICAgIGRlZiBnZXRDaGls ZFdpdGhEZWZhdWx0KHNlbGYsIGlkLCByZXF1ZXN0KToKPiA+ID4gICAgICAgICBpdGVtID0gRmFj YWRlLnNlbGVjdF9pdGVtX2J5X2lkKGlkKQo+ID4gPiAgICAgICAgIGlmIGl0ZW06Cj4gPiA+ICAg ICAgICAgICAgIGxvY2FsX3BhdGggPSBpdGVtLmxvY2FsX3BhdGgKPiA+ID4gICAgICAgICAgICAg cmV0dXJuIFN0YXRpY0ZpbGUobG9jYWxfcGF0aCkKPiA+Cj4gPiAgICBUaGF0IGlzLCB1bmljb2Rl IGluIGJvdGggd2F5LiBOb3cgaWYgYW55Ym9keSBleHBsYWlucyBob3cgVHdpc3RlZAo+ID4gaGFu ZGxlcyB1bmljb2RlIGZpbGVuYW1lLi4uCj4gPiAgICBXZWxsLCB0byBjaGVjayBpZiBpdCdzIFNR TE9iamVjdCBidWcgb3Igbm90IHlvdSBhcmUgdG8gYWRkIHNvbWUKPiA+IGRlYnVnZ2luZyBvdXRw dXQgKHByaW50LCBsb2dnaW5nIHVzaW5nIHJlcHIoKSkgLSB3aGF0IGJ5dGVzIGNvbWUgaW4gYW5k Cj4gPiB3aGF0IGdvIG91dC4KPiA+Cj4gPiBPbGVnLgo+ID4gLS0KPiA+ICAgICAgT2xlZyBCcm95 dG1hbm4gICAgICAgICAgICBodHRwOi8vcGhkLnBwLnJ1LyAgICAgICAgICAgIHBoZEBwaGQucHAu cnUKPiA+ICAgICAgICAgICAgUHJvZ3JhbW1lcnMgZG9uJ3QgZGllLCB0aGV5IGp1c3QgR09TVUIg d2l0aG91dCBSRVRVUk4uCj4gPgo+ID4gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+ID4gVGhpcyBTRi5uZXQg ZW1haWwgaXMgc3BvbnNvcmVkIGJ5OiBNaWNyb3NvZnQKPiA+IERlZnkgYWxsIGNoYWxsZW5nZXMu IE1pY3Jvc29mdChSKSBWaXN1YWwgU3R1ZGlvIDIwMDUuCj4gPiBodHRwOi8vY2xrLmF0ZG10LmNv bS9NUlQvZ28vdnNlMDEyMDAwMDA3MG1ydC9kaXJlY3QvMDEvCj4gPiBfX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwo+ID4gc3Fsb2JqZWN0LWRpc2N1c3MgbWFp bGluZyBsaXN0Cj4gPiBzcWxvYmplY3QtZGlzY3Vzc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQKPiA+ IGh0dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0L2xpc3RzL2xpc3RpbmZvL3NxbG9iamVjdC1k aXNjdXNzCj4gPgo+Cj4gSGVsbG8gT2xlZywKPgo+ICAgSSB0YWxrZWQgdG8gb25lIG9mIHRoZSB0 d2lzdGVkIGRldmVsb3BlcnMgYW5kIHRoZXkgZXhwbGFpbmVkIG1lIHRoYXQKPiB0aGUgZmlsZW9w ZW4gcmVjZWl2ZXMgYSBzZXF1ZW5jZSBvZiBieXRlcyBpbiB0aGUgbG9jYWxfcGF0aCBwYXJhbWV0 ZXIsCj4gbm90IHVuaWNvZGUgb2JqZWN0IChyZXRvcm5lZCBieSB0d2lzdGVkKS4gSSBzb2x2ZSB0 aGUgcHJvYmxlbSBkb2luZwo+IGxvY2FsX3BhdGguZW5jb2RlKCd1dGYtOCcpLgo+ICAgQnV0IGtu b3cgSSBnb3QgYW5vdGhlciBwcm9ibGVtLgo+ICAgQXMgSSBzYWlkLCBiZWZvcmUgc2VuZCBkYXRh IHRvIGRhdGFiYXNlLCBJIGVuY29kZSBkZSBkYXRhIHRvIHVuaWNvZGUKPiBjYWxsaW5nIHRoaXMg ZnVuY3Rpb246Cj4KPiBkZWYgX2VuYyhzdHJpbmcgPSAnJywgZW5jb2Rpbmc9InV0Zi04Iik6Cj4g ICAgIGlmIHN0cmluZyBpcyBOb25lOgo+ICAgICAgICAgc3RyaW5nID0gJycKPiAgICAgaWYgbm90 IGlzaW5zdGFuY2Uoc3RyaW5nLCB1bmljb2RlKToKPiAgICAgICAgIHJldHVybiB1bmljb2RlKHN0 cmluZywgZW5jb2RpbmcsIGVycm9ycz0iaWdub3JlIikKPiAgICAgZWxzZToKPiAgICAgICAgIHJl dHVybiBzdHJpbmcuZW5jb2RlKGVuY29kaW5nKQo+Cj4gICBCdXQgU1FMT2JqZWN0IGlzIHJhaXNp bmcgYW4gZXhjZXB0aW9uOgo+Cj4gLi4uCj4gICBGaWxlICIvdXNyL2xpYi9weXRob24yLjUvc2l0 ZS1wYWNrYWdlcy9TUUxPYmplY3QtMC4xMGRldl9yMjg1Mi1weTIuNS5lZ2cvc3Fsb2JqZWN0L3Nx bGl0ZS9zcWxpdGVjb25uZWN0aW9uLnB5IiwKPiBsaW5lIDE4MywgaW4gX2V4ZWN1dGVSZXRyeQo+ ICAgICByYWlzZSBPcGVyYXRpb25hbEVycm9yKEVycm9yTWVzc2FnZShlKSkKPiBPcGVyYXRpb25h bEVycm9yOiB1bnJlY29nbml6ZWQgdG9rZW46ICInSGVhdGhlbiBDaGVtaXN0cnkiCj4KPiBXaHkg aXMgdGhpcyBoYXBwZW5pbmc/Cj4KPiBUaGFua3MsCj4gTGVhbmRyby4KPgoKSnVzdCB0byBjb21w bGV0ZSB0aGUgaW5mb3JtYXRpb24gcmVnYXJkaW5nIHRvIHRoaXMgcHJvYmxlbS4gSSBlbmFibGVk CnNxbG9iamVjdCBkZWJ1Zywgc2VlIHRoZSByZXN1bHRzOgoKIDgvUXVlcnlPbmU6ICBTRUxFQ1Qg Q09VTlQoKikgRlJPTSBkYl9jb250YWluZXIsIGRiX29iamVjdCBXSEVSRQooKChkYl9vYmplY3Qu dGl0bGUpID0gKCdIZWF0aGVuIENoZW1pc3RyeShSZXRhaWwpJykpIEFORAooKGRiX2NvbnRhaW5l ci5pZCkgPSAoZGJfb2JqZWN0LmlkKSkpCiA4L1F1ZXJ5UiAgOiAgU0VMRUNUIENPVU5UKCopIEZS T00gZGJfY29udGFpbmVyLCBkYl9vYmplY3QgV0hFUkUKKCgoZGJfb2JqZWN0LnRpdGxlKSA9ICgn SGVhdGhlbiBDaGVtaXN0cnkoUmV0YWlsKScpKSBBTkQKKChkYl9jb250YWluZXIuaWQpID0gKGRi X29iamVjdC5pZCkpKQogOC9DT01NSVQgIDogIGF1dG8KClNRTE9iamVjdCB2ZXJzaW9uOiBTUUxP YmplY3QtMC4xMGRldl9yMjg1Mi1weTIuNS5lZ2cKClRoYW5rcywKTGVhbmRyby4K |
From: <lea...@gm...> - 2007-11-22 20:35:36
|
MjAwNy8xMS8yMiwgo2VhbmRybyBTYWxlcyA8bGVhbmRyb2FsQGdtYWlsLmNvbT46Cj4gMjAwNy8x MS8yMiwgo2VhbmRybyBTYWxlcyA8bGVhbmRyb2FsQGdtYWlsLmNvbT46Cj4gPiAyMDA3LzExLzIy LCBPbGVnIEJyb3l0bWFubiA8cGhkQHBoZC5wcC5ydT46Cj4gPiA+IE9uIFRodSwgTm92IDIyLCAy MDA3IGF0IDAxOjMyOjIyUE0gLTAzMDAsID9lYW5kcm8gU2FsZXMgd3JvdGU6Cj4gPiA+ID4gLi4u IGFuZCB0byBwYXNzIHRvIHR3aXN0ZWQgSSBkbzoKPiA+ID4gPgo+ID4gPiA+ICAgICBkZWYgZ2V0 Q2hpbGRXaXRoRGVmYXVsdChzZWxmLCBpZCwgcmVxdWVzdCk6Cj4gPiA+ID4gICAgICAgICBpdGVt ID0gRmFjYWRlLnNlbGVjdF9pdGVtX2J5X2lkKGlkKQo+ID4gPiA+ICAgICAgICAgaWYgaXRlbToK PiA+ID4gPiAgICAgICAgICAgICBsb2NhbF9wYXRoID0gaXRlbS5sb2NhbF9wYXRoCj4gPiA+ID4g ICAgICAgICAgICAgcmV0dXJuIFN0YXRpY0ZpbGUobG9jYWxfcGF0aCkKPiA+ID4KPiA+ID4gICAg VGhhdCBpcywgdW5pY29kZSBpbiBib3RoIHdheS4gTm93IGlmIGFueWJvZHkgZXhwbGFpbnMgaG93 IFR3aXN0ZWQKPiA+ID4gaGFuZGxlcyB1bmljb2RlIGZpbGVuYW1lLi4uCj4gPiA+ICAgIFdlbGws IHRvIGNoZWNrIGlmIGl0J3MgU1FMT2JqZWN0IGJ1ZyBvciBub3QgeW91IGFyZSB0byBhZGQgc29t ZQo+ID4gPiBkZWJ1Z2dpbmcgb3V0cHV0IChwcmludCwgbG9nZ2luZyB1c2luZyByZXByKCkpIC0g d2hhdCBieXRlcyBjb21lIGluIGFuZAo+ID4gPiB3aGF0IGdvIG91dC4KPiA+ID4KPiA+ID4gT2xl Zy4KPiA+ID4gLS0KPiA+ID4gICAgICBPbGVnIEJyb3l0bWFubiAgICAgICAgICAgIGh0dHA6Ly9w aGQucHAucnUvICAgICAgICAgICAgcGhkQHBoZC5wcC5ydQo+ID4gPiAgICAgICAgICAgIFByb2dy YW1tZXJzIGRvbid0IGRpZSwgdGhleSBqdXN0IEdPU1VCIHdpdGhvdXQgUkVUVVJOLgo+ID4gPgo+ ID4gPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tCj4gPiA+IFRoaXMgU0YubmV0IGVtYWlsIGlzIHNwb25zb3Jl ZCBieTogTWljcm9zb2Z0Cj4gPiA+IERlZnkgYWxsIGNoYWxsZW5nZXMuIE1pY3Jvc29mdChSKSBW aXN1YWwgU3R1ZGlvIDIwMDUuCj4gPiA+IGh0dHA6Ly9jbGsuYXRkbXQuY29tL01SVC9nby92c2Uw MTIwMDAwMDcwbXJ0L2RpcmVjdC8wMS8KPiA+ID4gX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX18KPiA+ID4gc3Fsb2JqZWN0LWRpc2N1c3MgbWFpbGluZyBsaXN0 Cj4gPiA+IHNxbG9iamVjdC1kaXNjdXNzQGxpc3RzLnNvdXJjZWZvcmdlLm5ldAo+ID4gPiBodHRw czovL2xpc3RzLnNvdXJjZWZvcmdlLm5ldC9saXN0cy9saXN0aW5mby9zcWxvYmplY3QtZGlzY3Vz cwo+ID4gPgo+ID4KPiA+IEhlbGxvIE9sZWcsCj4gPgo+ID4gICBJIHRhbGtlZCB0byBvbmUgb2Yg dGhlIHR3aXN0ZWQgZGV2ZWxvcGVycyBhbmQgdGhleSBleHBsYWluZWQgbWUgdGhhdAo+ID4gdGhl IGZpbGVvcGVuIHJlY2VpdmVzIGEgc2VxdWVuY2Ugb2YgYnl0ZXMgaW4gdGhlIGxvY2FsX3BhdGgg cGFyYW1ldGVyLAo+ID4gbm90IHVuaWNvZGUgb2JqZWN0IChyZXRvcm5lZCBieSB0d2lzdGVkKS4g SSBzb2x2ZSB0aGUgcHJvYmxlbSBkb2luZwo+ID4gbG9jYWxfcGF0aC5lbmNvZGUoJ3V0Zi04Jyku Cj4gPiAgIEJ1dCBrbm93IEkgZ290IGFub3RoZXIgcHJvYmxlbS4KPiA+ICAgQXMgSSBzYWlkLCBi ZWZvcmUgc2VuZCBkYXRhIHRvIGRhdGFiYXNlLCBJIGVuY29kZSBkZSBkYXRhIHRvIHVuaWNvZGUK PiA+IGNhbGxpbmcgdGhpcyBmdW5jdGlvbjoKPiA+Cj4gPiBkZWYgX2VuYyhzdHJpbmcgPSAnJywg ZW5jb2Rpbmc9InV0Zi04Iik6Cj4gPiAgICAgaWYgc3RyaW5nIGlzIE5vbmU6Cj4gPiAgICAgICAg IHN0cmluZyA9ICcnCj4gPiAgICAgaWYgbm90IGlzaW5zdGFuY2Uoc3RyaW5nLCB1bmljb2RlKToK PiA+ICAgICAgICAgcmV0dXJuIHVuaWNvZGUoc3RyaW5nLCBlbmNvZGluZywgZXJyb3JzPSJpZ25v cmUiKQo+ID4gICAgIGVsc2U6Cj4gPiAgICAgICAgIHJldHVybiBzdHJpbmcuZW5jb2RlKGVuY29k aW5nKQo+ID4KPiA+ICAgQnV0IFNRTE9iamVjdCBpcyByYWlzaW5nIGFuIGV4Y2VwdGlvbjoKPiA+ Cj4gPiAuLi4KPiA+ICAgRmlsZSAiL3Vzci9saWIvcHl0aG9uMi41L3NpdGUtcGFja2FnZXMvU1FM T2JqZWN0LTAuMTBkZXZfcjI4NTItcHkyLjUuZWdnL3NxbG9iamVjdC9zcWxpdGUvc3FsaXRlY29u bmVjdGlvbi5weSIsCj4gPiBsaW5lIDE4MywgaW4gX2V4ZWN1dGVSZXRyeQo+ID4gICAgIHJhaXNl IE9wZXJhdGlvbmFsRXJyb3IoRXJyb3JNZXNzYWdlKGUpKQo+ID4gT3BlcmF0aW9uYWxFcnJvcjog dW5yZWNvZ25pemVkIHRva2VuOiAiJ0hlYXRoZW4gQ2hlbWlzdHJ5Igo+ID4KPiA+IFdoeSBpcyB0 aGlzIGhhcHBlbmluZz8KPiA+Cj4gPiBUaGFua3MsCj4gPiBMZWFuZHJvLgo+ID4KPgo+IEp1c3Qg dG8gY29tcGxldGUgdGhlIGluZm9ybWF0aW9uIHJlZ2FyZGluZyB0byB0aGlzIHByb2JsZW0uIEkg ZW5hYmxlZAo+IHNxbG9iamVjdCBkZWJ1Zywgc2VlIHRoZSByZXN1bHRzOgo+Cj4gIDgvUXVlcnlP bmU6ICBTRUxFQ1QgQ09VTlQoKikgRlJPTSBkYl9jb250YWluZXIsIGRiX29iamVjdCBXSEVSRQo+ ICgoKGRiX29iamVjdC50aXRsZSkgPSAoJ0hlYXRoZW4gQ2hlbWlzdHJ5KFJldGFpbCknKSkgQU5E Cj4gKChkYl9jb250YWluZXIuaWQpID0gKGRiX29iamVjdC5pZCkpKQo+ICA4L1F1ZXJ5UiAgOiAg U0VMRUNUIENPVU5UKCopIEZST00gZGJfY29udGFpbmVyLCBkYl9vYmplY3QgV0hFUkUKPiAoKChk Yl9vYmplY3QudGl0bGUpID0gKCdIZWF0aGVuIENoZW1pc3RyeShSZXRhaWwpJykpIEFORAo+ICgo ZGJfY29udGFpbmVyLmlkKSA9IChkYl9vYmplY3QuaWQpKSkKPiAgOC9DT01NSVQgIDogIGF1dG8K Pgo+IFNRTE9iamVjdCB2ZXJzaW9uOiBTUUxPYmplY3QtMC4xMGRldl9yMjg1Mi1weTIuNS5lZ2cK Pgo+IFRoYW5rcywKPiBMZWFuZHJvLgo+CgpBbm90aGVyIGNvbW1lbnQ6CgpSZWFsaXplIHRoYXQg dGhlIGVycm9yIG9jY3VyIGJlY2F1c2UgdGhlIGNoYXIgIiAnICIsIGFzIHRoZSBwaXBlIGNoYXIK aXMgcG9pbnRpbmcuLi4KCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS18CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICB8Ck9wZXJhdGlvbmFsRXJyb3I6IHVucmVjb2duaXplZCB0b2tl bjogIiAnIEhlYXRoZW4gQ2hlbWlzdHJ5Igo= |
From: Oleg B. <ph...@ph...> - 2007-11-22 21:22:26
|
On Thu, Nov 22, 2007 at 05:23:08PM -0300, ?eandro Sales wrote: > 8/QueryOne: SELECT COUNT(*) FROM db_container, db_object WHERE > (((db_object.title) = ('Heathen Chemistry(Retail)')) AND > ((db_container.id) = (db_object.id))) > 8/QueryR : SELECT COUNT(*) FROM db_container, db_object WHERE > (((db_object.title) = ('Heathen Chemistry(Retail)')) AND > ((db_container.id) = (db_object.id))) > 8/COMMIT : auto I don't see any problem with the query. Inside single-quotes there is a title... Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: <lea...@gm...> - 2007-11-22 21:26:13
|
2007/11/22, Oleg Broytmann <ph...@ph...>: > On Thu, Nov 22, 2007 at 05:23:08PM -0300, ?eandro Sales wrote: > > 8/QueryOne: SELECT COUNT(*) FROM db_container, db_object WHERE > > (((db_object.title) = ('Heathen Chemistry(Retail)')) AND > > ((db_container.id) = (db_object.id))) > > 8/QueryR : SELECT COUNT(*) FROM db_container, db_object WHERE > > (((db_object.title) = ('Heathen Chemistry(Retail)')) AND > > ((db_container.id) = (db_object.id))) > > 8/COMMIT : auto > > I don't see any problem with the query. Inside single-quotes there is > a title... > > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > OK, but why SQLObject tell me "Operation error"? |
From: Oleg B. <ph...@ph...> - 2007-11-22 22:16:46
|
On Thu, Nov 22, 2007 at 06:26:06PM -0300, ?eandro Sales wrote: > OK, but why SQLObject tell me "Operation error"? I don't understand it from the error message. Can you write a short test program that reproduces the problem - I will run it myself? A full program - table declaration, .createTable(), insert, select - would be the best. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: <lea...@gm...> - 2007-11-22 23:31:25
|
2007/11/22, Oleg Broytmann <ph...@ph...>: > On Thu, Nov 22, 2007 at 06:26:06PM -0300, ?eandro Sales wrote: > > OK, but why SQLObject tell me "Operation error"? > > I don't understand it from the error message. Can you write a short test > program that reproduces the problem - I will run it myself? A full program > - table declaration, .createTable(), insert, select - would be the best. > > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > I will do it... |