Re: DBI Proxy Ping

2005-06-21 Thread Tim Bunce
Thanks George. Can you resend that using 'diff -u' (or 'diff -C') run from the root od the source directory, i.e., diff -u ./lib/DBD/Proxy.pm.orig ./lib/DBD/Proxy.pm.new That way the patch is 'safe' (due to the context) and can be applied more easily from my mail reader. Thanks! Tim. On Mon,

bind_param question

2005-06-21 Thread Keith Jackson
The following code works just fine: $sth = $dbh-prepare(qq(select count(*) from discounts where min_value ?)); $sth-bind_param( 1, 5, SQL_INTEGER); $sth-execute(); The actual query my application uses is much longer and the rest of the values in the where clause are varchar's. Is there a way

Re: bind_param question

2005-06-21 Thread Rudy Lippan
On Tue, 21 Jun 2005, Keith Jackson wrote: Is there a way to assign the data type by column, then doing the execute with the value? Yup, you can use the standard bind_param and the use execute() in your loop like this: $sth-bind_param(1, undef, SQL_INEGER); foreach (@( $myArrayHash) ){

Cannot find DBD-Oracle.ppd

2005-06-21 Thread Larry Lords
Follow-up from yesterday. I still need some basic help and thanks so much for all the help so far. I am running Windows XP Pro and using Perl version 5.8.4 I have been told that I need the following files from ftp.esoftmatic.com for Oracle 9i: DBI.ppd DBI-1.45-5.8.4.tar.gz

Perl, Postgres stored procedure returning refcursor, transaction, etc

2005-06-21 Thread Pia
I spent a good deal of time to get the following working after searching through Google, so I thought maybe there's someone else that could benefit from this. The function that is called takes a refcursor as an input parameter and returns the *same* refcursor as the output. I hardcoded the name

Re: Perl, Postgres stored procedure returning refcursor, transaction, etc

2005-06-21 Thread Pia
Well, I didn't do a great job cleaning that script up. Lines 17, 18, and 38 are garbage. -- Forwarded message -- I spent a good deal of time to get the following working after searching through Google, so I thought maybe there's someone else that could benefit from this. The

Re: Attempt to initiate a new SQL Server operation with results pending.

2005-06-21 Thread Daniel Kasak
Jeff Urlwin wrote: Hi all. I've just ( barely ) managed to get DBD::ODBC == UnixODBC == FreeTDS working on my system. I took a Perl-Gtk2 app which has been running fine, and substituted the old DBD::Sybase connection with the DBD::ODBC one, and then discovered I could only run one query