Yo

Just when I thought I had this global beat, I find another problem. I just can't seem to get the following condition statement working:

my $cond = GT::SQL::Condition->new('content_url1', 'IS NOT', \'NULL');

I would like it to return only links with their 'content_url1' field filled. Below is the global I'm working on which works great except for still returning links with the 'content_url' field empty. I'm not even really sure if thats the correct way to write the statement.

If someone could offer some help or suggestions I'd greatly appricate it.

sub {
my $tags = shift;
my $link_db = $DB->table('Links');
my $limit = $tags->{Random_Limit} || 4;
my ($output, $sth, $link);
require GT::SQL::Condition;
my $cond = GT::SQL::Condition->new('content_url1', 'IS NOT', \'NULL', 'isValidated','=','Yes', 'has_content','=','Yes');
$link_db->select_options ( 'ORDER BY RAND(NOW())', "LIMIT $limit");
$sth = $link_db->select ($cond);
while ($link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('content_table', $link);
}
return $output;
}

You refer to 'content_url' in the description of the problem, but in your codes you refer to 'content_url1' ... isd it just a typo?


----------
my $cond = GT::SQL::Condition->new('content_url1', 'IS NOT', \'NULL');

....I would like it to return only links with their 'content_url1' field filled...
----------

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!

Oh, that's just a typo. Yes, content_url1 is what I'm using.

I Was working late last night so I'm suprised that's the only one.

Can ya see anything wrong Andy?? Anyone?

Try:

That did the trick Paul. Thanks for your help!

I was actually able to just use: 'content_url1', '<>', ''

Knowing how to use these types of conditions can come in very handy. I'm happy to say I was finally able to get this new feature of mine completly working. Really wasn't sure it was going to happen.

Thanks again.