Ok, through no fault of my own, I've got to work with an Access database. The user who created the database created columns with names like "active?" and "is deleted?".
Normally this'd mean I'd have SQL like
select [active?], [is deleted?] from FOO;
My problem is that as soon as perl DBI (active perl in this case) sees those "?"s, it thinks that there is a bind and it's complaining with
DBD::ODBC::st execute failed: [Microsoft][ODBC MIcrosoft Access Driver
+]COUNT field incorrect (SQL-07002) at prog.pl
How can I disable binding or quote these columns in such a way as to not trigger binding?
--
I used to drive a Heisenbergmobile, but every time I looked at the speedometer, I got lost.
-
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.
|
