Ok. I'll track it down. Will post what the issue is for others who may run into it.
Scott On Saturday, November 17, 2012 2:46:30 PM UTC-5, scott wrote: > > Same here. Next guess would be the way you are selecting/viewing the data > stored in your table. > > Sent from my iPhone > > On Nov 17, 2012, at 2:45 PM, Jason Macgowan > <[email protected]<javascript:>> > wrote: > > Still works for me with your schema. > > > On Sat, Nov 17, 2012 at 2:40 PM, Scott Vickery > <[email protected]<javascript:> > > 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] <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/-/Y8VkjHoKG2UJ. 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.
