hi,

i select a list of links from the database using gossamers way to select links:

@new = $links->select('ID', { isValidated => 'Yes', Lizenz => 'Shareware' })->fetchall_list;

but i want to select links with OR operator by the following (not working) example:

@new = $links->select('ID', { isValidated => 'Yes', Lizenz => 'Shareware' or Lizenz => 'Commercial' })->fetchall_list;

How can I do this?

Best regards from
Bremen/Germany

Lothar

The below code should work :)


Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

hello andy,

thanks but when I use it, I've get the following error:

A fatal error has occured:

Can't locate object method "new" via package "GT::SQL::Conditions" at (eval 5) line 11.

Please enable debugging in setup for more details.

So I use also (find in another script):

my $cond = ($links->select GT::SQL::Conditions->new('isValidated','=','Yes','Lizenz','=','Shareware','Lizenz','=','Commercial'));
@new = $links->select('ID', $cond )->fetchall_list;

And get the error: unable to compile sub_name

Best regards from
Bremen/Germany

Lothar

Try this:

my $cond = GT::SQL::Condition->new('Lizenz','=','Shareware','Lizenz','=','Commercial');
$cond->bool('or');
my $cond2 = GT::SQL::Condition->new($cond,'isValidated','=','Yes');
@new = $links->select('ID', $cond2 )->fetchall_list;

Thank you!

This works in a Global and also in a seperate cgi script.

Best regards from
Bremen/Germany

Lothar

Sorry, I didn't realise you were using it in a script. If using this in a script, you need to also add;


...near the top of the script. If you are using it in a global, then LinksSQL includes this module for you :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Thanks Andy.

With the code from afinIr I dont use use GT::SQL::Condition;in the cgi script or in the global.

Best regards from
Bremen/Germany

Lothar