|Come for the quick hacks, stay for the epiphanies.|
Re^4: fetchall_arrayref hangs with placeholders query with no resultsby afoken (Chancellor)
|on Apr 29, 2021 at 10:39 UTC||Need Help??|
The untyped variable ? is allowed only in ...
That's a problem of missing type information and does not make select ? completely illegal in all SQL implementations, not even in Sybase ASE.
Try adding type information like I did for PostgreSQL. Actually, just copy my PostgreSQL example and change the connect line to connect to Sybase. I would expect that to work in Sybase ASE.
Should that fail, try to cast the (untyped) placeholder to a type. According to my first google result, SELECT CAST(? AS NUMERIC) ANSWER should do the trick.
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)