NYCPHP Meetup

[Jeff Loiselle]

Oh, and another question: can I issue autoCommit(false)... then
commit() after all my execute()s are complete? Or does that only work
with query()?


On Mon, 21 Mar 2005 11:42:26 -0500, Jeff Loiselle
<jeff.loiselle at gmail.com> wrote:
> Thank you very much Dan. I knew you'd pipe up to correct me sometime.
> :-) That's exactly what I am doing now. I am still using prepare() and
> execute() with PHP variables, even though there is only one query per
> table because I sense that doing that is still more portable than
> issuing query() directly?
> 
> On Mon, 21 Mar 2005 11:13:13 -0500, Daniel Convissor
> <danielc at analysisandsolutions.com> wrote:
> > On Mon, Mar 21, 2005 at 10:48:24AM -0500, Jeff Loiselle wrote:
> > > 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:
> > > > >
> > > > > DELETE FROM ? WHERE DOC_ID=? [nativecode=ORA-00903: invalid table name]
> > > >
> > > >    DELETE FROM ! WHERE DOC_ID=?
> > >
> > > that doesn't seem to cure the problem.. i'll be looking into it more today
> >
> > The process of preparing a query involves checking identifiers for
> > validity and then remembering the query framework in a native format for
> > later execution.  This speeds up execution of frequently used queries
> > because they don't need to go through the identifier checks and compiling
> > each time.  Thus, you can't substitute a table or column name this way.
> >
> > You'll need to make a regular query in which you compose the query string
> > using a PHP variable.
> >
> > --Dan
> >
> > --
> >  T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
> >             data intensive web and database programming
> >                 http://www.AnalysisAndSolutions.com/
> >  4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409
> > _______________________________________________
> > 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