Dear Anthony, Thanks for the reply.
You said, "I see -- you want to reset the ID's to start at 1 again." Yes. I believe that's what is meant by web2py’s usage of the term "truncate". I have used the shell to do that, however I would prefer to not go back and forth from appadmin to the shell. Anyway, thanks again, Anthony. Your replies are always a blessing. Love and peace. Joe On Monday, July 14, 2014 10:50:41 AM UTC-7, Anthony wrote: > > I see -- you want to reset the ID's to start at 1 again. I don't think you > can do that from appadmin. Use the shell. > > Anthony > > On Monday, July 14, 2014 1:19:00 PM UTC-4, JoeCodeswell wrote: >> >> >> <https://lh5.googleusercontent.com/-5p_Y4BnpH8Y/U8QQ5X_rNgI/AAAAAAAAAIU/S3BpQ4qAxTQ/s1600/Screenshot+2014-07-14+10.14.20.png> >> Dear Anthony, >> >> Thanks for your reply. Your suggestion didn't work. >> >> TEST >> 1. I had trip id's numbered [1, 75] in the trip table. >> 2. I did your suggestion: >> - Put db.trip.id > 0 in the query >> - check the delete box. >> - [hit submit] >> 3. I imported from csv file trip id's numbered [1, 75]. >> RESULT: >> - data uploaded >> - trip id's numbered [76, 150] (please see screenshot). >> >> Any ideas? >> >> Thanks again, Anthony. >> >> Love and peace, >> >> Joe >> >> >> On Saturday, July 12, 2014 12:15:20 PM UTC-7, Anthony wrote: >>> >>> Put db.trip.id > 0 in the query and check the delete box. >>> >>> Anthony >>> >>> On Saturday, July 12, 2014 11:51:58 AM UTC-4, JoeCodeswell wrote: >>>> >>>> Dear web2py-users, >>>> >>>> What is the proper way to truncate table from appadmin? >>>> >>>> The following does a truncate but shows errors in response.flash. >>>> >>>> In https:// ...appadmin/select/db?query=db.trip.id%3E0 >>>> Query: <i make this blank then after i click submit it comes >>>> back == 'db.trip.id>0'> >>>> Update: [x] db.trip.truncate() >>>> Delete: [ ] >>>> >>>> RESULT: >>>> db.trip is truncated >>>> response.flash: >>>> Invalid Query >>>> 'NoneType' object is not iterable >>>> >>>> >>>> Thanks for the help. >>>> >>>> Love and peace, >>>> >>>> Joe >>>> >>>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
