Re: MySQL help

2005-08-03 Thread [EMAIL PROTECTED]
Hey Dennis thanks for the tips I haven't had a chance to take another stab at that code yet but I think I may try some of your suggestions. The SQL statements are valid but something doesn't appear to work right I may try and switch them to what you're suggesting and see if that helps with my

MySQL help

2005-08-01 Thread [EMAIL PROTECTED]
So i'm writing this program to check if a row exists in a table. If it doesn't it inserts it if it does it will update that row with the current info. Well it sorta works but not fully. It goes through and executes the correct querries but when it comes to determining if the row exists it

Re: MySQL help

2005-08-01 Thread deelan
[EMAIL PROTECTED] wrote: So i'm writing this program to check if a row exists in a table. If it doesn't it inserts it if it does it will update that row with the current info. (...) quick tip: are you aware of the mysql's REPLACE command? http://dev.mysql.com/doc/mysql/en/replace.html --

Re: MySQL help

2005-08-01 Thread [EMAIL PROTECTED]
I wasn't aware of the replace command I'll take a look at that tomorrow and see if it helps. Thanks quick tip: are you aware of the mysql's REPLACE command? http://dev.mysql.com/doc/mysql /en/replace.html -- http://mail.python.org/mailman/listinfo/python-list