Look in perldoc DBI for table_info method:-)
Ilya
> -Original Message-
> From: Allen Day [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 12, 2002 2:02 AM
> To: [EMAIL PROTECTED]
> Subject: table describing method?
>
>
> Hi,
>
> Is there a DBI method to determine the number of fields
Hi,
Is there a DBI method to determine the number of fields and their
types? I want to be able to do something like:
@fields = $db->describe('mytable);
and have @fields indices correspond to the fields of the table. Each
element of @fields is a hash with properties, maybe like this:
$fields[
[EMAIL PROTECTED] wrote:
> Hi All,
>
> Have any of you faced a similar problem and if so how did you fix it?
> the make seems to run allright but when I run the make test all the tests
> fail.
>
> we are on SUN solaris SunOS 5.6 Generic_105181-30 sun4u sparc SUNW,Ultra-80
>
> The errors I g
[EMAIL PROTECTED] wrote:
> I have upgraded my perl version to 5.6.1 before installing the gcc version 3.0.3. I
>didn't uninstall GNU binutils or GAS. Yes, the path has been changed from usr/bin to
>usr/local/bin. Please advice what next step should I do.
RTF -- Read the FAQs? http://xmlproj.d
On Thu, 2002-04-11 at 10:37, Giles Lean wrote:
>
> DBD-Pg-1.12 is not passing all tests when run with PostgreSQL 7.2
> using perl 5.6.1 and DBI 1.18 on NetBSD-1.5.1/i386. Testing with
> DBI 1.21 and PostgreSQL 7.2.1 made no difference.
These are known problems and I have fixes in hand for them.
Is perl compiled using the same compiler (the new GCC compiler)?
T
On Fri, Apr 12, 2002 at 11:11:43AM +1000, [EMAIL PROTECTED] wrote:
> Hi All,
>
> Have any of you faced a similar problem and if so how did you fix it?
> the make seems to run allright but when I run the make test all the te
Hi All,
Have any of you faced a similar problem and if so how did you fix it?
the make seems to run allright but when I run the make test all the tests
fail.
we are on SUN solaris SunOS 5.6 Generic_105181-30 sun4u sparc SUNW,Ultra-80
The errors I get are logged in the script output and it
I have upgraded my perl version to 5.6.1 before installing the gcc version 3.0.3. I
didn't uninstall GNU binutils or GAS. Yes, the path has been changed from usr/bin to
usr/local/bin. Please advice what next step should I do.
Here's the output of perl -V:
Summary of my perl5 (revision 5.0 vers
DBD-Pg-1.12 is not passing all tests when run with PostgreSQL 7.2
using perl 5.6.1 and DBI 1.18 on NetBSD-1.5.1/i386. Testing with
DBI 1.21 and PostgreSQL 7.2.1 made no difference.
t/04execute.FAILED tests 5-7
Failed 3/10 tests, 70.00% okay
...
t/12placeholdersDBD::P
OSP:
PROCEDURE Add_GFS_cmpdocs (
FIN_C IN VARCHAR2,
ACCT_OU_C IN VARCHAR2,
COUNTRY_ISO3_C IN VARCHAR2,
DOCNAME_N IN VARCHAR2,
DOCFILE_X
Code, code, let us see the code please...
Show me your flowcharts and conceal your tables, and I shall continue to be
mystified. Show me your tables, and I won't usually need your flowcharts;
they'll be obvious. Fred Brooks...
Ilya
-Original Message-
From: Mathew Varghese
To: [EMAIL PR
(DBD ERROR: LOB refetch attempted for unsupported statement type)
This is the error i am getting while i try to insert BLOB into Oracle 8 from
Perl5V6 through OSP.
Even though i am getting this error, OSP is inserting a row into Oracle
except for the BLOB field.
I also tried inserting it direc
My project is almost done and i just wanted to share what code i have finished.
Thanks so much for the input/help i've recieved here!
~~ Start of Code ~~
use CGI qw/:standard/;
use DBI;
use Net::SMTP;
$| = 1;
open(STDERR, ">&STDOUT");
print header,
On Thu, Apr 11, 2002 at 01:58:16AM +, Matthew Harrison wrote:
>
> I am writing a login script using cookie and DBI to connect to a mysql
> database and I need to run a query like:
>
> "SELECT username from users"
>
> and have it return all the usernames in preferably an array so I can do
Your compiler (gcc) is using the Solaris assembler but thinks it is the GNU
assembler.
Was your perl built locally? Have you installed GCC since installing Perl?
Have you uninstalled GNU Binutils or GAS? Is your $PATH different from what it
was when you built Perl? What is the output of "per
Hi,
I understand this issue has been raised and (possibly) resolved several
times. Yet I did not find anything related to what I was looking for.
I have been using OCI so far to connect to Oracle and learned about DBI and
DBD a day ago. To connect to Oracle 8i using OCI, the bare minimum I would
Hi All,
Have any of you faced a similar problem and if so how did you fix it?
the make seems to run allright but when I run the make test all the tests
fail.
we are on SUN solaris SunOS 5.6 Generic_105181-30 sun4u sparc SUNW,Ultra-80
The errors I get are logged in the script output and it
Hi,
I have a problem when try to make DBI.
cp Changes blib/lib/DBI/Changes.pm
gcc -c -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\" -DXS_VERSION=\"1.21\" -fPIC
-I/usr/local/lib/perl5/5.6.1/sun4-solaris/CORE -Wall -Wno-comment -DDB
I left it in the same directory I was doing the build in, i.e. the
DBD-Oracle-1.12 directory created by unpacking the .tar file.
__
Stuart Cocks
VEGA Group PLC.
e-mail: [EMAIL PROTECTED]
This transmission is intended fo
19 matches
Mail list logo
