Re: create and insert

[prev] [thread] [next] [Date index for 2005/01/20]

From: Jay Strauss
Subject: Re: create and insert
Date: 17:45 on 20 Jan 2005

Hartmaier Alexander wrote:
> I scan for new interfaces on my devices via snmp automatically and insert them in a 'scaninterface' table.
> When somebody selects a new interface on the webgui it gets loaded from the 'scaninterface' table with a this call:
> ($obj_new_interface) = NAC::Interface->search_from_scan($newport);
> 
> This is the definition im my NAC::Interface class:
> __PACKAGE__->set_sql('from_scan', 'SELECT fk_device, port, name, snmpid, snmpid_rtt, type, speed, mtu, ipaddr, ipnetmask, description FROM nacadm.scaninterface WHERE port = ?');


I don't see why you need a set_sql statement here (not that you can't do 
it, but cdbi gives you what you want already) like:

     my @interface = __PACKAGE__->search(port=>$newport);


I think your question may need to be restated and clarified, for someone 
to help

Jay

(message missing)

create and insert
Hartmaier Alexander 16:00 on 20 Jan 2005

Re: create and insert
Dana Hudes 16:06 on 20 Jan 2005

Re: create and insert
Hartmaier Alexander 16:24 on 20 Jan 2005

Re: create and insert
Jay Strauss 17:45 on 20 Jan 2005

Re: create and insert
Perrin Harkins 18:46 on 20 Jan 2005

Re: create and insert
Jay Strauss 19:33 on 20 Jan 2005

Re: create and insert
Perrin Harkins 19:51 on 20 Jan 2005

Re: create and insert
Jay Strauss 17:39 on 20 Jan 2005

Re: create and insert
Peter Speltz 17:53 on 20 Jan 2005

Re: create and insert
Peter Speltz 18:06 on 20 Jan 2005

Re: create and insert
Hartmaier Alexander 09:40 on 21 Jan 2005

Re: create and insert
Jay Strauss 15:41 on 21 Jan 2005

Re: create and insert
Perrin Harkins 19:35 on 21 Jan 2005

Re: create and insert
Peter Speltz 05:50 on 22 Jan 2005

Re: create and insert
Perrin Harkins 17:19 on 22 Jan 2005

Re: create and insert
Peter Speltz 17:43 on 22 Jan 2005

Re: create and insert
Perrin Harkins 19:09 on 22 Jan 2005

Re: create and insert
Peter Speltz 22:22 on 22 Jan 2005

Re: create and insert
Perrin Harkins 00:18 on 23 Jan 2005

Re: create and insert
Hartmaier Alexander 14:07 on 24 Jan 2005

Re: create and insert
William McKee 16:15 on 24 Jan 2005

Re: create and insert
Peter Speltz 16:28 on 24 Jan 2005

Re: create and insert
Hartmaier Alexander 16:38 on 24 Jan 2005