2007/11/23, Leandro Sales <[EMAIL PROTECTED]>:
> 2007/11/23, Leandro Sales <[EMAIL PROTECTED]>:
> > 2007/11/23, Oleg Broytmann <[EMAIL PROTECTED]>:
> > > On Fri, Nov 23, 2007 at 08:58:22AM -0300, ?eandro Sales wrote:
> > > > OK. Any comment about the error?
> > >
> > >    I cannot run the program - I don't have ID3 module.
> > >
> > > PS. I stopped using ID3.py long ago. These days I use eyeD3. You can find
> > > my public scripts at http://phd.pp.ru/Software/misc/cdr-mp3-video-tools/
> > >
> > > Oleg.
> > > --
> > >      Oleg Broytmann            http://phd.pp.ru/            [EMAIL 
> > > PROTECTED]
> > >            Programmers don't die, they just GOSUB without RETURN.
> > >
> >
> > I will see your suggestion later. It seems that it is good.
> >
> > Well, since you don't have ID3 module, I'm sending to you a new
> > version of the example that include the id3 module. Please, consider
> > this one. Please, let me know if now it is right.
> >
> > Leandro.
> >
> >
>
>
> Hello Oleg,
>   I realized that the problem is not when the data is insert. Instead,
> the problem occurs when I call musicAlbum.count().
>
>   File 
> "/home/leandro/workspace/BRisa/brisa/media_services/cds/plugins/filesystem/persistence/Facade.py",
> line 163, in add_music_track
>     if musicAlbum.count() > 0:
>   File "/usr/lib/python2.5/site-packages/sqlobject/sresults.py", line
> 197, in count
>     count = self.accumulate('COUNT(*)')
>   File "/usr/lib/python2.5/site-packages/sqlobject/sresults.py", line
> 179, in accumulate
>     return conn.accumulateSelect(self, *expressions)
>   File "/usr/lib/python2.5/site-packages/sqlobject/dbconnection.py",
> line 418, in accumulateSelect
>
> Error while loading plugin filesystem
> Exception type / message: <class
> 'sqlobject.dberrors.OperationalError'> / unrecognized token: "'Heathen
> Chemistry"
>
> ...
>     musicAlbum = select_container_by_title(title=kwargs["album"])
>     if musicAlbum.count() > 0:
>         musicAlbum = musicAlbum[0]
> ...
>
> It seems a problem regarding to count() function.
>
> Any clue?
>
> Leandro
>

When I "print musicAlbum" I get:

SELECT db_container.id, db_container.container_id,
db_container.child_name FROM db_container, db_object WHERE
(((db_object.title) = ('Heathen Chemistry

Where is the rest of the SQL statement?

Leandro.

-------------------------------------------------------------------------
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
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to