Gossamer Forum
(Advanced Search)
for
Home : General : Perl Programming :

Finding long strings with GT::SQL

Jul 18, 2003, 6:28 AM
qango
Enthusiast (706 posts)
Jul 18, 2003, 6:28 AM
Post #1 of 5
Views: 822
Shortcut
Quote Reply
Finding long strings with GT::SQL
Hi,

I'd like to select non-validated links from my LSQL data with a Title length greater than 50 characters (including spaces) - anyone know how I would do that?

Thanks in advance

All the best
Shaun
Jul 18, 2003, 9:05 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Jul 18, 2003, 9:05 AM
Post #2 of 5
Views: 809
Shortcut
Quote Reply
Re: [qango] Finding long strings with GT::SQL In reply to
Best bet would be to do a while{} loop, and when grabbing the title, check to see the length of it. I'm not sure there is a feature that will do this in GT::SQL.

Hope that helps.

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Jul 18, 2003, 4:17 PM
Paul
Veteran (19537 posts)
Jul 18, 2003, 4:17 PM
Post #3 of 5
Views: 808
Shortcut
Quote Reply
Re: [qango] Finding long strings with GT::SQL In reply to
Try something like:

Code:
my $cond = GT::SQL::Condition->new( 'isValidated', 'No', 'LENGTH(Title)', '<', 50);
my $links = $DB->table('Links')->select($cond)->fetchall_hashref;
Jul 21, 2003, 6:00 AM
qango
Enthusiast (706 posts)
Jul 21, 2003, 6:00 AM
Post #4 of 5
Views: 793
Shortcut
Quote Reply
Re: [Paul] Finding long strings with GT::SQL In reply to
Thanks Andy and Paul,

I tried the suggested code but couldn't get it working. However, I fiddled around and copied a previous loop Paul had given me for another modification, and used the perl 'length' function to pull out the links with longer titles.

Seems to be working okay - thanks again Smile

All the best
Shaun
Jul 21, 2003, 11:46 AM
Alex
Administrator (9387 posts)
Jul 21, 2003, 11:46 AM
Post #5 of 5
Views: 786
Shortcut
Quote Reply
Re: [qango] Finding long strings with GT::SQL In reply to
Quote:
my $cond = GT::SQL::Condition->new( 'isValidated', '=', 'No', 'LENGTH(Title)', '>', 50);
my $links = $DB->table('Links')->select($cond)->fetchall_hashref;

Should do the trick.

Cheers,

Alex
--
Gossamer Threads Inc.