Front page | perl.dbi.users |
Postings from February 2001
RE: A puzzle.....
Thread Previous
From:
Lars Eskildsen
Date:
February 8, 2001 01:36
Subject:
RE: A puzzle.....
Message ID:
BCF0DF4F591D28439C0B79A6B79F15FA48AA73@aarhus.ccieurope.com
Hi' again
The prepare-execute paradigm works fine for the "CREATE TABLE...." example.
I really like this way of using DBI, instead of using the "do"-method, so i will
stick with it.
As for the placeholder discussion, then i have to avoid it, in case i am trying to
execute DDL statements.
The DBI manual points out, that placeholders can not be used
anywhere in a statement (something do to with ".....the database server not being able to
validate the statement and creating a query ececution plan for it.....") - is this an issue
in my situation?
Thanx
/Lars
-----Original Message-----
From: Thomas A. Lowery [mailto:stlowery@yahoo.com]
Sent: 7. februar 2001 18:28
To: dbi-users@perl.org
Subject: Re: A puzzle.....
On Wed, Feb 07, 2001 at 09:03:15AM -0800, Warden, Ronald MCF:EX wrote:
> You have to use a do statement, you can't use a prepare statement. From the
> perl manual
Actually, you can use a "prepare", however it appears that you
can not use a bound parameters in a DDL statement (at this time). As
Tim Bunce pointed up, this behavior may change.
> Is placeholders not allowed in DDL statements or what?
Tom
--
Thomas A. Lowery stlowery@yahoo.com
http://tlowery.hypermart.net
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Thread Previous