comment on

3. Just go with it, and inform people who complain about it how to deal with the error

Another vote for door number three.

Those of us who deal with different databases are unlikely to expect

  my $rowcount = $dbh->do("SELECT * FROM TABLE");
[download]

to be portable, and will opt for COUNT(*) (or the equivalent) instead. And those who haven't yet experienced the joys of porting database applications to different RDBMs are getting set up for an unpleasant surprise when they use that construct.

In reply to Re: DBD::SQLite dilemma by dws
in thread DBD::SQLite dilemma by Matts

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


good chemistry is complicated, and a little bit messy -LW
	PerlMonks