Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

WwwxxXdbf, procmail "FROM_MAILER" patch, Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF, 078274121

Links

XODOX
Impressum

#1: "Money" fields are returned as "float".

Posted on 2011-02-16 03:07:29 by Vernon Cole

--001636c925357557d0049c5cbf32
Content-Type: text/plain; charset=ISO-8859-1

I ran across this while adding explicit PostgreSQL support to
adodbapi<http://sourceforge.net/projects/adodbapi/>
..
I am using psqlodbc_09_00_0200 which I downloaded this morning.
When I store a field of type "money", which, IIUC, is stored in an exact
format, I get back from ODBC a double float.
This is very interesting, since I cannot use a floating value to input the
same field, and thus cannot perform a store of something I am about to
read.

In my humble opinion, you should be accepting and returning a decimal type.
--
Vernon Cole

P.S.: Is this the correct place to make this comment?

--001636c925357557d0049c5cbf32
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I ran across this while adding explicit PostgreSQL support to <a href=3D"ht=
tp://sourceforge.net/projects/adodbapi/">adodbapi</a>.<br>I am using psqlod=
bc_09_00_0200 which I downloaded this morning.<br>When I store a field of t=
ype &quot;money&quot;, which, IIUC, is stored in an exact format, I get bac=
k from ODBC a double float.<br>

This is very interesting, since I cannot use a floating value to input the =
same field, and thus cannot perform a store of something I am about to read=
..=A0 <br><br>In my humble opinion, you should be accepting and returning a =
decimal type.<br>

--<br>Vernon Cole<br><br>P.S.: Is this the correct place to make this comme=
nt?<br><br>

--001636c925357557d0049c5cbf32--

Report this message