Here is the create for the table in question: CREATE TABLE `todo` ( `taskID` int(11) NOT NULL AUTO_INCREMENT, `todo_name` varchar(255) NOT NULL, `categoryID` int(11) NOT NULL, PRIMARY KEY (`taskID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Thanks, Scott On Saturday, November 17, 2012 10:03:19 AM UTC-5, scott wrote: > > DB Schema might not hurt either. > > > On Sat, Nov 17, 2012 at 10:02 AM, Jason Macgowan > <[email protected]<javascript:> > > wrote: > >> Just tried it and it works fine for me exactly as it's written. Can you >> post entire code? >> >> >> On Sat, Nov 17, 2012 at 9:35 AM, Scott Vickery >> <[email protected]<javascript:> >> > wrote: >> >>> My apologies if this posts twice. I did not see the original post show >>> up. >>> >>> I am trying to do an insert into a mysql DB from web.py. From python, I >>> am using the MySQL library like this: >>> >>> import MySQLdb >>> I have a DB defined like this: >>> >>> db = web.database(dbn='mysql', user='root', pw='root', db='todo') >>> >>> I have the following line >>> >>> db.insert('todo', todo_name="test 2") >>> >>> Everything after the space is truncated. Any ideas on how to have the >>> entire string inserted? >>> >>> Thanks, >>> Scott >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "web.py" group. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msg/webpy/-/_eiGEEw-QdQJ. >>> To post to this group, send email to [email protected]<javascript:> >>> . >>> To unsubscribe from this group, send email to >>> [email protected] <javascript:>. >>> For more options, visit this group at >>> http://groups.google.com/group/webpy?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "web.py" group. >> To post to this group, send email to [email protected] <javascript:> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> For more options, visit this group at >> http://groups.google.com/group/webpy?hl=en. >> > > -- You received this message because you are subscribed to the Google Groups "web.py" group. To view this discussion on the web visit https://groups.google.com/d/msg/webpy/-/e9eeiu3jzJsJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/webpy?hl=en.
