LINE 1: ...event.van_datum>='2009-10-21') AND event.doelgroep=1) You have an assignment operator, not the equals operator.
LINE 1: ...event.van_datum>='2009-10- 21') AND event.doelgroep==1) -Thadeus On Wed, Oct 21, 2009 at 11:37 AM, mdipierro <[email protected]> wrote: > > I miss some context here (where is the original post?). Anyway I do > not think that is the problem. > > On Oct 21, 10:38 am, Yarko Tymciurak <[email protected]> > wrote: > > On Wed, Oct 21, 2009 at 3:51 AM, annet <[email protected]> wrote: > > > > ...... > > > > > executing this code results in a error tickets which reads like: > > > > > ProgrammingError: operator does not exist: character varying = integer > > > LINE 1: ...event.van_datum>='2009-10-21') AND event.doelgroep=1) AND > > > ev... > > > > ^ > > > > > > > > It reads to me like this may be complaining about the phrase: > > event.van_datum>='2009-10-21' > > > > which looks like an integer compare ( ">=" ) against a string ( > > "2009-10-21" ) > > > > I would guess your problem lies there... > > > > > HINT: No operator matches the given name and argument type(s). You > > > might need to add explicit type casts. > > > > > Where the ^ points to the = sign in doelgroep=1 > > > > > How do I solve this problem. Why doesn't 'db.event.bedrijf==1' result > > > in an error, to me both expressions are the same. > > > > > Kind regards, > > > > > Annet > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-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/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
