Re: Problems passing a reference to a hash between functions


A. Sinan Unur wrote:


>
> > 3. Surely, you don't need to do separate prepare,execute and fetch.
>
> Well, that separation is actually a good idea in general. You prepare
> once, execute when needed, and fetch while you want more results.
>

Yes - the reason I prepare separately is because I have certain SQL
commands which need to be executed many times with varied input.
Preparing the statement once allows me to catch any syntax errors at
the start and also improves performance.

.

Relevant Pages

  • Re: Problems passing a reference to a hash between functions
    ... I think it's logical mistake to return `false' in case of ... Surely, you don't need to do separate prepare,execute and fetch. ... Sinan Unur ...
    (comp.lang.perl.misc)
  • How to get values from SELECT stmt into local variables?
    ... I have a table which is used for history. ... do something similar to the FETCH INTO command used by a cursor, ... the only options I have are to fetch each value ... separately with separate SELECT statements, or to make a cursor that ...
    (microsoft.public.sqlserver.programming)
  • Re: U.K. news
    ... alternative system, or just fetch a bigger hammer and make it fit, is ... a separate issue. ... As a certified Butch Top, I say fetch the hammer and think of ...
    (soc.motss)
  • Re: mail merge to more than one documents
    ... If you run the following macro over the document produced by executing the ... it will split that document into separate documents ... ' Macro created by Doug Robbins to save each letter created by a mailmerge ... You first execute that mailmerge, then save that file and close it. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Merge Multiple Records Individual Documents
    ... If you run the following macro over the document produced by executing the ... it will split that document into separate documents ... ' Macro created by Doug Robbins to save each letter created by a mailmerge ... You first execute that mailmerge, then save that file and close it. ...
    (microsoft.public.word.mailmerge.fields)