Weird SQL return

Brought to you by: akukula, alito, damoxc, exman

Weird SQL return

Forum: Open Discussion

Creator: Franck

Created: 2009-04-23

Updated: 2013-04-29

Franck - 2009-04-23

Hello,
I was trying to update some fields in my table, nothing really weird, i followed the UserGuide and created a query like this

cur.execute("UPDATE mytable SET [description]=%s where [id]=%s",(TextDescription,Idnumber))

A lot of queries did not work i went into the SQL pofiler and show that the queries that i submitted appears like
http://img411.imageshack.us/img411/3227/81749119.png so i do not get how ehere where as been changed

I even tried
cur.execute('UPDATE mytable SET [description]=\''+TextDescription.replace('\'','')+'\' where [id] LIKE \''+Idnumber+'\'')
But no success neither
Thnaks

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- A - 2009-04-23
  
  This issue is already fixed in CVS and will be fixed in pymssql 1.0.2.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Franck - 2009-04-23
  
  how would i chekout and i use it...
  I badly need it
  
  Thanks !
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Franck - 2009-04-23
  
  akukula,
  
  i got it
  
  thanks for the help !!
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.