Re: [Pypgsql-users] money types, decimal module

[Timothy S. <ti...@op...>]

Update on whats happening.
i did a "print TillName" right before attempting to do my insert into 
and there is no "" appended there.
here is the problem line

cur.execute("INSERT INTO DailyTakings VALUES (%s, %s, %s, %s, %s, %s, 
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s )",
    (EnteredBy,    DateEntered,ForDate, ForVenue, TillName,Tape,Cash, 
GM, VenueManager, AsstManager, BarManager, PRCards,    otherPromo, 
Functions, Accounts, Spill, Orings, Variance))

Timothy Smith wrote:

> hello i'm stuck with a problem. whats the best way to store money 
> types. i know postgre has it's own money data type, but the problem is 
> pythons decminal module. floats obviously aren't arrcurate enough, but 
> when i use the decminal modle i get this error.
>
> libpq.OperationalError: ERROR:  syntax error at or near ""11.00"" at 
> character 88
>
> obviously it's double quotes which are the problem. i'm just stumped 
> where to go from here. surely other people have run into the exact 
> same problem?
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> Pypgsql-users mailing list
> Pyp...@li...
> https://lists.sourceforge.net/lists/listinfo/pypgsql-users
>
>