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
> 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
Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
_______________________________________________ DB-SIG maillist - [email protected] http://mail.python.org/mailman/listinfo/db-sig
