Gossamer Forum: Products: Gossamer Links: Discussions: is Title exist

Dec 20, 2009, 6:05 AM

nir

User (396 posts)

Dec 20, 2009, 6:05 AM

Post #1 of 5

Shortcut

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.

Dec 20, 2009, 6:15 AM

Andy

Veteran / Moderator (18436 posts)

Dec 20, 2009, 6:15 AM

Post #2 of 5

Shortcut

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

Dec 20, 2009, 6:20 AM

nir

User (396 posts)

Dec 20, 2009, 6:20 AM

Post #3 of 5

Shortcut

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

)

Dec 20, 2009, 6:26 AM

Andy

Veteran / Moderator (18436 posts)

Dec 20, 2009, 6:26 AM

Post #4 of 5

Shortcut

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

Dec 21, 2009, 12:30 AM

nir

User (396 posts)

Dec 21, 2009, 12:30 AM

Post #5 of 5

Shortcut

Re: [Andy] is Title exist In reply to

Thanks