I need structure help!!!

Hi folks, I am using dbi with mysql to develope a data access interface for my application, and also I am using hash to retriving rows from database using fetchrow_hashref function, everything is fine, But the problem is I have to redefine a hash for every table which I am working with each time

MySQL DBI on Windows problem

Hi, I'm having a problem on Windows 2k where I have a pair of scripts where the parent forks off a few processes (a second perl script) which does some database input for a period of time, and then returns to the parent. Upon the return to the parent however, I can no longer do a $sth-execute()

RE: dbi variable size

The limit is set by the underlying database field size, and not the driver. See the documentation for you database and it's data types. Ilya Sterin -Original Message- From: Peter Gibbons To: [EMAIL PROTECTED] Sent: 06/04/2001 8:10 AM Subject: dbi variable size hi, quick questio: is

Re: I need structure help!!!

- Original Message - From: Mohammad Shoja [EMAIL PROTECTED] To: dbi-users mailing list [EMAIL PROTECTED] Sent: Monday, June 04, 2001 4:14 PM Subject: I need structure help!!! Hi folks, I am using dbi with mysql to develope a data access interface for my application, and also I am

Re: I need structure help!!!

I have been using Class::Struct a lot recently and instantiating an array object with it. You can also use a hash if you wish. This type of object gives you a C-like structure that you can manipulate as either an array (hash) or as a regular object using automatically generated accessor/mutator

RE: MySQL DBI on Windows problem

Are you trying to execute a statement handle that was created in the child process? If yes, you can't do that since forking, unlike threads does not share it's variables, but rather creates a copy of itself and then the child process is on it's own. Ilya Sterin -Original Message- From:

RE: dbi variable size

Sterin, Ilya writes: The limit is set by the underlying database field size, and not the driver. See the documentation for you database and it's data types. In general this is correct, though there may be situations with BLOBs (eg TEXT/IMAGE datatypes for Sybase and MS-SQL) where the default

[Fwd: MySQL DBI on Windows problem]

Sorry, I didn't reply to all. -- Christina Carkner Software Engineer NuSphere - Seriously Open Software http://www.nusphere.com No, the statement handle is created and attempted to be executed in the parent. There is no interaction between the child and the parent other than the forking.

RE: dbi variable size

Sterin, Ilya writes: Michael, wouldn't there be a way to insert more than the default. Like the old DBD::Oracle with OCI7 where blob_read needed to be used to fetch more than 65535 (or something like that) bytes, or is there no support in DBD::Sybase to do that at this time. I've never

Trouble installing DBD::DB2

Hello, I am having trouble installing DBD::DB2. I have Perl 5.6.1 and DBI 1.16. When I do a install DBD::DB2 from the CPAN prompt the package seems to download OK. However, when the build runs I get the following: WARNING from evaluation of

Re: (Fwd) Accent insensitive

Ilya is the one of the members of the dbi-users list. If you looked at the message, you'd see that Tim forwarded the second request to the list to be handled, just like he probably did the first. Tim is very busy. If you want to be shunned, continue talking that way to the people who are

RE: recovering lost data

i've deleted data from a table via dbi a few days ago: is this recoverable via dbi, and if so whatwould the example code be? Anything's recoverable if you've kept backups. But not through DBI (at least not once its committed, which, after a few days, I assume it is).

RE: recovering lost data

DBI/DBD::* are only interface/drivers to the underlying database. When you call any DBI function it's in fact executing the db function. This is more of a DB specific question. If your db has some sort of a back up, etc..., then you can recover through that, DBI would really have nothing to do

Re: FW: (Fwd) Accent insensitive

[joke answer ahead] Paul == Paul DuBois [EMAIL PROTECTED] writes: Paul 2) Buying an author's book does not entitle you to consider the author Paul your own personal consultant. Well, it might if you consider the value of the time, however. I get about $1 pre-tax from the sale of a llama

Insert an Image or big data using DBI, DBD:SyBase

