List:MySQL and Perl« Previous MessageNext Message »
From:Jochen Wiedmann Date:May 25 1999 8:27pm
Subject:Re: Getting index metadata with LISTINDEX
View as plain text  
> Subject: Getting index metadata with LISTINDEX
> Date: Wed, 28 Apr 1999 16:35:49 -0500
> From: "Moroney, Dennis" <MoroneyD@stripped>
> To: "'msql-mysql-modules@stripped'"
>      <msql-mysql-modules@stripped>
> 
> I would like to use the documented SQL extension named LISTINDEX get the
> table index by performing the following:
> 
> $sth = $dbh->prepare( qq[LISTINDEX $table $index] );
> $sth->execute;
> $idx = $sth->{????};

The msqlListIndex function returns a result table. Thus you don't
have to look at the sth attributes (besides NUM_OF_FIELDS, NAME and
TYPE), but use $sth->fetchrow_hashref() or something similar to
retrieve the information.


Bye,

Jochen


-- 
Jochen Wiedmann						joe@stripped
Wiedmann'sches Idealgewicht: IQ - 30%			+49 7123 14887


Thread
Re: Getting index metadata with LISTINDEXJochen Wiedmann26 May