Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: GT::SQL::Condition

Nov 25, 2003, 7:56 AM

Andy

Veteran / Moderator (18441 posts)

Nov 25, 2003, 7:56 AM

Post #1 of 4

Shortcut

GT::SQL::Condition

Hi guys/gals. I've got a bit stuck on this bit of code. Basically, I just want to grab the name/id of the query in question.

Code:
my $Name = "Global/%" . $hit->{State_RegionName}; 
my $Full_Name = $category_table->select( 'Full_Name', GT::SQL::Condition->new('Full_Name','LIKE',$Name) )->fetchrow || die $GT::SQL::error; 
my $ID        = $category_table->select( 'ID', GT::SQL::Condition->new('Full_Name','LIKE',$Name) )->fetchrow || die $GT::SQL::error;

I keep getting this error message though;

Quote:

Died at db_update.cgi line 84.

Anyone got any ideas?

TIA.

Andy (mod)
andy@ultranerds.co.uk

Nov 25, 2003, 6:14 PM

tandat

Enthusiast (809 posts)

Nov 25, 2003, 6:14 PM

Post #2 of 4

Shortcut

Re: [Andy] GT::SQL::Condition In reply to

Hi,

I'm not sure but I think the first parameter should be the condition to query and the second is the field name and they are array ref such as ['ID'] or ['Name']

Cheers,

Cheers,

Dat

Programming and creating plugins and templates
Blog

Nov 26, 2003, 1:05 AM

Andy

Veteran / Moderator (18441 posts)

Nov 26, 2003, 1:05 AM

Post #3 of 4

Shortcut

Re: [tandat] GT::SQL::Condition In reply to

It normally works with;

$DB->table('Category')->select( 'FieldName', { Field => Value } )->fetchrow;

Unsure

I managed to get around it by just grabbing the whole result, and then using a while {} to go through it, and grab the data I needed.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Nov 26, 2003, 4:44 PM

afinlr

Veteran (1921 posts)

Nov 26, 2003, 4:44 PM

Post #4 of 4

Shortcut

Re: [Andy] GT::SQL::Condition In reply to

my ($Full_Name,$ID) = $category_table->select( ['Full_Name','ID'],GT::SQL::Condition->new('Full_Name','LIKE',$Name) )->fetchrow_array;