Ed Eden wrote:
So this is the crashing SQL-query. Does DB2 have a problem with like and numeric fields? Perhaps I should ask our DB2-specialists. Any other ideas?Entering sub doQuery query: select * from certificate where (req_key like ?) order by cert_key bind_values: 256 prepare statement statement nr.: 2 prepare failed query: select * from certificate where (req_key like ?) order by cert_key returned errorcode: 42884
Can you test the following queries on your database?
select * from certificate where (req_key like 256) order by cert_key
select * from certificate where (req_key = 256) order by cert_key
If the second query works and the first query fails then I can build a patch for the problem.
Michael
--
-------------------------------------------------------------------
Michael Bell Email (private): [EMAIL PROTECTED]
Rechenzentrum - Datacenter Email: [EMAIL PROTECTED]
Humboldt-University of Berlin Tel.: +49 (0)30-2093 2482
Unter den Linden 6 Fax: +49 (0)30-2093 2959
10099 Berlin
Germany http://www.openca.org
-------------------------------------------------------
This SF.net email is sponsored by: Microsoft Visual Studio.NET comprehensive development tool, built to increase your productivity. Try a free online hosted session at:
http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en
_______________________________________________
Openca-Users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-users
