|
ru.perl- RU.PERL ---------------------------------------------------------------------- From : Dmitry Diskin 2:5061/6.97 20 May 2004 22:29:32 To : Soft Subject : Use DBI --------------------------------------------------------------------------------
18 May 04 15:56, Soft wrote to All:
S> Допустим, есть таблица POEHALI, необходимо получить названия полей
S> этой таблицы и тип данных, который в них записывается.
perldoc DBI
Раздел Statement Handle Attributes
NAME (array-ref, read-only)
Returns a reference to an array of field names for each column. The names
may contain spaces but should not be truncated or have any trailing space. Note
that the names have the letter case (upper, lower or mixed) as returned by the
driver being used. Portable applications should use NAME_lc or NAME_uc.
TYPE (array-ref, read-only)
Returns a reference to an array of integer values for each column. The value
indicates the data type of the corresponding column.
The values correspond to the international standards (ANSI X3.135 and
ISO/IEC 9075) which, in general terms, means ODBC. Driver-specific types that
don't exactly match standard types should generally return the same values as an
ODBC driver supplied by the makers of the database. That might include private
type numbers in ranges the vendor has officially registered with the ISO working
group:
ftp://sqlstandards.org/SC32/SQL_Registry/
Dmitry
--- GoldED+/W32 1.1.4.7
* Origin: ююю dda@ic.ru ююю (2:5061/6.97)
Вернуться к списку тем, сортированных по: возрастание даты уменьшение даты тема автор
Архивное /ru.perl/286040acf9aa.html, оценка из 5, голосов 10
|