Rounding error
Martin Landsem <[email protected]> Wed, 27 Aug 2014 21:47:49 +0200
| Newsgroups | gmane.comp.db.mdb-tools.devel |
|---|---|
| Message-ID | <CAGp7Jcup-=fycm_ndGzhTS0Bz3T8EZt7-rXtN5jEfA+GmWeRfQ@mail.gmail.com> |
--===============7505436779167002586==
Content-Type: multipart/alternative; boundary=001a113397e4e9afac0501a1b198
--001a113397e4e9afac0501a1b198
Content-Type: text/plain; charset=UTF-8
I am using mdbtools to connect to a mdb-file and retrieve some data from a
table in the mdbfile.
In the table there is a field which contains values like
0.17, 0.25, 0.17, 0.50, 0.75
I see these numbers when looking at the db with MDB Explorer on my MacBook.
But when I select the same field with a PDO/ODBC connection in PHP this is
the value i get;
000000000000000.
When I look up the field information in MDB Explorer this is the
information I get;
- *Type:* Numeric
- *Precision:* 17
- *Scale:* 2
- *Decimal places:* Auto
- *Required:* NO
With values like
1.25, 1.3, 1.4, 1.2 ....
The value I get in PHP;
000000000000001.
When I dump the table to a .sql file from MDB Explorer I get values like;
3.60 instead of 000000000000003.
It seems like when I get the value to PHP it is rounded down, and
zerofilled. Anyone have any suggestions to what might be wrong, and how I
could fix this?
$query = 'SELECT * FROM Sales';
$db = isset($this->connection) ? $this->connection : $this->openConnection();
$se = $db->prepare($query);
$se->execute();
while( $s = $se->fetch(PDO::FETCH_ASSOC) ){
echo $s['HoursWorked']. PHP_EOL;}
I have also tried to dump the result, but the value is like that as soon as
I fetch it.
Here is the connection:
new PDO("odbc:DRIVER=MDBTools;DSN=MYMDB;UID=;PWD=;");
I don't know what could be wrong, but perhaps someone here has an idea?
Version info:
Name : mdbtools
Arch : x86_64
Version : 0.6
Release : 0.7.cvs20051109.el6.1
Martin Landsem
(+47) 957 06 206
[email protected]
landsemsolutions.no
--001a113397e4e9afac0501a1b198
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><p style=3D"margin:0px 0px 1em;padding:0px;border:0px;font=
-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:=
Arial,'Liberation Sans','DejaVu Sans',sans-serif;line-heigh=
t:17.804800033569336px;background-image:initial;background-repeat:initial">
I am using mdbtools to connect to a mdb-file and retrieve some data from a =
table in the mdbfile.</p><p style=3D"margin:0px 0px 1em;padding:0px;border:=
0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font=
-family:Arial,'Liberation Sans','DejaVu Sans',sans-serif;li=
ne-height:17.804800033569336px;background-image:initial;background-repeat:i=
nitial">
In the table there is a field which contains values like</p><pre class=3D""=
style=3D"margin-top:0px;margin-bottom:10px;padding:5px;border:0px;font-siz=
e:14px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucid=
a Console','Liberation Mono','DejaVu Sans Mono','Bi=
tstream Vera Sans Mono','Courier New',monospace,serif;overflow:=
auto;width:auto;max-height:600px;word-wrap:normal;color:rgb(0,0,0);line-hei=
ght:17.804800033569336px;background:rgb(238,238,238)">
<code style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;fo=
nt-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mo=
no','DejaVu Sans Mono','Bitstream Vera Sans Mono','=
Courier New',monospace,serif;white-space:inherit;background-image:initi=
al;background-repeat:initial"><span class=3D"" style=3D"margin:0px;padding:=
0px;border:0px;vertical-align:baseline;color:rgb(128,0,0);background:transp=
arent">0.17</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0=
px;vertical-align:baseline;background:transparent">,</span><span class=3D""=
style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;backgro=
und:transparent"> </span><span class=3D"" style=3D"margin:0px;padding:0px;b=
order:0px;vertical-align:baseline;color:rgb(128,0,0);background:transparent=
">0.25</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;ve=
rtical-align:baseline;background:transparent">,</span><span class=3D"" styl=
e=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;background:t=
ransparent"> </span><span class=3D"" style=3D"margin:0px;padding:0px;border=
:0px;vertical-align:baseline;color:rgb(128,0,0);background:transparent">0.1=
7</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertica=
l-align:baseline;background:transparent">,</span><span class=3D"" style=3D"=
margin:0px;padding:0px;border:0px;vertical-align:baseline;background:transp=
arent"> </span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;=
vertical-align:baseline;color:rgb(128,0,0);background:transparent">0.50</sp=
an><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-ali=
gn:baseline;background:transparent">,</span><span class=3D"" style=3D"margi=
n:0px;padding:0px;border:0px;vertical-align:baseline;background:transparent=
"> </span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;verti=
cal-align:baseline;color:rgb(128,0,0);background:transparent">0.75</span></=
code></pre>
<p style=3D"margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertic=
al-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,'Libera=
tion Sans','DejaVu Sans',sans-serif;line-height:17.804800033569=
336px;background-image:initial;background-repeat:initial">
I see these numbers when looking at the db with MDB=C2=A0Explorer on my Mac=
Book. But when I select the same field with a PDO/ODBC connection in PHP th=
is is the value i get;</p><pre class=3D"" style=3D"margin-top:0px;margin-bo=
ttom:10px;padding:5px;border:0px;font-size:14px;vertical-align:baseline;fon=
t-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mon=
o','DejaVu Sans Mono','Bitstream Vera Sans Mono','C=
ourier New',monospace,serif;overflow:auto;width:auto;max-height:600px;w=
ord-wrap:normal;color:rgb(0,0,0);line-height:17.804800033569336px;backgroun=
d:rgb(238,238,238)">
<code style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;fo=
nt-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mo=
no','DejaVu Sans Mono','Bitstream Vera Sans Mono','=
Courier New',monospace,serif;white-space:inherit;background-image:initi=
al;background-repeat:initial"><span class=3D"" style=3D"margin:0px;padding:=
0px;border:0px;vertical-align:baseline;color:rgb(128,0,0);background:transp=
arent">000000000000000.</span></code></pre>
<p style=3D"margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertic=
al-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,'Libera=
tion Sans','DejaVu Sans',sans-serif;line-height:17.804800033569=
336px;background-image:initial;background-repeat:initial">
When I look up the field information in MDB Explorer this is the informatio=
n I get;</p><ul style=3D"margin:0px 0px 1em 30px;padding:0px;border:0px;fon=
t-size:14px;vertical-align:baseline;list-style-position:initial;color:rgb(0=
,0,0);font-family:Arial,'Liberation Sans','DejaVu Sans',san=
s-serif;line-height:17.804800033569336px;background-image:initial;backgroun=
d-repeat:initial">
<li style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;back=
ground:transparent"><strong style=3D"margin:0px;padding:0px;border:0px;vert=
ical-align:baseline;background:transparent">Type:</strong>=C2=A0Numeric</li=
><li style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;bac=
kground:transparent">
<strong style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;=
background:transparent">Precision:</strong>=C2=A017</li><li style=3D"margin=
:0px;padding:0px;border:0px;vertical-align:baseline;background:transparent"=
><strong style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline=
;background:transparent">Scale:</strong>=C2=A02</li>
<li style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;back=
ground:transparent"><strong style=3D"margin:0px;padding:0px;border:0px;vert=
ical-align:baseline;background:transparent">Decimal places:</strong>=C2=A0A=
uto</li>
<li style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;back=
ground:transparent"><strong style=3D"margin:0px;padding:0px;border:0px;vert=
ical-align:baseline;background:transparent">Required:</strong>=C2=A0NO</li>=
</ul>
<p style=3D"margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertic=
al-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,'Libera=
tion Sans','DejaVu Sans',sans-serif;line-height:17.804800033569=
336px;background-image:initial;background-repeat:initial">
With values like</p><pre class=3D"" style=3D"margin-top:0px;margin-bottom:1=
0px;padding:5px;border:0px;font-size:14px;vertical-align:baseline;font-fami=
ly:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono'=
,'DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier=
New',monospace,serif;overflow:auto;width:auto;max-height:600px;word-wr=
ap:normal;color:rgb(0,0,0);line-height:17.804800033569336px;background:rgb(=
238,238,238)">
<code style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;fo=
nt-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mo=
no','DejaVu Sans Mono','Bitstream Vera Sans Mono','=
Courier New',monospace,serif;white-space:inherit;background-image:initi=
al;background-repeat:initial"><span class=3D"" style=3D"margin:0px;padding:=
0px;border:0px;vertical-align:baseline;color:rgb(128,0,0);background:transp=
arent">1.25</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0=
px;vertical-align:baseline;background:transparent">,</span><span class=3D""=
style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;backgro=
und:transparent"> </span><span class=3D"" style=3D"margin:0px;padding:0px;b=
order:0px;vertical-align:baseline;color:rgb(128,0,0);background:transparent=
">1.3</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;ver=
tical-align:baseline;background:transparent">,</span><span class=3D"" style=
=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;background:tr=
ansparent"> </span><span class=3D"" style=3D"margin:0px;padding:0px;border:=
0px;vertical-align:baseline;color:rgb(128,0,0);background:transparent">1.4<=
/span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-=
align:baseline;background:transparent">,</span><span class=3D"" style=3D"ma=
rgin:0px;padding:0px;border:0px;vertical-align:baseline;background:transpar=
ent"> </span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;ve=
rtical-align:baseline;color:rgb(128,0,0);background:transparent">1.2</span>=
<span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:=
baseline;background:transparent"> </span><span class=3D"" style=3D"margin:0=
px;padding:0px;border:0px;vertical-align:baseline;background:transparent">.=
...</span></code></pre>
<p style=3D"margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertic=
al-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,'Libera=
tion Sans','DejaVu Sans',sans-serif;line-height:17.804800033569=
336px;background-image:initial;background-repeat:initial">
The value I get in PHP;</p><pre class=3D"" style=3D"margin-top:0px;margin-b=
ottom:10px;padding:5px;border:0px;font-size:14px;vertical-align:baseline;fo=
nt-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mo=
no','DejaVu Sans Mono','Bitstream Vera Sans Mono','=
Courier New',monospace,serif;overflow:auto;width:auto;max-height:600px;=
word-wrap:normal;color:rgb(0,0,0);line-height:17.804800033569336px;backgrou=
nd:rgb(238,238,238)">
<code style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;fo=
nt-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mo=
no','DejaVu Sans Mono','Bitstream Vera Sans Mono','=
Courier New',monospace,serif;white-space:inherit;background-image:initi=
al;background-repeat:initial"><span class=3D"" style=3D"margin:0px;padding:=
0px;border:0px;vertical-align:baseline;color:rgb(128,0,0);background:transp=
arent">000000000000001.</span></code></pre>
<p style=3D"margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertic=
al-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,'Libera=
tion Sans','DejaVu Sans',sans-serif;line-height:17.804800033569=
336px;background-image:initial;background-repeat:initial">
When I dump the table to a .sql file from MDB Explorer I get values like;</=
p><pre class=3D"" style=3D"margin-top:0px;margin-bottom:10px;padding:5px;bo=
rder:0px;font-size:14px;vertical-align:baseline;font-family:Consolas,Menlo,=
Monaco,'Lucida Console','Liberation Mono','DejaVu Sans =
Mono','Bitstream Vera Sans Mono','Courier New',monospac=
e,serif;overflow:auto;width:auto;max-height:600px;word-wrap:normal;color:rg=
b(0,0,0);line-height:17.804800033569336px;background:rgb(238,238,238)">
<code style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;fo=
nt-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mo=
no','DejaVu Sans Mono','Bitstream Vera Sans Mono','=
Courier New',monospace,serif;white-space:inherit;background-image:initi=
al;background-repeat:initial"><span class=3D"" style=3D"margin:0px;padding:=
0px;border:0px;vertical-align:baseline;color:rgb(128,0,0);background:transp=
arent">3.60</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0=
px;vertical-align:baseline;background:transparent"> instead of </span><span=
class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:basel=
ine;color:rgb(128,0,0);background:transparent">000000000000003.</span></cod=
e></pre>
<p style=3D"margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertic=
al-align:baseline;clear:both;color:rgb(0,0,0);font-family:Arial,'Libera=
tion Sans','DejaVu Sans',sans-serif;line-height:17.804800033569=
336px;background-image:initial;background-repeat:initial">
It seems like when I get the value to PHP it is rounded down, and zerofille=
d. Anyone have any suggestions to what might be wrong, and how I could fix =
this?</p><pre class=3D"" style=3D"margin-top:0px;margin-bottom:10px;padding=
:5px;border:0px;font-size:14px;vertical-align:baseline;font-family:Consolas=
,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaV=
u Sans Mono','Bitstream Vera Sans Mono','Courier New',m=
onospace,serif;overflow:auto;width:auto;max-height:600px;word-wrap:normal;c=
olor:rgb(0,0,0);line-height:17.804800033569336px;background:rgb(238,238,238=
)">
<code style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;fo=
nt-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mo=
no','DejaVu Sans Mono','Bitstream Vera Sans Mono','=
Courier New',monospace,serif;white-space:inherit;background-image:initi=
al;background-repeat:initial"><span class=3D"" style=3D"margin:0px;padding:=
0px;border:0px;vertical-align:baseline;background:transparent">$query </spa=
n><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-alig=
n:baseline;background:transparent">=3D</span><span class=3D"" style=3D"marg=
in:0px;padding:0px;border:0px;vertical-align:baseline;background:transparen=
t"> </span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vert=
ical-align:baseline;color:rgb(128,0,0);background:transparent">'SELECT =
* FROM Sales'</span><span class=3D"" style=3D"margin:0px;padding:0px;bo=
rder:0px;vertical-align:baseline;background:transparent">;</span><span clas=
s=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;b=
ackground:transparent">
$db </span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vert=
ical-align:baseline;background:transparent">=3D</span><span class=3D"" styl=
e=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;background:t=
ransparent"> isset</span><span class=3D"" style=3D"margin:0px;padding:0px;b=
order:0px;vertical-align:baseline;background:transparent">(</span><span cla=
ss=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;=
background:transparent">$this</span><span class=3D"" style=3D"margin:0px;pa=
dding:0px;border:0px;vertical-align:baseline;background:transparent">-><=
/span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-=
align:baseline;background:transparent">connection</span><span class=3D"" st=
yle=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;background=
:transparent">)</span><span class=3D"" style=3D"margin:0px;padding:0px;bord=
er:0px;vertical-align:baseline;background:transparent"> </span><span class=
=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;ba=
ckground:transparent">?</span><span class=3D"" style=3D"margin:0px;padding:=
0px;border:0px;vertical-align:baseline;background:transparent"> $this</span=
><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align=
:baseline;background:transparent">-></span><span class=3D"" style=3D"mar=
gin:0px;padding:0px;border:0px;vertical-align:baseline;background:transpare=
nt">connection </span><span class=3D"" style=3D"margin:0px;padding:0px;bord=
er:0px;vertical-align:baseline;background:transparent">:</span><span class=
=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;ba=
ckground:transparent"> $this</span><span class=3D"" style=3D"margin:0px;pad=
ding:0px;border:0px;vertical-align:baseline;background:transparent">-></=
span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-a=
lign:baseline;background:transparent">openConnection</span><span class=3D""=
style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;backgro=
und:transparent">();</span><span class=3D"" style=3D"margin:0px;padding:0px=
;border:0px;vertical-align:baseline;background:transparent">
$se </span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vert=
ical-align:baseline;background:transparent">=3D</span><span class=3D"" styl=
e=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;background:t=
ransparent"> $db</span><span class=3D"" style=3D"margin:0px;padding:0px;bor=
der:0px;vertical-align:baseline;background:transparent">-></span><span c=
lass=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:baselin=
e;background:transparent">prepare</span><span class=3D"" style=3D"margin:0p=
x;padding:0px;border:0px;vertical-align:baseline;background:transparent">(<=
/span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-=
align:baseline;background:transparent">$query</span><span class=3D"" style=
=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;background:tr=
ansparent">);</span><span class=3D"" style=3D"margin:0px;padding:0px;border=
:0px;vertical-align:baseline;background:transparent">
$se</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;verti=
cal-align:baseline;background:transparent">-></span><span class=3D"" sty=
le=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;background:=
transparent">execute</span><span class=3D"" style=3D"margin:0px;padding:0px=
;border:0px;vertical-align:baseline;background:transparent">();</span><span=
class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:basel=
ine;background:transparent">
</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical=
-align:baseline;color:rgb(0,0,139);background:transparent">while</span><spa=
n class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:base=
line;background:transparent">(</span><span class=3D"" style=3D"margin:0px;p=
adding:0px;border:0px;vertical-align:baseline;background:transparent"> $s <=
/span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-=
align:baseline;background:transparent">=3D</span><span class=3D"" style=3D"=
margin:0px;padding:0px;border:0px;vertical-align:baseline;background:transp=
arent"> $se</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0=
px;vertical-align:baseline;background:transparent">-></span><span class=
=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;ba=
ckground:transparent">fetch</span><span class=3D"" style=3D"margin:0px;padd=
ing:0px;border:0px;vertical-align:baseline;background:transparent">(</span>=
<span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:=
baseline;background:transparent">PDO</span><span class=3D"" style=3D"margin=
:0px;padding:0px;border:0px;vertical-align:baseline;background:transparent"=
>::</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;verti=
cal-align:baseline;background:transparent">FETCH_ASSOC</span><span class=3D=
"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;backg=
round:transparent">)</span><span class=3D"" style=3D"margin:0px;padding:0px=
;border:0px;vertical-align:baseline;background:transparent"> </span><span c=
lass=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:baselin=
e;background:transparent">){</span><span class=3D"" style=3D"margin:0px;pad=
ding:0px;border:0px;vertical-align:baseline;background:transparent">
echo $s</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0=
px;vertical-align:baseline;background:transparent">[</span><span class=3D""=
style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;color:r=
gb(128,0,0);background:transparent">'HoursWorked'</span><span class=
=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;ba=
ckground:transparent">].</span><span class=3D"" style=3D"margin:0px;padding=
:0px;border:0px;vertical-align:baseline;background:transparent"> PHP_EOL</s=
pan><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-al=
ign:baseline;background:transparent">;</span><span class=3D"" style=3D"marg=
in:0px;padding:0px;border:0px;vertical-align:baseline;background:transparen=
t">
</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical=
-align:baseline;background:transparent">}</span></code></pre><p style=3D"ma=
rgin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:basel=
ine;clear:both;color:rgb(0,0,0);font-family:Arial,'Liberation Sans'=
,'DejaVu Sans',sans-serif;line-height:17.804800033569336px;backgrou=
nd-image:initial;background-repeat:initial">
I have also tried to dump the result, but the value is like that as soon as=
I fetch it.</p><p style=3D"margin:0px 0px 1em;padding:0px;border:0px;font-=
size:14px;vertical-align:baseline;clear:both;color:rgb(0,0,0);font-family:A=
rial,'Liberation Sans','DejaVu Sans',sans-serif;line-height=
:17.804800033569336px;background-image:initial;background-repeat:initial">
Here is the connection:</p><pre class=3D"" style=3D"margin-top:0px;margin-b=
ottom:10px;padding:5px;border:0px;font-size:14px;vertical-align:baseline;fo=
nt-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mo=
no','DejaVu Sans Mono','Bitstream Vera Sans Mono','=
Courier New',monospace,serif;overflow:auto;width:auto;max-height:600px;=
word-wrap:normal;color:rgb(0,0,0);line-height:17.804800033569336px;backgrou=
nd:rgb(238,238,238)">
<code style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;fo=
nt-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mo=
no','DejaVu Sans Mono','Bitstream Vera Sans Mono','=
Courier New',monospace,serif;white-space:inherit;background-image:initi=
al;background-repeat:initial"><span class=3D"" style=3D"margin:0px;padding:=
0px;border:0px;vertical-align:baseline;color:rgb(0,0,139);background:transp=
arent">new</span><span class=3D"" style=3D"margin:0px;padding:0px;border:0p=
x;vertical-align:baseline;background:transparent"> PDO</span><span class=3D=
"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:baseline;backg=
round:transparent">(</span><span class=3D"" style=3D"margin:0px;padding:0px=
;border:0px;vertical-align:baseline;color:rgb(128,0,0);background:transpare=
nt">"odbc:DRIVER=3DMDBTools;DSN=3DMYMDB;UID=3D;PWD=3D;"</span><sp=
an class=3D"" style=3D"margin:0px;padding:0px;border:0px;vertical-align:bas=
eline;background:transparent">);</span></code></pre>
<div>I don't know what could be wrong, but perhaps someone here has an =
idea?</div><div><br></div><div>Version info:</div><div>
<p class=3D"">Name=C2=A0 =C2=A0 =C2=A0 =C2=A0 : mdbtools</p>
<p class=3D"">Arch=C2=A0 =C2=A0 =C2=A0 =C2=A0 : x86_64</p>
<p class=3D"">Version =C2=A0 =C2=A0 : 0.6</p>
<p class=3D"">Release =C2=A0 =C2=A0 : 0.7.cvs20051109.el6.1</p></div><div><=
br><div><div dir=3D"ltr"><div><img src=3D"http://mcinet.no/gfx/logo.png" wi=
dth=3D"200" height=3D"31"></div><div>Martin Landsem</div><div><div><div>(+4=
7) 957 06 206</div>
<div><a href=3D"mailto:[email protected]" style=3D"background-colo=
r:rgb(255,255,255)" target=3D"_blank"><font color=3D"#0000ff">martin@landse=
msolutions.no</font></a></div><div><a href=3D"http://landsemsolutions.no" s=
tyle=3D"background-color:rgb(255,255,255)" target=3D"_blank"><font color=3D=
"#0000ff">landsemsolutions.no</font></a></div>
</div></div></div></div>
</div></div>
--001a113397e4e9afac0501a1b198--
--===============7505436779167002586==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
------------------------------------------------------------------------------
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
--===============7505436779167002586==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
mdbtools-dev mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
--===============7505436779167002586==--