I'm sure this has been covered before but I cannot find any information on inserting data into sybase using DBI for large files or large data. I have the book and read the help but it doesn't say a thin about inserting...only reading. None of the man files help either. How is this done?

Perl/Oracle on Win32

Do you know where I can get help having DBD-Oracle module be installed on Win32 systems? I'm trying to use Perl to access Oracle database from Windows servers? Thanks -- Jasper Yue

Re: Perl/Oracle on Win32

Jasper Yue This doesn't answer your question, but I always use DBD::ODBC for oracle on win32. Tim Do you know where I can get help having DBD-Oracle module be installed on Win32 systems? I'm trying to use Perl to access Oracle database from Windows servers? Thanks -- Jasper Yue

Re: Perl/Oracle on Win32

If you are using ActiveState's Perl build (and you probably should be), just use PPM to install DBI and DBD-Oracle or DBD-Oracle8. You will also need at least SQL*Net on any of your Win32 hosts. The instructions for using PPM are part of the documentation that comes with ActiveState Perl. -- Mac

How to retrieve binary fields from ORACLE and write it to a file outside

I an trying to retrieve a bitmap fields from ORACLE. The data type is LONG RAW, not LOB. How can I do that in perl? Thank you.

RE: How to retrieve binary fields from ORACLE and write it to a file outside

You would do the same thing as LOB, set LongReadLen, LongTruncOK and fetch. The only difference, is (I haven't dealt with Long Raw in a long while) I believe it's hex encoded when stored and you will have to use pack() to unencode it. Ilya Sterin -Original Message- From: [EMAIL

MS SQL through MS Access using DBI:ODBC

Hi When connecting an MS SQL database from MS Access it is necessary to use the option dbSeeChanges with db.openrecordset. This is ok when using Visual Basic but is it possible to access the data using DBI:ODBC. Win2000 MS SQL version 7 MS Access 97 perl 5.005

Re: I need structure help!!!

Another possibility is DBIx::Recordset. Tom On Mon, Jun 04, 2001 at 03:53:25PM +0100, Mohammad Shoja wrote: Thanks you people all for your suggestions. Your suggestions was very very helpful. I was just looking for the functionalities which is implemented in Class::Struct -- Thomas A.

Re: Insert an Image or big data using DBI, DBD:SyBase

Paula Dan Goldman writes: I'm sure this has been covered before but I cannot find any information on inserting data into sybase using DBI for large files or large data. I have the book and read the help but it doesn't say a thin about inserting...only reading. None of the man files

Problem installing DBD-Oracle 1.06

Hi Have anyone sucessfully installed DBI 1.14 and DBD-Oracle 1.06 on Compaq Tru64 UNIX version 4.0D ? I attached the log below: Output for perl Makefile.PL -v (See attached file: makefile.log) Output for make (See attached file: make.log) Output for make test (See attached file: test.log)

RE: ANNOUNCE: DBI 1.18

I'm sorry to say this. but Oracle 9iAS is shipped with :( and Oracle doesn't provide you with a way to upgrade it. $ perl -v This is perl, version 5.005_03 built for sun4-solaris Copyright 1987-1999, Larry Wall Perl may be copied only under the terms of either the Artistic License or the

Re: FW: (Fwd) Accent insensitive

On 4 Jun 2001, Randal L. Schwartz wrote: [joke answer ahead] Paul == Paul DuBois [EMAIL PROTECTED] writes: Paul 2) Buying an author's book does not entitle you to consider the author Paul your own personal consultant. Well, it might if you consider the value of the time, however. I

Re: ANNOUNCE: DBI 1.18

Happy Birthday, Tim Bunce. :)

Re: ANNOUNCE: DBI 1.18

wow... what a coincidence... i joined dbi-users today, on Tim's Birthday! :) HAPPY BIRTHDAY TIM! payman Tim Bunce wrote: file: $CPAN/authors/id/T/TI/TIMB/DBI-1.18.tar.gz size: 198250 bytes md5: b8542df1a83d46b816d95eb6204a73e2 Changes in DBI 1.18,4th June 2001 Fixed