<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.
