"Nyström, Rasmus" writes:
> How come the query
>
> SELECT
> CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modif
> ied,bugstatus,submitter), '"') FROM tbl_bug;
>
> returns something like
> "4","4","4"
> "10","10","10"
>
> while only
>
> SELECT
> CONCAT_WS(';',title,prio,category,program,bugdesc,created,modified,bugstatus
> ,submitter) FROM tbl_bug;
>
> returns the intended result except that the values are not confined withing
> '"'.
> that is
>
> Tough Bug,1,3,4,A very long description....
>
> I do understand why the second query returns what it returns, but the first
> one should not return what it returns, right?
>
> Am I clear enough?
>
> I'm using 2.23.33 on Windows 2000 Server.
>
> / Rasmus Nyström
>
Hi!
Please try our 3.23.35 for Windows and see if problem reccurs.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
