Hey! looks like that is what the problem was. i used the MySQL Migration toolkit to transfer all the records over from Access to MySQL. man, you really saved me a lot of time and frustration. should have written in about 6 hours ago thank you very much.
On 07/18/2005 03:41:59 PM, Alberto Troiano wrote: > Hey > > Your problem is in the database > I'm surprised how MySQL let you put a space in a field > In MySQL you can't have spaces, as far as I know > Try renaming the field by enteriig to the console and making the > alter table sentence and put Site_Name instead of Site Name. Then > make the query again and see what happens > > mysql> create table d(autoinc int(4) primary key,Site Name > varchar(30)); > ERROR 1064: You have an error in your SQL syntax. Check the manual > that corresponds to your MySQL server version for the right syntax to > use near 'Name varchar(30))' > > This is the error I get from MySQL Server when I try to create a > field with a space and check the solution: > mysql> create table d(autoinc int(4) primary key,Site_Name > varchar(30)); > Query OK, 0 rows affected (0.14 sec) > > This should fix your problem. > > Best Regards to you > > Alberto > >> From: nephish <[EMAIL PROTECTED]> >> To: Alberto Troiano <[EMAIL PROTECTED]> >> CC: [email protected] >> Subject: Re: [Tutor] This should be easy >> Date: Mon, 18 Jul 2005 20:32:55 +0000 >> >> ok here is what i have, >> cursor.execute("INSERT INTO History (autoinc, Site Name) VALUES >> (888812, 'Test');") >> >> gives me this >> ''' _mysql_exceptions.ProgrammingError : (1064, "You have an error in >> your SQL syntax. Check the manual that corresponds to your MySQL >> server version for the right syntax to use near 'Name) VALUES >> (888812, >> 'Test')' at line 1") ''' >> >> the autoinc field isn't really an auto-increment field, its an int. >> That is left over from the migration from Access. >> >> there are other fields in the table but all can be null. >> >> this line works fine though >> cursor.execute("INSERT INTO History (autoinc) VALUES (888812);") >> >> this line does not >> cursor.execute("INSERT INTO History (Site Name) VALUES ('test');") >> >> can you not have spaces in a field name ? is the quotes gone awry? >> >> dont know what to do next. >> please help ! >> >> thanks >> >> >> >> >> On 07/18/2005 03:06:34 PM, Alberto Troiano wrote: >> > I think it would be better for us if you send us the entire line >> > that's giving you problems along with the error its givin you so we >> > can start somewhere >> > >> > Right now I don't know where to look at >> > >> > Best Regards >> > >> > Alberto >> > >> >> From: nephish <[EMAIL PROTECTED]> >> >> To: [email protected] >> >> Subject: [Tutor] This should be easy >> >> Date: Mon, 18 Jul 2005 20:02:38 +0000 >> >> >> >> ok here is the error i am getting. >> >> You have an error in your SQL syntax. Check the manual that >> >> corrosponds >> >> to your MySQL version for the right syntax near Name ) values >> ('one', >> >> 'two') >> >> >> >> thanks >> >> >> >> _______________________________________________ >> >> Tutor maillist - [email protected] >> >> http://mail.python.org/mailman/listinfo/tutor >> > >> > >> > Gaucho >> > >> > >> > >> >> _______________________________________________ >> Tutor maillist - [email protected] >> http://mail.python.org/mailman/listinfo/tutor > > > Gaucho > > > _______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
