What would the code/sql to check if a value ($category_id) exists in table ('Category') under column ('FatherID')?



I might be way off on this

Thanks!

I assume you are using GT::SQL libraries. Then try:
$obj->count($cond) gives you the number of records that satisfy the condition $cond.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Why are you setting $id_exists to 1?

You could use the count or:

You're right, best thing is to use the if statement.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Paul and Yogi to the resuce. Thanks both.

I figured the you could get an sql statement to return a bool value somehow. Yes, I just want to stick this in a function which returns a bool.

So could say if &Has_Children() then blah blah.




http://www.iuni.com/...tware/web/index.html
Links Plugins

....Im just showing off now

Thats ok Paul.... I am just cutting and pasting the fruits of your showing off!!! Thanks

I'm suprprised that you didn't write that:


;-)

- wil

Why have cotton when you can have silk?

This statement is getting so small, I should just forget about putting it into a sub!

I guess I can substitute PRINT for RETURN 1 : RETURN 0 ?

Where are you returning to?

...the constant is doing the returning, you then need to do something with the returned value.

But you are probably better off making it a count rather then a select (less overhead):

sub { $DB->table('Category')->count( { FatherID => $_[0] } ) };

and no point using constant module since you don't gain the compile time benefit. Just do:

sub exists { $DB->table('Category')->count( { FatherID => $_[0] } ) }

and then:

print exists($category_id) ? "ok" : "not ok";

Cheers,

Alex
--
Gossamer Threads Inc.

I see your points, and thanks Alex. Lets put this in the scheme of what I am trying to do.

I am going to use this statement in my category tidy up tools.

Right now i'd like to have this check for subcats BEFORE any delte statement could be performed, so subcategories are not removed by accident.

For Example:

In Links - Remove all Categories which are children (any depth below or Directory Depth below) "The Category" AND contain 0 links (Number_of_Links == 0) AND &has_children() returns false. (this is the statment we are getting at here)

I (thanks to you Paul) I now understand that as long as I use $DB, the appropriate changes will automatically be effected on the other table when I removed a category, such as CatLinks.

I am thinking of a stack of uses for these types of little checks, for clean up tools and automated checking of my categories, since they are edited by editors.

Yep I was just showing off, it wasn't necessary at all

Is:

$obj->count

...the same as....

$obj->select( 'COUNT(*)' )

?

Yes, pretty much. =)

Cheers,

Alex
--
Gossamer Threads Inc.

Ok, just to confirm I am getting this:

#determine if category has children
sub has_children { $DB->table('Category')->count( { FatherID => $_[0] } ) }

if (&has_children{$category_id})

{

Dont Delete

}

else

{

Remove Category

}

Close,

sub has_children { $DB->table('Category')->count( { FatherID => $_[0] } ) }

if (has_children($category_id)) {

}
else {

}

Cheers,

Alex
--
Gossamer Threads Inc.

Thanks Alex!

You know I debated taking that '&' out, but left it in. Tremendous