PostgreSQL error on db.currs_stats[0] = {..}

13 views
Skip to first unread message

Dmitrii Ermolaev

unread,
Nov 14, 2020, 9:04:47 AM11/14/20
to web2py-users
if not currs_stats:
   db.currs_stats[0] = {
   'curr_id': curr_id,
   'deal_id': deal_id,
   'average_': volume_out,
   'count_': 1,
   }

on MySQl all work

error: No such record: 0

Kevin Keller

unread,
Nov 14, 2020, 9:33:24 AM11/14/20
to web2py-users, Leonel Câmara
Probably also something for @Leonel Câmara .

Can you compare the raw sql of Mysql and PostgreSQL of what you are trying to do please? 

And post it here, then we can probably see what needs to be done. 

Thanks!

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web2py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/4237a051-f333-4464-a12e-ba76208a1f39n%40googlegroups.com.
Message has been deleted

Dmitrii Ermolaev

unread,
Nov 15, 2020, 8:04:54 AM11/15/20
to web2py-users
I update all this code by INSERT

суббота, 14 ноября 2020 г. в 12:33:24 UTC+3, kell...@gmail.com:
Reply all
Reply to author
Forward
0 new messages