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:



Quote:

To negate your queries you can use the not function.

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

$cond->not;

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 2414 Oct 8, 2003, 2:45 AM
Thread Re: [vespa180] Search question
jxh 2347 Oct 8, 2003, 3:13 PM
Thread Re: [jxh] Search question
vespa180 2340 Oct 9, 2003, 2:22 AM
Thread Re: [vespa180] Search question
jxh 2336 Oct 9, 2003, 8:38 AM
Post Re: [jxh] Search question
vespa180 2335 Oct 10, 2003, 12:31 AM