Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Not finding the record... but its there?

Sep 29, 2004, 3:10 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Sep 29, 2004, 3:10 AM
Views: 3233
Shortcut
Quote Reply
Not finding the record... but its there?
Man... this one really has me stumped :/

Code:
SELECT COUNT(*) FROM sp_Links WHERE ID = '106855'

...gives;

Quote:
Your query returned 1 rows.

1

Yet;

Code:
my $chk = $DB->table('Links')->select( ['COUNT(*)'],{ ID => $property_id } )->fetchrow;

...and;

Code:
my $chk = $DB->table('Links')->count( { ID => $property_id } );

...both give me "0".

Anyone got any ideas? Unimpressed Am I just being stupid somewhere? :-/

TIA

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!
Subject Author Views Date
Thread Not finding the record... but its there? Andy 3233 Sep 29, 2004, 3:10 AM
Post Re: [Andy] Not finding the record... but its there? 		Andy 3170 Sep 29, 2004, 3:13 AM
Thread Re: [Andy] Not finding the record... but its there? 		webmaster33 3144 Sep 29, 2004, 4:58 AM
Post Re: [webmaster33] Not finding the record... but its there? 		Andy 3141 Sep 29, 2004, 5:25 AM
Thread Re: [Andy] Not finding the record... but its there? 		webmaster33 3156 Sep 29, 2004, 5:43 AM
Thread Re: [webmaster33] Not finding the record... but its there? 		Andy 3135 Sep 29, 2004, 5:48 AM
Thread Re: [Andy] Not finding the record... but its there? 		webmaster33 3144 Sep 29, 2004, 6:37 AM
Thread Re: [webmaster33] Not finding the record... but its there? 		Andy 3123 Sep 29, 2004, 6:40 AM
Thread Re: [Andy] Not finding the record... but its there? 		ryel01 3121 Sep 29, 2004, 2:30 PM
Thread Re: [ryel01] Not finding the record... but its there? 		Andy 3140 Sep 30, 2004, 3:39 AM
Thread Re: [Andy] Not finding the record... but its there? 		ryel01 3133 Sep 30, 2004, 4:50 AM
Post Re: [ryel01] Not finding the record... but its there? 		Andy 3108 Sep 30, 2004, 7:48 AM