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
-~----------~----~----~----~------~----~------~--~---
