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

Re: [Robert] SELECT FROM Databasename without prefix

Quote Reply
Re: [Robert] SELECT FROM Databasename without prefix In reply to
No - but you don't need to. You just need to pass in a valid table (with the prefix), and then, whatever SQL you want:

Code:
my $sth = $DB->table("Links")->do_query(qq|SELECT foo FROM New_Table_Name_without_prefix|);

Cheers

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 SELECT FROM Databasename without prefix Robert 6683 Apr 21, 2017, 3:52 AM
Thread Re: [Robert] SELECT FROM Databasename without prefix
Robert 6575 Apr 21, 2017, 4:28 AM
Thread Re: [Robert] SELECT FROM Databasename without prefix
Andy 6561 Apr 21, 2017, 6:19 AM
Thread Re: [Andy] SELECT FROM Databasename without prefix
Robert 6544 Apr 21, 2017, 8:21 AM
Thread Re: [Robert] SELECT FROM Databasename without prefix
Andy 6542 Apr 21, 2017, 8:27 AM
Thread Re: [Andy] SELECT FROM Databasename without prefix
Robert 6539 Apr 21, 2017, 8:29 AM
Thread Re: [Robert] SELECT FROM Databasename without prefix
Andy 6539 Apr 21, 2017, 8:30 AM
Thread Re: [Andy] SELECT FROM Databasename without prefix
Robert 6468 Apr 21, 2017, 9:47 AM
Post Re: [Robert] SELECT FROM Databasename without prefix
Andy 6299 Apr 22, 2017, 12:02 AM