Re: [SQLObject] Storing file paths

2007/11/22, Oleg Broytmann <[EMAIL PROTECTED]>: > 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

Re: [SQLObject] Storing file paths

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

Re: [SQLObject] Storing file paths

2007/11/22, Oleg Broytmann <[EMAIL PROTECTED]>: > 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

Re: [SQLObject] Storing file paths

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 > (

Re: [SQLObject] Storing file paths

2007/11/22, Łeandro Sales <[EMAIL PROTECTED]>: > 2007/11/22, Łeandro Sales <[EMAIL PROTECTED]>: > > 2007/11/22, Oleg Broytmann <[EMAIL PROTECTED]>: > > > On Thu, Nov 22, 2007 at 01:32:22PM -0300, ?eandro Sales wrote: > > > > ... and to pass to twisted I do: > > > > > > > > def getChildWithDefau

Re: [SQLObject] Storing file paths

2007/11/22, Łeandro Sales <[EMAIL PROTECTED]>: > 2007/11/22, Oleg Broytmann <[EMAIL PROTECTED]>: > > 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_i

Re: [SQLObject] Storing file paths

2007/11/22, Oleg Broytmann <[EMAIL PROTECTED]>: > 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_pa

Re: [SQLObject] Storing file paths

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_pa

Re: [SQLObject] Storing file paths

2007/11/22, Oleg Broytmann <[EMAIL PROTECTED]>: > 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

Re: [SQLObject] Storing file paths

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 string

[SQLObject] Storing file paths

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Ã(c)A DóRIA.MP3 But when I retrieve the data