NYCPHP Meetup

[Jeff Loiselle]

ahh.. i've found the problem..  it seems that the tablename cannot be
a variable.. you have to explicity write the tablenames in.. this did
not seem obvious the first five times I read the documentation. :-)
thanks!


On Mon, 21 Mar 2005 10:59:20 -0500, Jeff Loiselle
<jeff.loiselle at gmail.com> wrote:
> can prepare()/autoPrepare() be used for DELETE queries?
> 
> 
> On Mon, 21 Mar 2005 10:48:24 -0500, Jeff Loiselle
> <jeff.loiselle at gmail.com> wrote:
> > that doesn't seem to cure the problem.. i'll be looking into it more today
> >
> >
> > On Fri, 18 Mar 2005 17:31:39 -0500, Brian Kaney <brian at vermonster.com> wrote:
> > > On Fri, 2005-03-18 at 17:24, Jeff Loiselle wrote:
> > > > Hello everyone,
> > > >
> > > > I need some eyes on this code.. I've been staring at it for too long..
> > > > and I dont know where to go for more debugging info.  I am using
> > > > Oracle and I get this error:
> > > >
> > > > DELETE FROM ? WHERE DOC_ID=? [nativecode=ORA-00903: invalid table name]
> > > >
> > >
> > > Try to use the ! for the field name.  This binding wildcard won't add
> > > the quoting and will pass straight through.
> > >
> > >
> > >    DELETE FROM ! WHERE DOC_ID=?
> > >
> > > - Brian
> > >
> > > _______________________________________________
> > > New York PHP Talk Mailing List
> > > AMP Technology
> > > Supporting Apache, MySQL and PHP
> > > http://lists.nyphp.org/mailman/listinfo/talk
> > > http://www.nyphp.org
> > >
> >
> > --
> > ---
> > Jeff Loiselle
> > Web Developer, Musician, and Observer
> > http://jeff.loiselles.com
> >
> 
> --
> ---
> Jeff Loiselle
> Web Developer, Musician, and Observer
> http://jeff.loiselles.com
> 


-- 
---
Jeff Loiselle
Web Developer, Musician, and Observer
http://jeff.loiselles.com