Re: DBI::Pg Question - new user

2001-05-14 Thread Peter J. Schoenster
On 14 May 2001, at 15:00, JACOB PETRIE wrote: > I am new at using DBI. I would like to have a form that order data > can be entered in, and when submitted the user will be given a > reference number from the database. The reference number is set-up as > a sequence in the PostgreSQL database. H

RE: executing atomic transactions in DBI

2001-05-06 Thread Peter J. Schoenster
On 5 May 2001, at 18:28, Sterin, Ilya wrote: > There is no || die anywhere in that eval? Even with RaiseError => 1 > turned on, in many cases the transaction does not fail, if not > checking for some sort of return. You are right, that eval does exit > on error, I think I replied a little to qu

Re: executing atomic transactions in DBI

2001-05-04 Thread Peter J. Schoenster
On 4 May 2001, at 14:46, traja wrote: > Hi, > > I have 2 insert statements which insert data into two different > tables. These 2 inserts need to be run atomically, How can I do this? > If I commit at the end of the two inserts, would that work? If your rdbms supports it and you have autocommit

Re: Probably a dumb RTM question....

2001-04-02 Thread Peter J. Schoenster
On 2 Apr 2001, at 17:33, Millman, Phillip wrote: > I have an Access database that I would like to be able to update/query > from Unix. What is the best way to do this? Can I use ODBC on UNIX? :) ... oh geee ... I once had to do something like this for an MS SQL server. I managed to connect a

Re: Strange error using mod_perl/DBI

2001-03-23 Thread Peter J. Schoenster
On 23 Mar 2001, at 10:10, Perl-DBI Mailing List wrote: > I have the following config: Apache 1.3.19 with mod_perl 1.25 and PHP4 > built statically into the server. I am using Perl DBI 1.14 and the > MySql module 1.2215. (Note: this problem also existed using apache > 1.3.14 and mod_perl 1.24_1) >

RE: installing DBI on windows

2001-03-21 Thread Peter J. Schoenster
On 21 Mar 2001, at 7:36, Sterin, Ilya wrote: > First are you saying this... > > >ppm install DBI > > If yes then your problem is that your ActivePerl installation might be > too old. Upgrade to 5.6 which is now available and that should solve > it. When you use old perl installations they usus