Re: Fulltext doesn't seem to find certain text

2004-09-14 Thread Blake Schroeder
;foo, inc'. Why? Mysql 3.23.52 -- +-+-----++ | Blake Schroeder | Owner/Developer |lhwd.net| +--(http://www.lhwd.net)+--/ \--+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: inserting works fine but I cant update.

2004-06-09 Thread Blake Schroeder
Dan Great suggestion also. -Blake Dan Nelson wrote: In the last episode (Jun 09), Blake Schroeder said: Query UPDATE table SET 1 = '1' WHERE id = '1' |#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right

Re: Update problem

2004-06-09 Thread Blake Schroeder
Paul Thanks alot that help out alot. -Blake Paul McNeil wrote: You have to use UPDATE MyTABLE set MyTABLE.1 = myValue. Otherwise you are saying that the numeric value 1 = some other numeric value. God Bless GOD BLESS AMERICA! To God Be The Glory! -- MySQL General Mailing List For list arc

Re: inserting works fine but I cant update.

2004-06-09 Thread Blake Schroeder
The type is a varchar. -Blake Ronan Lucio wrote: Blake, Query UPDATE table SET 1 = '1' WHERE id = '1' |#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 '1 = '1' WHERE id = '1'' at line 1 Is the

Re: inserting works fine but I cant update.

2004-06-09 Thread Blake Schroeder
ke | Dan Nelson wrote: In the last episode (Jun 09), Blake Schroeder said: I am having a update problem, I have a table that has 28 columns they are name 1-28. I am able to insert data into the table. When I try to update info into the table it does not work. Any ideas? Not until you tell us th

inserting works fine but I cant update.

2004-06-09 Thread Blake Schroeder
I am having a update problem, I have a table that has 28 columns they are name 1-28. I am able to insert data into the table. When I try to update info into the table it does not work. Any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht