Re: Re: Truncation Issues with SQL Server Insert Statement

2004-07-14 Thread Michael Peppler
On Tue, 2004-07-13 at 22:11, amonotod wrote: I noticed, in the message this morning from M. Peppler, that he mentioned a BLK API, but I've never heard of this before. Does DBI in general support this, or only certain DBDs? The BLK api is specific to Sybase, although something similar

Re: Truncation Issues with SQL Server Insert Statement

2004-07-13 Thread amonotod
From: Tim Bunce [EMAIL PROTECTED] Date: 2004/07/13 Tue PM 06:38:51 GMT I have been writing a perl script that takes a row of 43 fields, splits on a tab, and performs an execute_array into an SQL Server database, all in a loop. The insert statement works fine, it doesn't

Re: Truncation Issues with SQL Server Insert Statement

2004-07-13 Thread Hardy Merrill
The problem with the original question/issue is that the poster did not include any DBI code. Gathering from Amonotod's comments below, the issue may be the quoting (or lack of proper quoting) done. Original poster: did you use either the quote method, or better yet did you use placeholders??

Re: Re: Truncation Issues with SQL Server Insert Statement

2004-07-13 Thread amonotod
From: Hardy Merrill [EMAIL PROTECTED] Date: 2004/07/13 Tue PM 07:42:25 GMT Original poster: did you use either the quote method, or better yet did you use placeholders?? You know, to be more accurate, I am indeed using placeholders, after constucting my sql statement from my field names.

Re: Re: Truncation Issues with SQL Server Insert Statement

2004-07-13 Thread Hardy Merrill
Sorry amonotod, I don't recall what Michael (Peppler) said about BLK API, but if he said it I'm sure it's true :-) Michael is *the* guy for DBD::Sybase and dare I say one of the most knowledgable DBI, DBD::Sybase, Perl, Sybase, etc. people around. I don't mean to slight any others - there are

Re: Re: Truncation Issues with SQL Server Insert Statement

2004-07-13 Thread David Goodman
The BLK API is not DBI but rather DBD::Sybase, inherited from Sybase Open Client Libraries. --- Hardy Merrill [EMAIL PROTECTED] wrote: Sorry amonotod, I don't recall what Michael (Peppler) said about BLK API, but if he said it I'm sure it's true :-) Michael is *the* guy for DBD::Sybase

RE: Truncation Issues with SQL Server Insert Statement

2004-07-13 Thread Lisa Homstad
]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Truncation Issues with SQL Server Insert Statement The problem with the original question/issue is that the poster did not include any DBI code. Gathering from Amonotod's comments below, the issue may be the quoting (or lack of proper quoting) done

Re: Truncation Issues with SQL Server Insert Statement

2004-07-13 Thread Tim Bunce
Issues with SQL Server Insert Statement The problem with the original question/issue is that the poster did not include any DBI code. Gathering from Amonotod's comments below, the issue may be the quoting (or lack of proper quoting) done. Original poster: did you use either the quote method