<html><div style='background-color:'><DIV class=RTE>Hi,</DIV>
<DIV class=RTE>I am new in the forum...</DIV>
<DIV class=RTE>I have a little project to present in my class in python ,but I found troubles with my program... the program represent a class loggin ,to verify user and password from a table in sql oracle ...here is a part from the code ...I know I have so many mistakes ...that's why I ask you to help me...</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>N.B : my class should be called by another program (main program)and should not be the main ...</DIV>
<DIV class=RTE>my partners are developping there own programs like graphical loggin,creating tables ,inventories ...</DIV>
<DIV class=RTE>--------------------------</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>import cx_Oracle<BR>droit=""<BR>class Loggin(object):</DIV>
<DIV class=RTE> <BR> </DIV>
<DIV class=RTE> def testuser(name_user,pass_user):</DIV>
<DIV class=RTE> <BR> self.conn= cx_Oracle.connect('a5harris','a','Hades')<BR> self.curseur = self.conn.cursor()<BR> self.curseur.fetchall()<BR> nblignes = self.curseur.rowcount<BR> print nblignes<BR> self.curseur.execute ("Select * from usagers")<BR> print self.curseur.fetchone()<BR> print self.curseur.fetchraw([numRows = self.curseur.arraysize])</DIV>
<DIV class=RTE> print self.curseur.fetchone()</DIV>
<DIV class=RTE> for i in range (nblignes):<BR> print self.curseur.fetchone()</DIV>
<DIV class=RTE> print self.curseur.fetchone()[0]</DIV>
<DIV class=RTE> while nblignes:</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE> if ( name_user=self.curseur.execute("select name from usagers where name='carl'")<BR> and pass_user=self.curseur.execute("select pass from usagers where name='carl'")):<BR> droit=self.curseur.execute("select droit from usagers where name='carl'")<BR> return droit</DIV>
<DIV class=RTE> if ( name_user=self.curseur.execute("select name from usagers where name='ismail'")<BR> and pass_user=self.curseur.execute("select pass from usagers where name='ismail'")):<BR> droit=self.curseur.execute("select droit from usagers where name='ismail'")<BR> return droit</DIV>
<DIV class=RTE> if ( name_user=self.curseur.execute("select name from usagers where name='hua'")<BR> and pass_user=self.curseur.execute("select pass from usagers where name='hua'")):<BR> droit=self.curseur.execute("select droit from usagers where name='hua'")<BR> return droit</DIV>
<DIV class=RTE> <BR> if ( name_user=self.curseur.execute("select name from usagers where name='dominique'")<BR> and pass_user=self.curseur.execute("select pass from usagers where name='dominique'")):<BR> droit=self.curseur.execute("select droit from usagers where name='dominique'")<BR> return droit<BR> <BR> <BR> if ( name_user=self.curseur.execute("select name from usagers where name='serge'")<BR> and pass_user=self.curseur.execute("select pass from usagers where name='serge'")):<BR> droit=self.curseur.execute("select droit from usagers where name='serge'")<BR> return droit<BR> <BR> if ( name_user=self.curseur.execute("select name
from usagers where name='abdel'")<BR> and pass_user=self.curseur.execute("select pass from usagers where name='abdel'")):<BR> droit=self.curseur.execute("select droit from usagers where name='abdel'")<BR> return droit</DIV>
<DIV class=RTE> def getNext(self):<BR> print self.curs.fetchone()</DIV>
<DIV class=RTE> def newSQL(self,monsql):<BR> self.curs.execute(monsql)</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE><BR>if __name__ == "__main__":<BR> maDb=Loggin()<BR> maDb.testuser("ismail","ismail")<BR> print maDb.conn<BR> maDb.getNext()</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>-------------------</DIV>
<DIV class=RTE>I don't have much time ...please help me</DIV></div><br clear=all><hr>Il ne vous reste qu’une semaine pour entreprendre un voyage virtuel dans le cadre du concours <a href="http://g.msn.com/8HMBFRCA/2731??PS=47575" target="_top">Le tour du monde de MSN Recherche.</a> </html>