Bug #3921

try to excetue concat_ws

Details

Submitted	2005-03-22 19:39 UTC
From	vicholin at gmail dot com
Status	No Feedback
Package	MDB2
PHP Version	5.0.3
OS	windows xp
Roadmaps	(Not assigned)

Comments

[2005-03-22 19:39 UTC] vicholin at gmail dot com

Description:
------------
I'm using Pear, and when i try to execute a query i get a DB Error: unknown error. My query is simple I'm just trying to select name an last_name and concat it with an space, but i get the error, i don't know why is that

Note: in phpmyadmin everything goes fine.

Reproduce code:
---------------
$sql ="select concat_ws(' ',name, last_name)
from employee
where ci not in (select ci from despido)";

Expected result:
----------------
the name and last name separated with a blank space.

Actual result:
--------------
DB Error: unknown error
that is the error, i guess i can't be more explicit.

[2005-03-22 19:42 UTC] smith at backendmedia dot com

can you provide a bit more code .. especially which method you are using to execute the query .. also give me the output from both $err->getMessage() and $err->getUserinfo() ...

[2005-06-03 07:51 UTC] smith at backendmedia dot com

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.