Here comes a new problem. I do not know which columns' values to use; all I know is that they are represented with variables. These variables are
col_var_1, condition_operator, col_var_2, manipulation_operator, constant_value where: col_var_1: col1, or col2, or col3, etc condition_operator: >, >=, <, =, etc col_var_2: col1, or col2, etc manipulation_operator: +, -, x, / constant_value: float value in the where clause, I have to use these variables. What's the syntax? any help? thanks so much. On Jul 24, 2:39 pm, David <[email protected]> wrote: > Great. I go to pick up extra() to use. > > Thanks Tim. > > On Jul 24, 2:33 pm, Tim Chase <[email protected]> wrote: > > > > > > Such a transformation is fine. I found that my Django has no F(). > > > Checking the Django doc I saw that this new feature is "New in Django > > > Development version". > > > > So I have to wait for the new version? Are there any other ways to > > > create such a filter? > > >> col1_value >= col2_value * 2 > > > >> something like col1__gte=F('col2') * 2 > > > You can always fall back to the .extra() method[1]: > > > results = MyFoo.objects.extra(where=[ > > "col1_value >= col2_value * 2", > > ]) > > > which is how it was done back in the day before ya'll young > > whippersnappers had such fancy shenanigans as F() objects...and > > to get data, we walked up hill, in the snow. Both ways. ;-) > > > -tim > > > [1]http://docs.djangoproject.com/en/dev/ref/models/querysets/#extra-sele...- > > Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
