Re: Re: Bug Found??

How-To-Repeat:

OS: Windows 2000 Advanced Server
MySQL: 3.23.53
MyODBC: 2.50.39

When I attempt the following SQL select from an ASP page:

SELECT CONCAT(C_Client,'|',DivId)
FROM C_Clients C INNER JOIN C_Divisions D ON C.ClientId = D.ClientId
ORDER BY 1 ASC

The resulting recordset gives me question marks instead of real data. There
seems to be four criteria involved in giving this problematic recordset:

1. I run this via the ODBC connector
2. I concatenate varchar with bigint
3. The fields come from different tables
4. I use the ORDER BY statement

The SQL query works correctly when I enter it directly at a command line. Are
you the correct people to be giving this information to?

Thanks.
Danny


________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag

------------------------------------------------------------ ---------
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 bugs-thread13528@lists.mysql.com
To unsubscribe, e-mail