[mod_python] error occur while comparing

You are persistent, I give you that.

Some questions you should answer yourself and which may help you
to work out what you are doing wrong.

First, what have you actually done to debug the problem? Have you
generated any debug output from your handler back to the web page
to confirm what the values being compared are and what the types
of the values are?

Since your script isn't particularly dependent on mod_python, have
you extracted it into a standalone command line script where it will
be easier to debug?

Ie., if run as a command line script, you can still use 'print' to
output debugging. If run under mod_python you need to either log debug
to the Apache log file and look in the error log file for the messages,
or write the debug back to the web browser so you can see it. For
example, you might use:

           from mod_python import apache

           for PID in cursor.fetchall():
               apache.log_error("pid=%s"%`pid`)
               apache.log_error("type pid=%s"%`type(pid)`)
               apache.log_error("PID=%s"%`PID`)
               apache.log_error("type PID=%s"%`type(PID)`)
               if pid==PID:
                   self.writeln("Equal")
               else:
                   self.writeln("Not Equal")

or:

           req.content_type = 'text/plain'
           for PID in cursor.fetchall():
               req.write("pid=%s\n"%`pid`)
               req.write("type pid=%s\n"%`type(pid)`)
               req.write("PID=%s\n"%`PID`)
               req.write("type PID=%s\n"%`type(PID)`)
               if pid==PID:
                   self.writeln("Equal")
               else:
                   self.writeln("Not Equal")

If you are going to keep posting these questions to mod_python list
instead of a list more specific to the Python DB API being used, at
least read:

  http://www.catb.org/~esr/faqs/smart-questions.html

Graham

python eager wrote ..
>   Hi ,
>       here  i am comparing both the values of form value and table value.
> But it will not work . The result will be print "not equal". Table values
> are retrieved fine. Here what mistake i did. No compilation error and run
> time error. Please solve this problem.
>    
>   Code Snippet :
>    
>             req = self.request()
>           pid = int(req.field('pid'))
>           self.writeln(pid)
>          
>             dbconnection = cx_Oracle.connect("myusername", "mypassword",
> "mydatabase")
>           cursor = dbconnection.cursor()
>           cursor.arraysize = 50
>           cursor.execute("SELECT PID FROM PERSONALDETAILS order by pid")
>           for PID in cursor.fetchall():
>              # Comparing here both formvalue and table value ( both are
> numeric)              
>               if pid==PID:
>                   self.writeln("Equal")
>               else:
>                   self.writeln("Not Equal")
>    
>   Thank you
>   Python_Eager
> 
> 
> 		
> ---------------------------------
> Yahoo! Photos – Showcase holiday pictures in hardcover
>  Photo Books. You design it and we’ll bind it!