Gossamer Forum
Home : Products : Gossamer Links : Discussions :

is Title exist

Quote Reply
is Title exist
I need to send Title to see if its exist, and return yes or no, I don’t need that it return something except that if the Title is already exist. What is the best way to do this.
Quote Reply
Re: [nir] is Title exist In reply to
Should be pretty simple:

check_if_title_exists
Code:
sub {
if ($DB->table('Links')->count( { Title => $_[0] } ) > 0) {
return { title_exists => 1 }
} else {
return { title_exists => 0 }
}
}

Then call with:

Code:
<%check_if_title_exists($Title)%>
<%if title_exists%> the title exists <%else%> it doesnt exist <%endif%>

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!
Quote Reply
Re: [Andy] is Title exist In reply to
Something small – who you insert for this OR for URL- So it will see if there is Title Or URL (Whistle)
Quote Reply
Re: [nir] is Title exist In reply to
Should work with this:

check_if_title_exists
Code:
sub {
my $cond = new GT::CGI::Condition;
$cond->add('Title','=',$_[0]);
$cond->add('URL','=',$_[1]);
$cond->bool('OR');

if ($DB->table('Links')->count( $cond ) > 0) {
return { title_exists => 1 }
} else {
return { title_exists => 0 }
}
}

Code:
<%check_if_title_exists($Title,$URL)%>
<%if title_exists%> the title exists <%else%> it doesnt exist <%endif%>

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!
Quote Reply
Re: [Andy] is Title exist In reply to
ThanksSmile