Patrick,
Welcome back.
I posted the email below back in December (I think). I'm not sure my solution
is correct but it seems to work. I've included Tim's followup since it also
seems relevant.
BTW, DBD::mysql does not compile out of the box with a standards C compiler
due to an incorrect #if
Hello,
I need DBI and DBD-DB2 packages for Activeperl, but esoftmatic server is
unreachable.
Can anybody help me with this problem or send me this files?
Thanks for any help.
Kind Regards
Denis Baumgaertner
System and Network Consultant
__
SPIRIT/21 AG
On Monday 30 January 2006 02:24 pm, Patrick Galbraith wrote:
Greetings all!
I apologise for what might seem somewhat of a bit of neglect on my part
to get some features into DBD::mysql, features such as UTF support, some
bugs in 3.0002_4. I've been super busy on some other projects, but have
I see no replies to this post, so here goes...
On Thu, 26 Jan 2006 15:49:09 +0800, nyem wrote:
I'm using DBD::ASAny on my development machine (win2000) but when I
copied them to the production server (win2003) I got this error:
install_driver(ASAny) failed: Can't load
Hi all,
I have a bugzilla database running on mysql. If you are aware of
bugzilla, it has a table called attachments. what i am trying to do
is get the attachments of all the bugs having attachment/s into a
directory.
for example there is a bug with a attachment named abc.zip. can i
extract this
On 2006-01-31 09:40:32 +1100, Ron Savage wrote:
On Mon, 30 Jan 2006 12:55:53 +0100, Peter J. Holzer wrote:
Redhat EL 2.1 perl 5.6.1 supported until May 2009
Redhat EL 3 perl 5.8.0 supported until Oct 2010
Oh. I didn't know that. Thanx.
So, if Tim wants to support those sysadmins who
Sham Prasad wrote:
Hi all,
Hello,
I have a bugzilla database running on mysql. If you are aware of
bugzilla, it has a table called attachments. what i am trying to do
is get the attachments of all the bugs having attachment/s into a
directory.
for example there is a bug with a attachment
[EMAIL PROTECTED] wrote:
Hi.
Hello,
Solved after I posted.
Surround $email with 's.
As in '$email'.
Close, but this is a gun pointed at your head :)
You either need to $dbh-quote() it or do the bind value/placeholder
(see `perldoc DBI` for details of both)
I am using the ODBC module to talk to an Access database. In that
database some of the column names have spaces in them (something like
EMPLOYEE NAME).
I have tried a bunch of stuff (backticking, brackets, braces, variables)
but I cannot seem to do a select on that table.
my $sth =
I believe you want square-brackets for Access:
my $sth = $dbh-prepare(SELECT * FROM taskhours_per_date WHERE [EMPLOYEE NAME]
= ?);
Paul
Quoting Robert Hicks [EMAIL PROTECTED]:
I am using the ODBC module to talk to an Access database. In that
database some of the column names have spaces in
You need to pass the quotes to the SQL engine. And by the way, you
should either use parameters or the quote function for values:
my $sth=$dbh-prepare('select * from taskhours_per_date where employee
name=?');
$sth-execute('NAME HERE');
Maybe MS Acesss has other ways to do this, especially
Ugg!!
first coice is to rebuild the table
second choice
I found that wrapping the offending field name in [ ] worked with ODBC and
OLE but I am not sure how this will workd with DBI?
something like this
SELECT * FROM taskhours_per_date WHERE [EMPLOYEE NAME] = 'NAME HERE'
might work
Hi,
I had trouble loading DBD::Sybase on MacOSx 10.4.4..
Any ideas
boehme:~/DBD-Sybase-1.05_02 boehme$ perl Makefile.PL
Sybase OpenClient 12.5.1 ASE Edition found.
By default DBD::Sybase 1.05 and later use the 'CHAINED' mode (where
available)
when 'AutoCommit' is turned off. Versions
Seems to be working now for me: http://ftp.esoftmatic.com/outgoing/DBI/
Dan
On 31-Jan-2006 10:09:34 CET, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hello,
I need DBI and DBD-DB2 packages for Activeperl, but esoftmatic server is
unreachable.
Can anybody help me with this problem or send me
Apache::DBI and DBI's connect_cached both claim to keep your database
handles fresh and happy, but I've had numerous problems trying to get either
of them to work properly. If a database connection is dropped, sometimes I'd
have to refresh the page two or three times before the internal server
On Sat, Jan 28, 2006 at 09:48:17PM +0200, Marko Asplund wrote:
hi
I've been doing some more tests concerning this issue and it seems
that it only appears with the combination of Oracle Instant client
libraries, Perl configured with -Dusemymalloc on RHEL 3. When I
configure Perl
Alexander Foken wrote:
You need to pass the quotes to the SQL engine. And by the way, you
should either use parameters or the quote function for values:
my $sth=$dbh-prepare('select * from taskhours_per_date where employee
name=?');
$sth-execute('NAME HERE');
Maybe MS Acesss has other ways
use backticks instead of double quotes:
my $sth=$dbh-prepare('select * from taskhours_per_date where `employee
name`=?');
Regards,
Renee
Am 31.01.2006 um 23:58 Uhr haben Sie geschrieben:
Alexander Foken wrote:
You need to pass the quotes to the SQL engine. And by the way, you
should
18 matches
Mail list logo
