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.
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;
Anyone got any ideas?
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!
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
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!