lol. The problem was in the display, not the persistence: <input type="text" name="task_name" value='$todo.todo_name></input> vs <input type="text" name="task_name" value='$todo.todo_name'></input>
I had no quotes around my value. I jumped to the conclusion the framework was doing something incorrect. Sorry for the waste of bandwidth. Scott On Saturday, November 17, 2012 3:05:00 PM UTC-5, Scott Vickery wrote: > > 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]> wrote: >> >> 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. >> >> -- 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/-/lxelczR6UgIJ. 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.
