On Wed, Oct 21, 2009 at 3:51 AM, annet <annet.verm...@gmail.com> 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 web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---