Still works for me with your schema.
On Sat, Nov 17, 2012 at 2:40 PM, Scott Vickery <[email protected]>wrote: > 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]>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]>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<https://groups.google.com/d/msg/webpy/-/_eiGEEw-QdQJ> >>>> . >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to webpy+un...@** >>>> googlegroups.com. >>>> >>>> For more options, visit this group at http://groups.google.com/** >>>> group/webpy?hl=en <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]. >>> To unsubscribe from this group, send email to webpy+un...@** >>> googlegroups.com. >>> >>> For more options, visit this group at http://groups.google.com/** >>> group/webpy?hl=en <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. > -- 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]. 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.
