DBD::Sybase with MS SQL insert problem
- From: tafinucane@xxxxxxxxx
- Date: 29 Jun 2006 15:22:13 -0700
I'm using DBD::Sybase against a MS SQL database. This configuration
does not support ? placeholders, so I'm stuck with the kluge described
below.
I'm seeing a strange result after executing the following query:
my $query = <<"ENDQUERY"
BEGIN
DECLARE \@Counter int
DECLARE \@siteurl sc_url
set \@Counter = 0
WHILE (\@counter < 100)
BEGIN
SET \@siteurl = 'http://dummy-host.nonexist' + LTRIM(STR(\@Counter))
+ '.com/'
Insert INTO DBName.dbo.tablename
(url,
created,
source_id) VALUES
(\@siteurl,GETUTCDATE(), 4)
-- dummy, now , me
SET \@Counter = \@Counter + 1
END
END
ENDQUERY
;
The table only gets filled with 57 or 58 rows! There are no errors
returned, nor does anything negative show up with DBI->trace(2).
The 50-odd rows all are filled with the correct data. I can run the
script again starting at @Counter=58 and add another 57 or so rows.
.
- Prev by Date: Re: memory leak in DBI XS bootstrap code
- Next by Date: RE: memory leak in DBI XS bootstrap code
- Previous by thread: Errors, Connecting to Oracle
- Next by thread: make test fails for DBD::ODBC on Solaris 5.8 with openlink driver
- Index(es):
Relevant Pages
|
|
