i´m going to rewrite AutoTake for RT 3.0 and add some nice
features to it, like subject-parsing, i want to give the ticket
somebody depending on the subject and so on…
but my big problem ist, who do i get the database-handle
and how do i make free selects ??
i tried the following, but it´s not working:
$self->{'table'} = "AutoTake";
$self->{‘primary_key’} = ‘id’;
my $ab = $self->LoadById($queueid);
i have a table like:
CREATE TABLE AutoTake (
id int(11) unsigned NOT NULL default ‘0’,
User_id int(11) unsigned NOT NULL default ‘0’,
PRIMARY KEY (id)
) TYPE=MyISAM;
INSERT INTO AutoTake VALUES(“1”, “127”);
i want to make a select like:
SELECT User_id FROM AutoTake WHERE id=1
to get the user with the id “127”…
i´m really despairing of this ;-((( cause all these modules are quite easy,
but i never worked with that DBI module and i find this a little bit
difficult to work with that…cause debugging is also not easy…
I’m not 100% sure what you mean by free selects, but I would suggest reading
the DBIx::SearchBuilder and ::Record documentation. I here it is pretty good.
i thought it is more than clear what i want…
guess you want to write a ActoinScript, where you have to select a value
from your DB… how would you do this in your script ???
that´s all i need to work on… a very simple example would help me a lot…
maybe somebody here can make a little mini-script, to demonstrate this
for RT3…
thx+best regards,
michaAm Sun, 13 Jul 2003 19:49:30 -0500, schrieb Matt Knopp (mhat@netlag.com):
I’m not 100% sure what you mean by free selects, but I would suggest reading
the DBIx::SearchBuilder and ::Record documentation. I here it is pretty good.