List:MySQL and Perl« Previous MessageNext Message »
From:Jochen Wiedmann Date:October 7 1999 2:23pm
Subject:Re: placeholder funny w msql-mysql-modules-1.2207
View as plain text  
Yoichi Takayama wrote:

> This code works perfectly fine and all the '?' in the field values
> themselves are not replaced as placeholders at all.
> 
> So, it seems that this is the way to go.  There is no need for $dbh->quote,
> either.  The code is easier to read than nested double quotes case with '?'
> within $statement and making the intention confusing or the handler code
> complex???

Exactly.

And, because you don´t seem to care for error messages, how about

	
	my $dbh = DBI->connect($dbs, undef, undef, {RaiseError => 1});

then it is even correct, to ignore possible errors, because Perl
takes care for you.


Bye,

Jochen


-- 
Jochen Wiedmann						joe@stripped
Life has brown and green eyes. :-)			+49 7123 14887
Thread
placeholder funny w msql-mysql-modules-1.2207colin6 Oct
  • Re: placeholder funny w msql-mysql-modules-1.2207Yoichi Takayama7 Oct
  • Re: placeholder funny w msql-mysql-modules-1.2207Jochen Wiedmann7 Oct
    • Re: placeholder funny w msql-mysql-modules-1.2207colin7 Oct
    • Re: placeholder funny w msql-mysql-modules-1.2207Hugo7 Oct
    • Re: placeholder funny w msql-mysql-modules-1.2207Jochen Wiedmann7 Oct
      • Re: placeholder funny w msql-mysql-modules-1.2207colin7 Oct
      • Re: placeholder funny w msql-mysql-modules-1.2207Hugo7 Oct
    • Re: placeholder funny w msql-mysql-modules-1.2207Jochen Wiedmann8 Oct
      • Re: placeholder funny w msql-mysql-modules-1.2207colin8 Oct
Re: placeholder funny w msql-mysql-modules-1.2207colin7 Oct
  • Re: placeholder funny w msql-mysql-modules-1.2207Yoichi Takayama7 Oct
    • Re: placeholder funny w msql-mysql-modules-1.2207Jochen Wiedmann7 Oct
      • Re: placeholder funny w msql-mysql-modules-1.2207colin7 Oct
    • Re: placeholder funny w msql-mysql-modules-1.2207Jochen Wiedmann8 Oct
      • Re: placeholder funny w msql-mysql-modules-1.2207Yoichi Takayama9 Oct
  • Re: placeholder funny w msql-mysql-modules-1.2207Rob Huffstedtler7 Oct
Re: placeholder funny w msql-mysql-modules-1.2207Yoichi Takayama8 Oct