Anyone Know Python?

[BChico]

Trying to write a client with Boa to connect to a MySQLdb. I dont know python very well. When i am getting data back from MySQL how should i send it to the txtbox for results...this is what i have:

try:
con = MySQLdb.Connect( host = self.server_txt_box.GetValue(),
user = self.user_txt_box.GetValue(),
passwd = self.password_txt_box.GetValue(),
db = self.database_txt_box.GetValue())

cursor = con.cursor()
query = self.query_txt_box.GetValue()
cursor.execute( query )

res = cursor.fetchall()

for rec in res:
for field in rec:
self.results_txt_box.AppendText(str(field))

con.close()

except MySQLdb.Error, e:
self.results_txt_box.AppendText("Error %d: %s" % (e.args[0], e.args[1]))


That prints everything on one line. I need to put a new line after each record is there a way to insert a carrige return or something?

Thanks

 

[AFB]

Have you tried adding "\n\r" ?

 

[BChico]

Should i put that in an appendtext?

 

[BChico]

self.xxx.AppendText("/n/r")

or either alone does not work

 

[AFB]

Originally posted by: BChico
self.xxx.AppendText("/n/r")

or either alone does not work

It's C#, but it may help.
http://www.codecomments.com/forum290/message257744.html

?

 

[Barnaby W. Füi]

It's not \n\r, or /n/r, it is "\r\n".

... Assuming this is on windows.

edit: also, use attach code.

 

[BChico]

What does attach code mean?

i have tried AppendText("\r\n")

 

[BChico]

Also for some reason in my text box i cannot even manually enter a new line, just by pressing return, is this normal?

 

[Barnaby W. Füi]

When you make a post, there is an "attach code" button, that lets you paste in code and it'll preserve whitespace and display in a monospace font. Your code is hard to read when you just paste it into your post as normal text.

If \r\n doesn't work, then I dunno. Is this textbox even capable of displaying multi-line text?

Are you even on windows? It'd help if you gave more details.

 

[BChico]

ya know sometimes i think i am retarded...forgot to add wxTE_MULTILINE to the style of the text box...god this is gonna be a long night...thanks bingbong

 

[BChico]

Im working on windows, this is a project for a databasing class. Pretty much its a client that takes in a command, you hit execute, its connects to the database, and you put the output from mysql into a results window. Im really not sure how to do exception handling thats what i have to tackle next...my prof didnt tell us anything...

EDIT: Working with Boa by the way

 

[BChico]

Is there a better way to accept the incoming data than this:

for rec in res:
for field in rec:
self.results_txt_box.AppendText(str(field))
self.results_txt_box.AppendText("\r\n")

I was using this for a command line client:

for rec in result:
for field in rec:
print field, "\t",
print