Delete Query Not Working

[samurai]

This is the function for deleting a record from database. 

def pro_del():

        d = request.args

        db(db.products.product_id == d).delete()

        session.flash = "Product Deleted"

        redirect(URL('default','index'))

        #return locals()

The id is successfully getting passed to the function by args(means d is getting its value). I checked it by returning locals.
The redirection is also working fine. Its also flashing the msg. 
Just the query is not working.

[Manuele Pesenti]

Il 09/07/14 10:32, samurai ha scritto:

> def pro_del():
> d = request.args
> db(db.products.product_id == d).delete()
> session.flash = "Product Deleted"
> redirect(URL('default','index'))
> #return locals()

try this:

def pro_del():
d = request.args(0) or redirect(URL('default', 'index'))
db(db.products.product_id == int(d)).delete()
...

cheers

M.

[Leonel Câmara]

It should be:

d = request.args(0)

[samurai]

As both Manuele and Leonel said, I changed it to args(0). But no use. It was still not working.

I actually changed a bit and now I am getting 'd' by get.vars.

def pro_del(): 
         d = request.get_vars.d 

         db(db.products.product_id == d).delete() 
         session.flash = "Product Deleted" 
         redirect(URL('default','index')) 
         #return locals()

Now also everything is working fine except the delete query.
Note: I am redirecting and appending the vars by using a javascript function on the view side. If it has to do something with this problem.

[lyn2py]

Did you turn on versioning?

Can you post a traceback?

[Shubham Jain]

No, I hadn''t. But it worked on turning it on. Thanks
But I don't get it. Record versioning just creates an archived db for the modifications done. So how this feature being disabled is restricting me from deleting a record ??

Shubham Jain

3rd Year, Software Engg

Delhi Technological University(Formerly DCE).

--
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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/7_0Vvdx6Unw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[dlypka]

you might need to db.commit() after the delete().

versioning might be doing a commit() for you.