Apologies to the experts if this is a question many times asked and
answered - my google search left me empty handed.
I'm trying to install DBD-Oracle-1.15 on Solaris 9 using perl 5.8.5
compiled with gcc.
My oracle home contains version 8.0.6 (old, yes, but required for an
Oracle ERP 11.0.3 insta
Hi,
I have a workaround for this issue, but the bug appears serious enough that
I wanted to report it to maintainers.
Running a DBD::ADO program against a MS SQL Server 2000 database, if I try
to insert strings using a prepared statement with placeholders, the strings
are truncated. The rest of t
I've got a script I use for backing up MS-SQL databases via DBD::ODBC on
Windows. It was working fine with ActivePerl 5.6.1 (build 633), DBI 1.30
and DBD::ODBC 0.43, but when I upgraded to ActivePerl 5.8.4 (build 810),
DBI 1.42 and DBD::ODBC 1.09, it's not working correctly. What happens, is
tha
FYI-
I believe inline views in mysql will require at least version 5.
Thanks,
Ron.
"To really screw up Linux you have to work at it...To really screw up Windows, you
have to work ON
it."
"The software said to install Windows 98 or better... So I installed linux."
"Windows - How do you want to
Yes. What would happen if 2 processes running this code executed the
query at about the same time? They would both receive the same value
for MIN(id). Locking the row would guarantee only one user would get
the MIN(id); the 2nd (and subsequent users) would wait until the lock is
released.
-
On Wed, Sep 15, 2004 at 11:22:56AM +0100, Tim Bunce wrote:
> On Tue, Sep 14, 2004 at 04:57:31PM -0400, Mark Jason Dominus wrote:
> >
> > current thread: [EMAIL PROTECTED]
> > =>[1] Perl_sv_setsv_flags(0x4f52412d, 0xfc0e7c, 0x2, 0xfc0e7c,
> > 0x200, 0xe000), at 0x9db28
> > [2] XS_DBI_dispatc
If I've understood you correctly, this might be worth a try as an example...
select min(userid) from
(
select userid
from mhtemp a
where a.userid > 3000
and 0 = (select count(*) from mhtemp b where b.userid = a.userid-1)
)
it survived a very quick test. Basically, the inner pair of selects
return
Well... The database is actually MySQL. In answer to a couple
of other questions... The reason for the number beginning at 3000 is
that this if for a Unix user account system, and we are reserving all
numeric UIDs below 3000. Thanks again for the feedback. Still trying
to figure this o
> From: Steve Baldwin [mailto:[EMAIL PROTECTED]
>
> LOCK TABLE user_table IN EXCLUSIVE MODE ;
> SELECT MIN ...
> INSERT INTO user_table ...
> COMMIT ;
On 2004-09-14 14:53:06 -0600, Reidy, Ron wrote:
> Or ...
>
> SELECT MIN(id)
> FROM t
> FOR UPDATE;
>
> Would only cause a row lock.
Does that
On Tue, Sep 14, 2004 at 12:30:55PM +0100, Tristan Greaves wrote:
> (Message has been sent to [EMAIL PROTECTED])
>
> Hi there Tim,
>
> We are using DBD::Oracle as part of our web site here, and are
> experiencing some Oracle crash issues.
Has it always been like that?
If not, when did it start?
On Tue, Sep 14, 2004 at 04:57:31PM -0400, Mark Jason Dominus wrote:
>
> current thread: [EMAIL PROTECTED]
> =>[1] Perl_sv_setsv_flags(0x4f52412d, 0xfc0e7c, 0x2, 0xfc0e7c,
> 0x200, 0xe000), at 0x9db28
> [2] XS_DBI_dispatch(0xf1cc18, 0xfefb9810, 0xb59e10, 0x13b48c, 0x1,
> 0x1), at 0xfef9d754
11 matches
Mail list logo
