Robert Fraser wrote: > Hi > > I am getting an error with recording a payment (1.2.0RC5, Postgres 8.1.8): > > *DBD::Pg::st execute failed: ERROR: invalid input syntax for type date: "" > *Error!
Well what it is telling you is, the date you supplied for the payment is missing :). I don't actully recall if we supply that date or it if is supposed to be user supplied. > > * > INSERT INTO acc_trans > (trans_id, chart_id, transdate, > amount, source, memo) > VALUES (?, (SELECT id > FROM chart > WHERE accno = ?), > ?, ?, ?, ?) > ERROR: invalid input syntax for type date: ""* > > Any pointers to what this might be? > > Thanks > > Rob > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > ------------------------------------------------------------------------ > > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
