it is not clear what the context is. I think that is SQL not DAL therefore it is correct.
where is the original question? massimo On Oct 21, 12:36 pm, Thadeus Burgess <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
