On Sat, 18 Jan 2003 11:13:52 -0800 Jeff Zucker <[EMAIL PROTECTED]> wrote:
> alex wrote:
>
> >> my $rv4 = $sth4->execute('$ip','$http_user_agent');
> >> if ($rv4 eq '0E0') {
> >>
> >
> > ahhhh... removing the ' around the vars will fix it :-(. my fault... but the
> > ' are needed on inserts... strange thing...
>
>
> See the following for a description of when quote marks are needed and
> when they aren't:
>
> http://xmlproj.com/cgi/fom.cgi?file=143
Also note that some objects have stringifying methods which allow you
to use "" or qq() to convert the objects into a useful string. None
of that applies to normal DBI placeholders though.
Alex:
I hope you aren't depending on $rv4 to tell you whether a select
found any rows. The return value from execute() is not generally a
dependable row count for SELECT statements.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
