FW: CPAN Upload: J/JU/JURL/DBD-ODBC-0.45_9.tar.gz

Patch to fix more problem(s) with SQLServer, stored procedures and inserts (multiple result sets) Hopefully -- this will fix all known bugs. Regards, Jeff The uploaded file DBD-ODBC-0.45_9.tar.gz has entered CPAN as file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-0.45_9.tar.gz size: 7875

RE: Problem with stored procedures with inserts.

Ok -- I have a quick fix for this which I'll release shortly. I still need to look into a few other bugs. This may not be a complete fix, but it seems to resolve the issues. I plan on making a SQLServer specific set of tests that add these issues and others that have come up, so they can be pro

RE: Problem with stored procedures with inserts.

Thanks -- I'll look at it in more detail later tonight. Regards, Jeff > > > Ok, I have modified the script you sent me to make it re-produce this > condition. The script you sent did work as you sent it, and when > I modified > it to take an input parameter, it still worked. However, when I add

Reading a TDS file with DBI

I'm using some of the tracing functions in MS SQL Server (sp_trace_create, sp_trace_setevent, etc.). These functions create an output file which, I'm told, is in tabular data stream format. Is there a way to read this with DBI? If so, which DBD module do I need, and what would the syntax f

Re: Thoughts on DBD::CSV?

John Brooking wrote: >However, I'm experiencing some limitations and odd > behavior with DBD::CSV, which I don't see addressed in > the perldoc. The problem I'm currently struggling with > concerns the comparison operators used on text fields. That kind of comparison was not supported in th

Thoughts on DBD::CSV?

Hello, DBI users, I'm brand new to this list, almost as new to DBI (~2 months), and not quite as new as that to Perl (~1 year). I've started my DBI experimentation using the DBD::CSV driver, with the thought that it's easier as a human to development with text data files, where one can view an

PASS DBI-1.30 i686-linux 2.4.2

This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ Please cc any replies to [EMAIL PROTECTED] to keep other test volunteers informed and to prevent any duplicate effort. -- Summary of my perl5 (rev

RE: Problem with stored procedures with inserts.

> I am having a problem with a script after upgrading the DBD::ODBC > the script > was running from version 0.28 to 0.45.8. I am getting invalid cursor state > errors on stored procedures that contain insert queries. This is using MS > SQL 7.0, Activestate Perl 5.6.1 bild 631. Is there something

Re: Help on querying between dates

On Mon, 29 Jul 2002 09:46:04 -0400 Ronald J Kimball <[EMAIL PROTECTED]> wrote: > On Thu, Jul 25, 2002 at 11:54:29AM -0400, Jean-Claude Girard wrote: > > If you want entries on your $toDate to be included, you should use: > > > > AND to_date($toDate,'DD/MM/YYY') +1 > > >

Re: Help on querying between dates

On Thu, Jul 25, 2002 at 11:54:29AM -0400, Jean-Claude Girard wrote: > If you want entries on your $toDate to be included, you should use: > > AND to_date($toDate,'DD/MM/YYY') +1 > > because to_date('01/01/02','DD/MM/YY') is the first of January 2002 at > precisely midnigh

Re: On some machines it works, but not on others.

On Thu, Jul 25, 2002 at 09:23:55AM -0400, [EMAIL PROTECTED] wrote: > I wrote: > > [snip a whole bunch of worthless nonsense] > > Nevermind folks. Found the problem. Field-width problem rising up again > from the dead. I'm an idiot. I'm going to go hide under a rock now. > Please forgive my in

Re: CPAN Upload: T/TI/TIMB/DBI_AdvancedTalk_2002.tar.gz

On Monday 29 July 2002 1:28 pm, Bart Lateur wrote: > On Mon, 29 Jul 2002 13:18:05 +0100, Graham Barr wrote: > >And also now on the new shiny site at > > > > http://search-beta.cpan.org/author/TIMB/DBI_AdvancedTalk_2002/index.htm > > > >It should be much faster serving from there. > > What's that

Re: CPAN Upload: T/TI/TIMB/DBI_AdvancedTalk_2002.tar.gz

On Mon, 29 Jul 2002 13:18:05 +0100, Graham Barr wrote: >And also now on the new shiny site at > > http://search-beta.cpan.org/author/TIMB/DBI_AdvancedTalk_2002/index.htm > >It should be much faster serving from there. What's that little square as the last character of the title (right after "DB

Re: CPAN Upload: T/TI/TIMB/DBI_AdvancedTalk_2002.tar.gz

On Mon, Jul 29, 2002 at 01:06:53PM +0100, Tim Bunce wrote: > On Sat, Jul 20, 2002 at 10:42:10AM -0500, Steven Lembark wrote: > > > > > > Of course I intended to announce it when I was ready... but never mind :) > > C

Re: CPAN Upload: T/TI/TIMB/DBI_AdvancedTalk_2002.tar.gz

On Sat, Jul 20, 2002 at 10:42:10AM -0500, Steven Lembark wrote: > > Of course I intended to announce it when I was ready... but never mind :) Can be read on-line starting here: http://search.cpan.org/doc/TIMB/DB

Re: Update return/locking

Hi ! The Update, Insert and Delete statements don't return the row inserted/updated, they only return the number of rows affected by the statement. If you want to check the new value ot the row inserted, as far as I know, you must execute another SELECT statement unless the row is an AUTO_IN

Update return/locking

Hi, I'm extremely new to Perl/DBI, so apologies for the dumb question. I am wondering whether DBI returns the affected records with an insert, update oR delete query. It appears to, but I can't access the data. See the code below $qry = &Prepare_Query($dbh, "update tblSetup set next_val_id = nex