Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

Fetching particular set of db values using Criteria::fromInput

i want fetch particular set of values from database using Criteria::fromInput my code for this is $query = Criteria::fromInput($this->di, "modelname", $this->request->getPost()); $query->where("delete = 'N'");// where condition...

        when i tried the above code i got the following error 
         Syntax error, unexpected token DELETE, near to ' = 'N'', when parsing: SELECT [table].* FROM [table] WHERE delete = 'N' (50)

0 [internal function]: Phalcon\Mvc\Model\Query->parse()

1 [internal function]: Phalcon\Mvc\Model\Query->execute()

please somebody help..!!!



64.2k
Accepted
answer
where("[delete] = 'N'")

?

thank you...its working now