Re: Valid SQL?

2006-05-23 Thread John Salerno
Harlin Seritt wrote: > I am using the exact same query string generated and it works when i > type it in the MySQL client but doesn't work when using the MySQLdb > module. I've been messing around with mysqldb lately, and one reason I get your error message is if I'm not closing parentheses prop

Re: Valid SQL?

2006-05-23 Thread Harlin Seritt
I am using the exact same query string generated and it works when i type it in the MySQL client but doesn't work when using the MySQLdb module. :( -- http://mail.python.org/mailman/listinfo/python-list

Re: Valid SQL?

2006-05-23 Thread Harlin Seritt
Thanks for the help. I set up the SQL statement to be like: INSERT INTO tblFoo (field1, field2) VALUES ('value1', 'value2') I get this error: insert into Web1_DLTDS10_RootSite (dateTime, values) values('Sat Apr 15 08:58:13 2006', '0') Traceback (most recent call last): File "librarian.py", lin

Re: Valid SQL?

2006-05-23 Thread Tim Chase
> I have this string that I am sending via a Cursor.execute() using > MySQLdb: > > insert into table Ping82_eb13__elearn__ihost__com (`dateTime`, > `values`) values( > "Fri May 12 11:39:02 2006", "1") > > Does anyone see anything wrong with this SQL syntax? While this is the *python* list, rathe

Re: Valid SQL?

2006-05-23 Thread Diez B. Roggisch
Harlin Seritt wrote: > I have this string that I am sending via a Cursor.execute() using > MySQLdb: > > insert into table Ping82_eb13__elearn__ihost__com (`dateTime`, > `values`) values( > "Fri May 12 11:39:02 2006", "1") > > Does anyone see anything wrong with this SQL syntax? How about a stac

Valid SQL?

2006-05-23 Thread Harlin Seritt
I have this string that I am sending via a Cursor.execute() using MySQLdb: insert into table Ping82_eb13__elearn__ihost__com (`dateTime`, `values`) values( "Fri May 12 11:39:02 2006", "1") Does anyone see anything wrong with this SQL syntax? Thanks, Harlin Seritt -- http://mail.python.org/mai