ANN: Gtk2::Ex::DBI-0.7

2005-02-10 Thread Daniel Kasak
I'm pleased to annouce the 7th release of Gtk2::Ex::DBI ... http://entropy.homelinux.org/Gtk2-Ex-DBI/ Gtk2::Ex::DBI is an open-source helper object that makes your Gtk2-Perl apps data aware. It handles querying, 'painting' records on your Glade-generated form, passing updates back to the database

Re: What happened to dbish?

2005-02-10 Thread Jeff Macdonald
Understood. Thanks for responding. On Wed, 9 Feb 2005 16:50:32 -0500, Thomas A. Lowery <[EMAIL PROTECTED]> wrote: > That's hasn't > > From: "Thomas A. Lowery" <[EMAIL PROTECTED]> > > And the maintainer has made any time to provide any updates or new features. > > Tom > -- Jeff Macdonald Ayer

Re: [Spam: 05.3] Re: DBD::ODBC, DBD::Sybase and parameters to stored procedures

2005-02-10 Thread DMeleshko
Thanks for the tip. I thought that using placeholders can help with execution plan caching. Nonetheless, at this point optimization is not my #1 priority. Here is a new peculiarity that I've discovered. For the T-SQL code bellow, DBD::ODBC will return a single record set containing @ret and @b,

Re: Mixing select and print statements using DBI, DBD::Sybase

2005-02-10 Thread Michael Peppler
On Thu, 2005-02-10 at 19:31, Chuck Fox wrote: > Just spoke to my Sybase Tech Support engineer and she assures me that > the statements should be coming in the order specified by the SQL. > She suggested that the DBD::Sybase implementation may be at the heart > of the matter. > I'll take a look

Re: Mixing select and print statements using DBI, DBD::Sybase

2005-02-10 Thread Chuck Fox
Just spoke to my Sybase Tech Support engineer and she assures me that the statements should be coming in the order specified by the SQL. She suggested that the DBD::Sybase implementation may be at the heart of the matter. David Goodman wrote on 2/10/2005, 1:20 PM: > No, "select ONE=1" is legi

Re: Mixing select and print statements using DBI, DBD::Sybase

2005-02-10 Thread David Goodman
No, "select ONE=1" is legitimate transact-sql. --- Michael A Chase <[EMAIL PROTECTED]> wrote: > Quoting David Goodman <[EMAIL PROTECTED]>: > > > Hello Michael: > > > > You write: > > > > "Theoretically yes - at least for queries (select > > statements). Print and raiserror statements > *should*

Re: DBD::ODBC, DBD::Sybase and parameters to stored procedures

2005-02-10 Thread David Goodman
Placeholders are only supported for values in select statements. For your exec, you will need to substitute in values with perl variables. That's the essence of the error message. regards, David --- [EMAIL PROTECTED] wrote: > Hi all, > > Trying to solve a puzzle -- how to write a > cross-platf

Re: Mixing select and print statements using DBI, DBD::Sybase

2005-02-10 Thread Michael A Chase
Quoting David Goodman <[EMAIL PROTECTED]>: > Hello Michael: > > You write: > > "Theoretically yes - at least for queries (select > statements). Print and raiserror statements *should* > normally be sent back in the same way as you'd get > them in isql, but you may be seeing buffering > differences

Re: Scrollable Cursors in DBI, Please? (Was: i need help)

2005-02-10 Thread Tim Bunce
On Thu, Feb 10, 2005 at 08:46:33AM -0800, Jonathan Leffler wrote: > On Thu, 10 Feb 2005 09:02:12 -0300, [EMAIL PROTECTED] <[EMAIL PROTECTED]> > wrote: > > well, i like move free in a table of a database, like the mysql_data_seek > > command of php, the link of the command is: > > > > http://cl2.

DBD::ODBC, DBD::Sybase and parameters to stored procedures

2005-02-10 Thread DMeleshko
Hi all, Trying to solve a puzzle -- how to write a cross-platform code to call stored procedure with output parameters and return codes. Environment: - MS SQL 2000 database - Win32, ActivePerl - 5.8.6, DBD::ODBC - Linux, perl 5.8.0, DBD::Sybase (freeTDS) Stored procedure: -

Scrollable Cursors in DBI, Please? (Was: i need help)

2005-02-10 Thread Jonathan Leffler
Dear Francisco, On Thu, 10 Feb 2005 09:02:12 -0300, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Thanks for you response. You're welcome, but please keep the discussion on the mailing list, as you will probably get a better response, especially since MySQL is not my specialist area. > well, i

Re: Mixing select and print statements using DBI, DBD::Sybase

2005-02-10 Thread David Goodman
Hello Michael: You write: "Theoretically yes - at least for queries (select statements). Print and raiserror statements *should* normally be sent back in the same way as you'd get them in isql, but you may be seeing buffering differences where the error handler prints to STDERR and your data rows

Re: FetchRow Question

2005-02-10 Thread Tim Bunce
On Wed, Feb 09, 2005 at 04:50:09PM -0800, Jonathan Leffler wrote: > On Wed, 9 Feb 2005 13:22:31 -0500, Miller, Timothy (IDS AIS Ops) > <[EMAIL PROTECTED]> wrote: > > Question, > > > > I am running two different version of perl (5.6.1 and 5.8.4), version > > 5.6 I get returned 11 rows from the l

Re: What happened to dbish?

2005-02-10 Thread Thomas A. Lowery
That's hasn't From: "Thomas A. Lowery" <[EMAIL PROTECTED]> > And the maintainer has made any time to provide any updates or new features. Tom

RE: Retrieve values from Oracle

2005-02-10 Thread De Simone, Andrew \(Genworth\)
Also, outside of the loop you're printing the variable "p1", not "field1". That's why that value is printing. >print "go here"; Andy -Original Message- From: Ronald J Kimball [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 4:43 PM To: 'MCMULLIN, NANCY'; dbi-users@perl.org

Re: i need help

2005-02-10 Thread Jonathan Leffler
Dear Francisco, On Tue, 8 Feb 2005 19:01:55 -0300, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > hello: > > First all, sorry because my english is bad Of course you are excused. My Spanish is deplorable. > I need mode back to the first row the pointer with dbi in mysql I am really having a