ActiveRecord how to correctly exclude records with conditions correctly?



Why does below not work?
Try to exclude all the is_reply = 1 values from the query but can't figure out how to.
I tried several combinations but all fail.


All records with is_reply = 1 still get returned with this below query, I think need to sub the or part but how?


@messages = Message.all(:conditions => ['is_reply = ? AND recipient_id
= ? OR user_id = ?', 0, current_user.id, current_user.id] )



Related to : ActiveRecord how to correctly exclude records with conditions correctly?
Rails: ActiveRecord is not parsing time correctly
Programming Languages

I'm assigning a time value in model with


self.started_at = Time.now


When I save it, I get following:


Created at: 2012-05-05 12:11:54 +0200
Started at: 2000-01-01 10:12:06 UTC

I've tried formatting with Time.now.to_s(:db) but the result is the same. Does this depend on locale settings? (I have activerecord 3.1.3)


conditions case not working correctly
Programming Languages

i use acts-as-taggable-on for tagging.


apartments_controller


def index
if params[:tag]
@apartments = Apartment.tagged_with(params[:tag])
else
@apartments = Apartment.all
end
end

routes


resources :apartments do
#...
collection do
get ':tag', to: 'apartments#index', as: :tag
end
#...

I get nice urls by example /apartments/tag1 etc.


I want to show custom content based on the tag name in the apartments index template.


Exclude records verifying two conditions
Programming Languages
select * from table_name
where BaseDocEntry=15 and BaseDocType='PRRH' and ItemCode='TestStudy2'
and WhseCode='01' and (currentdoctype<>'PUSH' and CurrentDocEntry<>15)

According to the query I have written above, the data from INS2 will be fetched excluding the currentdoctype [PUSH] and all data where CurrentDocEntry is not 15. What I expect my query to be is, it must exclude the data only if this combination i.e. currentdoctype=PUSH and CurrentDocEntry=15 are occurring in the same row, then exclude that row.


Can you fix this query ?


For-loop with multiple if-conditions does not complete correctly
Programming Languages

I have written a relatively simple procedure which is meant to do the following:


There are two columns on my spreadsheet, B and C. Both data sets start in row 26
B contains the number of a project (e.g. Project 1), and C contains the identifier for each line item so that multiple services can be allocated to a project. The combination of both variables will then form a unique ID for each line item (e.g. 1/3 for the third item in Project 1)
Every time a new project ID is entered in column B, column C should start again at 1
Once the list of projects finishes, the loop should stop (first if-condition)
I use another procedure to sort the data s
ActiveRecord how to correctly exclude records with conditions correctly?
Programming Languages

Why does below not work?
Try to exclude all the is_reply = 1 values from the query but can't figure out how to.
I tried several combinations but all fail.


All records with is_reply = 1 still get returned with this below query, I think need to sub the or part but how?


@messages = Message.all(:conditions => ['is_reply = ? AND recipient_id
= ? OR user_id = ?', 0, current_user.id, current_user.id] )



I'm not sure if I am using the conditions correctly
Programming Languages
I'm not sure if I am using the conditions correctly
 
I have a rule of conditions for access into an area of my site. The problem is, that when the wrong password is given, its still giving access to the area of the site. It is happening because I am using conditions wrong, and ask if someone could help me out by pointing out the correct way to do it.
When I say "conditions", I am referring to things such as && and ||

PHP Code:

Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .