As you correctly answered, you can't. However, if he has information which would be changed at the "execute" stage, wouldn't it make sense to make just one call to say $dbh->do rather than prepate, execute?
Particularly, since I thought that mysql (vs. say Oracle) didn't really send stuff to the database till the execute step. On Mon, 10 Jun 2002, Paul DuBois wrote: > Date: Mon, 10 Jun 2002 13:06:33 -0500 > From: Paul DuBois <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: Hytham Shehab <[EMAIL PROTECTED]>, dbi <[EMAIL PROTECTED]> > Subject: Re: Fw: mysql query statement > > At 9:50 -0700 6/10/02, William R. Mussatto wrote: > >On Mon, 10 Jun 2002, Paul DuBois wrote: > > > >> Date: Mon, 10 Jun 2002 10:41:12 -0500 > >> From: Paul DuBois <[EMAIL PROTECTED]> > >> To: Hytham Shehab <[EMAIL PROTECTED]>, dbi <[EMAIL PROTECTED]> > >> Subject: Re: Fw: mysql query statement > >> > >> At 18:35 +0300 6/10/02, Hytham Shehab wrote: > >> >So, how can i make a statement like these without writing it explicity in > >> >the prepare statement? > >> > >> Do you mean "how can I write a statement where I can arbitrarily change > >> any part of it at execute() time?" > >> > >> If so, you can't. > >> > >> > > >> >thx guys. > >> > > >> >-- > >> >Hytham Shehab > > > >dbh->selectrow_array(...). > >and its cousins are more appropriate. > > Eh? How does that change the answer to the question? selectrow_array() > and cousins map to prepare + execute + some row-fetching method. > > > > > > >Sincerely, > > > >William Mussatto, Senior Systems Engineer > >CyberStrategies, Inc > >ph. 909-920-9154 ext. 27 > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27
