Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [jxh] Search question

Quote Reply
Re: [jxh] Search question In reply to
Thanks for your help, but i still don get it..

The 2 fields I want to search for is:
  1. 'status' column : must be eq (==) to 'Åben'
  2. 'fk_type_workorder' column : must be ne (!=) to '4'

1. works fine with db.cgi?.....;status=Åben
but db.cgi?....;status=Åben;fk_type_workorder-opt='!='4; does not work, I cant figure out if/how -opt is understood by db.cgi..

Any ideas on what I am doing wrong? Can't find any examples on passing != in the url..

Found this in the documentation, but I do not know how to use in an url:


To negate your queries you can use the not function.

my $cond = GT::SQL::Condition->new('a', '=', '5');


would translate into NOT (a = '5'). You can also do this all on one line like:

print GT::SQL::Condition->new('a', '=', '5')->not->sql;

This returns the sql right away.

Any help highly appreciated

Anders Poulsen
Subject Author Views Date
Thread Search question vespa180 3873 Oct 8, 2003, 2:45 AM
Thread Re: [vespa180] Search question
jxh 3779 Oct 8, 2003, 3:13 PM
Thread Re: [jxh] Search question
vespa180 3774 Oct 9, 2003, 2:22 AM
Thread Re: [vespa180] Search question
jxh 3775 Oct 9, 2003, 8:38 AM
Post Re: [jxh] Search question
vespa180 3776 Oct 10, 2003, 12:31 AM