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
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 wa
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 w
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 s
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
err
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 1.
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
option
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, especiall
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 spa
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 = $dbh->pre
[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)
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 n
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 sysad
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 thi
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
>'H:/perl/site/lib/aut
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 h
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
O
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 and
18 matches
Mail list logo