Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [Robert] Extern table

Quote Reply
Re: [Robert] Extern table In reply to
Finally i have used it

my $count = $DB->table("Changes")->do_query(qq|SELECT COUNT(*) FROM your_table|)->fetchrow;

and it works fine; but how to spell it for more than one value?

my ($title, $rc) = $DB->table("Changes")->do_query(qq|SELECT title, reply_count FROM thread WHERE threadid = '$t'|)->fetchrow;
Ok, it works. :)

Last edited by:

Robert: Nov 23, 2017, 10:06 AM
Subject Author Views Date
Thread Extern table Robert 6663 Aug 15, 2017, 5:42 AM
Post Re: [Robert] Extern table
Andy 6525 Aug 15, 2017, 9:21 AM
Post Re: [Robert] Extern table
socrates 6137 Sep 30, 2017, 11:19 PM
Thread Re: [Robert] Extern table
Robert 6139 Oct 2, 2017, 10:32 AM
Thread Re: [Robert] Extern table
Andy 6119 Oct 3, 2017, 10:56 PM
Post Re: [Andy] Extern table
Robert 6086 Oct 5, 2017, 12:46 AM
Thread Re: [Robert] Extern table
Robert 5672 Nov 23, 2017, 10:03 AM
Post Re: [Robert] Extern table
Andy 5658 Nov 23, 2017, 11:54 PM