Hi. I'm trying to use GT::SQL to access a normal database. I currently have;
$db->set_connect ({
driver => "mysql",
host => $desk->{host},
#port => 3243,
database => $desk->{database},
login => $desk->{username},
password => $desk->{password}
}) || die $GT::SQL::error;
$db->prefix($desk->{prefix});
I am aware that I need to pass in a path to the 'defs' folder of the appropriate application, but this is going to be running on PerlDesk, so its a little different, as it obviously doesn't have a 'defs' folder. Does anyone have any ideas/suggestions? I would rather use GT::SQL instead of a normal MySQL Module if possible.
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 $db = new GT::SQL; $db->set_connect ({
driver => "mysql",
host => $desk->{host},
#port => 3243,
database => $desk->{database},
login => $desk->{username},
password => $desk->{password}
}) || die $GT::SQL::error;
$db->prefix($desk->{prefix});
I am aware that I need to pass in a path to the 'defs' folder of the appropriate application, but this is going to be running on PerlDesk, so its a little different, as it obviously doesn't have a 'defs' folder. Does anyone have any ideas/suggestions? I would rather use GT::SQL instead of a normal MySQL Module if possible.
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!