Re: error in inserting a longblob data

From: wes weston (wweston_at_att.net)
Date: 02/24/04

  • Next message: Jeremy Sanders: "Re: How can i get the parameternames of a non documented function ?" 
    Date: Tue, 24 Feb 2004 14:20:04 GMT

    ketulp_baroda@yahoo.com,

        Is it possible that the error is caused by a string
    that has an ' in it? Thus yielding something like
    'abc'xyz' - a string with an embedded '. The listed
    're looks suspecious; like it was the end of you're
    maybe.

    wes

    ketulp_baroda@yahoo.com wrote:
    > Hi
    > I am storing the attachment in the database. For some file the data
    > gets stored in the database but for other files it gives a MySql
    > error. For eg. when I am trying to attach the file say foo.txt it gets
    > stored in database correctly whereas the file bar.txt gives an error.
    > The error given is:
    >
    >
    > Traceback (most recent call last):
    > File "fakeloginserver.py", line 567, in _doRequest
    > _handleRequest(_wfile)
    > File "fakeloginserver.py", line 812, in _handleRequest
    > response.body=_theMethod(**(request.paramMap))
    > File "fakeloginserver.py", line 92, in invokeAddAttachment
    > add.addAttachment(v,filename,values)
    > File "C:\Python23\Lib\site-packages\cherrypy\code\Attachment_Model.py",
    > line 26, in addAttachment
    > n=cursor.execute("insert into attachments
    > values('%s','%s','%s','%s','%s','%s','%s','%s','%s')"
    > %(Attachment_Model.projectid[0],values['issueid'],attachID,datetime,values['attachmentdescription'],contenttype,filename,values['attachmentpath'],submitterID))
    > File "C:\PYTHON23\Lib\site-packages\MySQLdb\cursors.py", line 95, in
    > execute
    > return self._execute(query, args)
    > File "C:\PYTHON23\Lib\site-packages\MySQLdb\cursors.py", line 114,
    > in _execute
    > self.errorhandler(self, exc, value)
    > File "C:\PYTHON23\Lib\site-packages\MySQLdb\connections.py", line
    > 33, in defaulterrorhandler
    > raise errorclass, errorvalue
    > ProgrammingError: (1064, "You have an error in your SQL syntax. Check
    > the manual that corresponds to your MySQL server version for the right
    > syntax to use near 're just getting started with CherryPy, read the
    > tutorial (in do")
    >
    >
    > values['attachmentpath'] contains the file data.
    > The data type of the file data is LONGBLOB in MySql.
    > I am not getting why it works for some file but not for others.How can
    > I make it work for all files??

  • Next message: Jeremy Sanders: "Re: How can i get the parameternames of a non documented function ?"

    Relevant Pages

    • Re: return multiple rows from sql statement
      ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
      (comp.lang.php)
    • Re: return multiple rows from sql statement
      ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
      (comp.lang.php)
    • Re: return multiple rows from sql statement
      ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ... derived form..now normally I update the database, then read the data from the database back into the form: In this case I was testing 'failed to update, re-enter some data' and the backslashed stuff gave me issues with quotes and backslashes. ...
      (comp.lang.php)
    • Re: Errors installing Template CPAN module
      ... >>Now enter the data source for the test database. ... > do you have MySQL on your system? ... > just blindly hit 'Enter'?)? ... >>Use of uninitialized value in join or string at ...
      (comp.lang.perl.misc)
    • Re: INSERT statements not INSERTING when using mysql from python
      ... Well, I've checked the SQL log, and my insert statements are certainly ... But then again when I execute the problematic command manually nothing ... and after that the original tables and database is used. ... It occured to me that if I could access the mysql query log that might ...
      (comp.lang.python)