Re: client_admin: rowid for np-core policy for new clients not getting set

>>>>> On Fri, 16 Apr 2004 10:27:09 -0700, Lindy Foster <[email protected]> said:

Lindy> my $rid = $sth->{mysql_insertid};

Lindy> This doesn't work. The rowid doesn't get set, and the entry
Lindy> into the policychange table works, but leaves the rowid blank
Lindy> (which isn't really much use). The only other instance I can
Lindy> find of this usage is in sql_utils, where it has an "if exists"
Lindy> clause with an else that is pg-centric. What do I need to fix
Lindy> this? Wes?

There is current code in the net_policy routines in the sql_utils.pm
file that does the "right" think for both mysql and postgres.  The
above definitely isn't right and ideally we should fall back to the
other routines or duplicate what I did there.

-- 
Wes Hardaker
Sparta


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click