in reply to Re: bind_param - confusion ?
in thread bind_param - confusion ?

Use placeholders - it'll save you a lot of typing.

rdfield

Replies are listed 'Best First'.
Re: Re: Re: bind_param - confusion ?
by Ryszard (Priest) on Jul 17, 2002 at 10:32 UTC
    To elaborate on this point, if you use placeholders your code will look like this: 
    select something
from   sometable
where  foo = ? 
and    bar = ?

    [download]
    You would then prepare the statement as normal, but when executing, your execute clause will look like:$sth->execute(@bindvar); nice and simple.. :-)
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom