Alexander Medina wrote:
I apologize if this is redundant as I know there have been previous
posts regarding this issue. However, I have not been able to find any
resolution in any of those posts.
Here are my versions of the various components :
Hardware: Apple Xserver
OS: OSX Leopard 10.5.2
On Mon, Apr 14, 2008 at 3:28 AM, Tim Bunce [EMAIL PROTECTED] wrote:
Did you build a fresh copy of DBD::Sybase after upgrading DBI?
To get this fix you'd need to do that.
Probably worth retrying, just to be sure.
I didn't really upgrade DBI, as
it is a brand new install of perl (5.10.0),
Hello all experts !
I need to log every INSERT, UPDATE and DELETE queries even when using
placeholders. Here some code:
$sql = UPDATE users SET `name`=? WHERE ìd`=1;;
$sth = $dbh-prepare($sql);
$sth-execute('Test User');
$sth-finish();
Of course execute params are given dynamically and I want
aspiritus wrote:
Hello all experts !
I need to log every INSERT, UPDATE and DELETE queries even when using
placeholders. Here some code:
$sql = UPDATE users SET `name`=? WHERE ìd`=1;;
$sth = $dbh-prepare($sql);
$sth-execute('Test User');
$sth-finish();
Of course execute params are given
I would have to agree with Martin that DBIx::Log4perl will work quite well.
In the long term you might want to accomplish this by adding some
triggers on your DB tables to record this data as well.
This way all changes to the table will be caught at the DB end. So in
cases where someone is
Beautiful! That worked. I still received the warning messages when
running 'make', but no errors. I first ran the install without adding
the -framework CoreFoundation to the Makefile, this didn't work. I
re-compiled and made the edits to the Makefile, received some warnings
as noted earlier,
Forgot to make mention that I did run a test with a perl script I
wrote to extra from the SQL database, of which it successfully
connected, extracted data and returned it.
On Tue, Apr 15, 2008 at 10:13 AM, Alexander Medina
[EMAIL PROTECTED] wrote:
Beautiful! That worked. I still received the
Alexander Medina wrote:
Beautiful! That worked. I still received the warning messages when
running 'make', but no errors. I first ran the install without adding
the -framework CoreFoundation to the Makefile, this didn't work. I
re-compiled and made the edits to the Makefile, received some
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I need to log every INSERT, UPDATE and DELETE queries even when using
placeholders. Here some code:
$sql = UPDATE users SET `name`=? WHERE d`=1;;
$sth = $dbh-prepare($sql);
$sth-execute('Test User');
$sth-finish();
Of course execute
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I need to log every INSERT, UPDATE and DELETE queries even when using
placeholders. Here some code:
$sql = UPDATE users SET `name`=? WHERE d`=1;;
$sth = $dbh-prepare($sql);
$sth-execute('Test User');
$sth-finish();
I'm trying to figure out the best way to build an heirarchial categorystructure
kinda like you'd find on yahoo or ebay. Basically I amcreating a number of
items and I am going to tie each item via a linktable to another link table
that defines the categories and subcategories.
Sample:
Scott Webster Wood wrote:
let'sjust say I left Property1 blank on the link forWindows and also
in it's parent Desktop but had it filled in on theDesktop parent
Computers (as shown above). If I wanted to find the Property1 for
the sub category but found it blank, I'd like to grab thevalue from
Douglas Wilson wrote:
With DBI 1.602 and DBD::Sybase 1.08 I get:
Can't locate object method DELETE via package DBI::st
on the second selectrow_array call.
If I replace $sth with $sql in the selectrow_array calls, then it
works correctly.
I did find a similar problem here:
Yes. This isn’t really the right place to ask a design question. So, I hope I
don't get blasted for answering here.
First, I don't think you quite know what you're trying to solve yet. But to
help with what you have here, I think you're going to need a stored procedure
that returns your
You shouldn't really need to go recursing through a data
tree to come up with all the parts of a single fact.
Well that is unless you are wanting to inherit data from linked elements
further up a link list without re-posting redundant information.
Then, instead of storing property
On Tue, Apr 15, 2008 at 09:00:56PM +0200, Michael Peppler wrote:
Douglas Wilson wrote:
With DBI 1.602 and DBD::Sybase 1.08 I get:
Can't locate object method DELETE via package DBI::st
on the second selectrow_array call.
( $total ) = $dbh-selectrow_array( $sth, undef, $id );
( $total ) =
Scott Webster Wood wrote:
You shouldn't really need to go recursing through a data tree to
come up with all the parts of a single fact.
Well that is unless you are wanting to inherit data from linked
elements further up a link list without re-posting redundant
information.
That's true enough
The closest thing that comes to this would be Oracle's Connect By
Prior syntax. I don't know if other database vendors support this.
-Original Message-
From: Colin Wetherbee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 15, 2008 11:36 AM
To: Scott Webster Wood
Cc: dbi-users@perl.org
http://www.google.com/search?hl=ennewwindow=1safe=offrlz=1T5GGLL_enUS258US259q=joe+celkobtnG=Search
On Tue, Apr 15, 2008 at 6:55 PM, Colin Wetherbee [EMAIL PROTECTED] wrote:
Scott Webster Wood wrote:
You shouldn't really need to go recursing through a data tree to
come up with all the
19 matches
Mail list logo