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 [email protected]. For more options, visit https://groups.google.com/d/optout.
